Relational SQL Load

This load component can call arbitrary SQL statements to a relational database system to modify, update, or delete data. The SQL statement is entered in a free SQL editor. It can be used for CREATE, INSERT, UPDATE, DELETE, or DROP statements.

A connection to a relational database is required. In contrast to the relational load, it has no source assignment, so it is not related to any extracts or transforms.

For more information about Third party database systems that are supported by Integrator, read the Systems Supported by Integrator article.

Stored procedures

The load can be used to call any stored procedures in the relational database system. This offers a convenient way to centralize multiple or complex statements and call them easily.

Example:

Source: Existing relational Table:

Customer:
A
B
B
C

Value:
10
20
30
40

Customer:
C

Value:
5

Results:

Mode ADD, Aggregation=true
(Customer: Key, Update Mode: sum) 		Mode ADD, Aggregation=false

Customer:
A
B
C

Value:
10
50
45

Customer:
A
B
B
C
C

Value:
10
20
30
40
5


Mode ADD, Aggregation=true
(Customer: Key, Update Mode: last)


Mode UPDATE, Aggregation=false

Customer:
A
B
C

Value:
10
30
40

Customer:
A
B
B
C

Value:
10
20
30
40

 

Mode UPDATE, Aggregation=true
(Customer: Key, Update Mode: sum)
Customer:
A
B
C 		Value:
10
50
40

Running a load

To run the load, select Run from the toolbar, indicated in the screenshot below. The load executes using the variable values currently saved in the component.

screenshot indicated the Run button for integrator loads and jobs

screenshot indicated the Run button for loads and jobs

To run the load with different values without changing what's saved in the component, select Run with options from the dropdown next to Run. This opens a dialog listing the component's variables. Update any variable value as needed, then use the reset icon next to a field, or select Reset all, to restore its saved value. Select Run in the dialog to execute the load using those values; they apply only to that run. If the load has no variables, the dialog states that no variables are used; select Close and run the component normally instead.

To run the load with different values without changing what's saved in the component, select the arrow next to Run and choose Run with options. This opens a dialog listing the component's variables, where you can change values for this run only; the saved values are not affected.

Updated September 24, 2026