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
| Setting | Description |
|---|---|
| Database | Profile name of the database that the agent will connect to and forward data to. The supported database profiles are:
|
| 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 exception | Select this check box if you want the workflow to abort in case of an exception. |