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