This section describes the SQL Loader agent. This is a processing agent for batch workflow configurations.

The SQL Loader agent is a batch processing agent designed to populate the database with data from existing files, either residing in a local directory or on the server filesystem of the database.

Data can be collected using either the Disk, FTP, or SFTP agents, and supported databases are; PostgreSQL, SAP HANA, and Sybase IQ. 

Workflow Configuration 

The Disk, FTP and SFTP agents have an additional check box called Route FileReferenceUDR  in their configuration dialogs.

This check box should be selected when using the SQL Loader agent. 

The SQL Loader agent then forwards an SQLLoaderResultUDR containing information about loaded file, number of inserted rows, execution time and any error messages, for logging purposes. 

The section contains the following subsections:

• SQL Loader UDR Types(4.2)
• SQL Loader Configuration(4.2)
• SQL Statements for SQL Loader(4.2)