Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Image Added 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.

Image Added

The SQL Loader agent configuration dialog

The SQL Loader tab 

SettingDescription
Database

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

The supported database profiles are:

  • MySQL
  • Netezza
  • PostgreSQL
  • SAP HANA
  • 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.