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

Updated September 27, 2022