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.

The following agents can be used for data collection:

• Disk
• FTP
• SFTP

The supported databases are:

• MySQL
• Netezza
• PostgreSQL
• SAP HANA
• Sybase IQ
• Vertica

Prerequisites

The reader of this information has to be familiar with:

• Structured Query Language (SQL)
• UDR structure and contents