BIRT Analytics Loader supports creating data load transactions, setting load process options, and running a set of transactions as a process. To create a load process, first create the transactions that load data. Then, set options that run the load process.
About transactions
A transaction includes all settings and data mappings required to load data into a single table. A load process executes multiple transactions. You must save any change that you make to a load process before executing the process. To save any change to a process, choose Save on the menu bar.
BIRT Analytics Options, for defining a process and tools for creating transactions, looks like the example shown in Figure 3‑22.
Figure 3‑22 Defining data
Setting load process options
Use Options, shown in Figure 3‑23, to select options that define a load process. The settings that you save for each process execute when the process runs, as part of a data load project.
Figure 3‑23 Defining load process options
Select or specify values for each option to execute the following process tasks:
Load
Select Load to execute all load transactions when a project runs.
Transform
Select Transform to execute all transformation scripts when a project runs. Define transformation rules using the Transformation tab.
Notify
Type a value that sets a trigger to write a log message each time the set number of records loads.
Sample
Specify the number of records loaded for each table.
Ignoring items during the load process
Users can choose to have items (tables, instructions) ignored during the loading process in the Data tab (it can also be done in the Transform tab). Clicking on the “check” or “minus” symbols in the “Active” column in the Data tab, as shown in Figure 3‑24 allows Users to have chosen elements ignored by the loading process (toggling them on and off). The contents of ignored item rows appear in italics.
Load
