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
  • Sybase IQ
  • Vertica


The reader of this information has to be familiar with:

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