Custom SQL export

The Custom SQL Export adapter allows you to request data from IEE for export to a CSV or XML file. With this adapter you can run one or more SQL commands, or a stored procedure. The resulting export file reports the "Command Text" in addition to any data returned by SQL select queries.

Use the following procedure to configure a task template:

  1. Go to System Operations > Task Management > Task Templates.

  2. Use the dropdown menu to select the Task Type and Task Template. (Click Add to create a new task template. For more information, see Adding task templates.)

  3. Configure the Task specific parameters. These parameters are defined after step 5 of this procedure.

  4. Configure the Common task template parameters. For more information, see Task template parameters.

  5. Click Save.

Task specific parameters:

ClosedFile Type

Select the file type for the export file containing the data requested from IEE. Raw output provides data with no headers, footers, punctuation or other text describing the task.

ClosedExport File Name

Defines the export file name. You can enter a unique file name or accept the default. This parameter supports the standard IEE macros.

ClosedExport Directory

Defines the directory where IEE places the file containing exported data. Accept the IEE default file path or click Search to browse to a directory. This parameter supports the standard IEE macros. Reference as ($ExportDirectory) when configuring a task. Exported data is generated by an export task template or an export API.

ClosedCommand Text (Custom SQL Export)

In a custom export, the command text parameters can contain one or more database statements, or the name of a stored procedure. The output writes to the output file. The command text parameter has a different format for SQL Server and for Oracle. If the SQL Server command is used in an Oracle database environment, an Oracle error message is returned. Always use the correct syntax for your database.