SQL Loader Agent
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
The section contains the following subsections:
- SQL Loader Agent Configuration
- SQL Loader Agent Events
- SQL Loader Agent Input/Output Data and MIM
- SQL Loader Agent Transaction Behavior
- SQL Loader Agent UDRs
- SQL Statements