Skip to content

Analysis Models - Data Loads

This page provides information about Tabular Data Source Load specific functionality in IFS Cloud.

Use this page to learn more how to create a Data Load Definition, how to configure a Data Load Configuration and how to run the definition.

Data Load Definition

A Data Load Definition is a placeholder for a set of Tabular Data Sources to be part of a Data Load Run that transfers data from an IFS Cloud Oracle database to a target SQL Server database. A load definition can be created in two ways:

  • Generate a Load Definition for a Tabular Model
  • Manual creation

Generating a Load Definition for a Tabular Model

Start on Tabular Models page, select a model and go to the detail page.

Use the command New Data Load Definition.

In the dialog provide a Data Load Definition ID and press OK.

The Data Load Configurations page will appear.

The details of a Data Load Definition represent the Data Load Configurations.

Creating a Load Definition Manually

Use the Data Load Definitions page.

Enter a new record and define the Data Load Definition ID and a Description of the definition and save to create a new data load definition.

Go to details to open the Data Load Configurations page

Data Load Configurations

The Data Load Configurations page represents the details for a specfic load definition.

There is an indicator in the Data Load Definitions group that defines if any of the included Data Sources are also included in other load definitions.

On this page, each Data Source can be configured, i.e. Load Type to be used, if the load should consider a Where Condition to reduce/specify the volume and if truncation should be done or not.

Attribute Description
Data Source ID Identity of the Tabular Data Source
Load Type Defines the load type that applies for the source. The load type defined for the Data Source ID is suggested when a load definition/configuration is generated.
  • Full
    The source table in SQL Server is loaded fully
  • Conditional
    The source table in SQL Server is loaded conditionally
  • Incremental

  • The source type in SQL Server is loaded incrementally. Can only be defined if the Tabular Data Source supports incremental loading.
Where Condition Where condition to be used if the Load Type is Conditional.

The Conditional Where defined for the Data Source ID is suggested when a load definition/configuration is generated.
Condition Active Indicates if the Conditional Where is used for the current Load Type. Switching from Conditional to Full load will keep the condition but is it not used.
Referenced by Other Load Definitions Indicates if the Data Source is included in other load definitions.
Sequential Set ID A sequential set is a group of data sources that should be executed as a group, mainly due to dependency issues.
Sequence Defines the order of execution within a sequential set.

Defining the Sequential Set ID and Sequence is typically needed for data sources that are dependent on other sources, i.e. data for the dependent sources must have been transferred firs or necessary dayabase objects must have been created. For generated definitions the set information is created automatically.

Find more information in Data Load Definition and Volume Configuration page.

Data Load Runs

When the Data Load Definition details, i.e. the data load configurations, are done, the next step would be to run a data load.

This can be done manually or as a scheduled job.

All load runs for a give definition are found in the Data Load Configurations page in the group Data Load Runs.

Attribute Description
Data Load Run ID Identity of the Data Load Run
Start Time Time when the run started
End Time Time when the run ended
Duration (seconds) Duration in seconds
Log File Provides log information specific for one data load run.

Each Run ID represents one load run. The details of the run are presented in the Data Load Runs page.

Attribute Description
Data Load Definition
Data Load Definition ID Identity of the Data Load Definition that the load run is associated with.
Data Load Run ID Identity of the Data Load Run
Start Time Time when the run started
End Time Time when the run ended
Duration (seconds) Duration in seconds
Status Presents the latest retrieved status of the load run.
Data Load Run Items
Data Source ID Identity of a Tabular Data Source that is part of the load run.
Status Latest retrieved status of the load run item
Start Time Execution start time for the load run item
End Time Execution end time for the load run item
Duration (seconds) Execution time in seconds for the load run item
SSIS Execution ID SSIS execution identity associated with load run item. Can be used to find more information in e.g. the SSIS Custom Event Logs where the identity is named Operation ID.
Log Shows an execution summary

Find more information in Data Load Definition and Volume Configuration page.

For log information, please refer to the Logs page.

Data Configurations

Data configurations are taken into account when the Tabular Models are processed, by filtering some of the available data in the SQL Server database.

More details are found by using the following link >>