SQL Loader Agent Configuration

To open the SQL Loader agent configuration dialog from a workflow configuration, you can do either one of the following:

  • double-click the agent icon
  • select the agent icon and click the  Edit button

The Agent Configuration contains configurations related to the SQL query used for populating the database with data from external files, as well as error handling.

The SQL Loader agent configuration dialog

The SQL Loader tab 


Profile name of the database that the agent will connect to and forward data to.

The supported database profiles are:

  • MySQL
  • Netezza
  • PostgreSQL
  • Sybase IQ
SQL Statement

In this field you enter the SQL statement to be used for stating where the files containing the data are located, into which table in the database the data should be inserted, as well as the formatting of the data.

See SQL Statements for information about how to write the statements.

Abort if exceptionSelect this check box if you want the workflow to abort in case of an exception.