Skip to main content
Feedback

Oracle SQL*Loader operation

The Oracle SQL*Loader connector supports only the Create action.

Create

Create is an outbound action that translates data from an XML profile to the SQL data type to insert data in a new record into the target Oracle table.

Boomi Integration handles standard Oracle data types, such as dates and times, numbers, and characters. Because the Oracle SQL*Loader connector expects input data to be in XML format, you might need to map the input data to XML before sending it to the connector.

The Oracle SQL*Loader supports advanced data types, including:

Options tab

Click Import Operation, then use the Import wizard to select the object with which you want to integrate. The following fields appear on the Options tab:

Object - Displays the object type that you selected in the Import Operation wizard.

Tracking Direction - Select the document tracking direction for the operation, either Input Documents or Output Documents. This setting enables you to choose which document appears in Process Reporting. Start steps always track output documents regardless of your selection.

note

If the tracking direction is read-only, the feature to change the direction is either unavailable or the developer set the configuration to read-only. The default value you see shows you which document appears in Process Reporting.

Response Profile - Select or add an XML profile component that represents the structure received by the connector.

Return Application Error Responses - This setting controls whether an application error prevents an operation from completing:

  • If you clear the setting, the process stops and reports the error on the Process Reporting page.
  • If you select the setting, processing continues and passes the error response to the next component processed as the connection output.

Table Pattern - (Optional) A string pattern to use when browsing to filter the number of tables in the results.

ID Column Name - (Optional) Name of the column that stores the sequence value. It uses the default sequence to generate the value.

Use Unicode Character Format - Select this option if the input data is in Unicode character format. If cleared, it does not interpret special characters correctly and the data can become corrupted. Input data is UTF-16 encoding format.

Keep Null Values - If selected, it retains null values in the input data, rather than applying configured default values. Clearing the check box is the default.

Maximum Number of Errors - The maximum number of errors allowed before the SQL*Loader process ends. The default is 10.

Check Constraint During Import - If selected, it checks the constraints on the target table or view when you import data.

If cleared (the default), it locks the table and validates the input data against the constraints after importing all data. Clear this option to improve performance.

Parallel Load - Select only if the process uses the Flow Control step when you select the Parallel Processing option prior to invoking this connector. When selected, it enables multiple bulk uploads to the same target table in parallel.

The default is clearing the check box. Usually, you do not need this option.

Debug Mode - When selected, it does not delete temporary files after the process runs. If selected, the temporary files (the Oracle SQL*Loader control file, Oracle SQL*Loader log file and Oracle SQL*Loader errors file) are in the system \temp directory on the server on which you install the basic runtime. The file names all start with blk_. The default is clearing the check box.

Archiving tab

See the topic Connector operation’s Archiving tab for more information.

Tracking tab

See the topic Connector operation’s Tracking tab for more information.

Caching tab

See the topic Connector operation’s Caching tab for more information.

On this Page