Toad Intelligence Central operation

The Toad Intelligence Central operation defines how to interact with your Toad Intelligence Central data repository, and supports the outbound Execute action to create or update a Toad Intelligence Central data set.

To complete creating a new Toad Intelligence Central operation, click Import Operation to initialize the profiles.

Options tab

Connector Action - Execute is the only available action in this operation.

Object - The Toad Intelligence Central object with which to integrate is selected by default.

Return Application Error Responses - When an error prevents an operation from completing, this setting does the following:

• If cleared, aborts the process and reports the error on the Process Reporting page.

• If selected, continues processing and passes the error response to the next component to be processed as the connection output.

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.

Runtime - Used to select the basic runtime. If your basic runtime does not appear in the list, see the Runtime Management topic for more information.

Connection - Used to browse for and select the Toad Intelligence Central connection, edit the connection settings, or add a new Toad Intelligence Central connection.

Table - The name of the Toad Intelligence Central data set to create to store data.

Columns - Used to create the columns of the data set. Enter the column or field name, space, and column or field type. The supported column types are: varchar, bigint (20), datetime, and double. Separate multiple entries with commas. For example:

first_name varchar,last_name varchar(100),id bigint,created_on datetime,salary double

Size specification for double column types is not supported.

Primary Keys - (Optional) A comma-separated list of column names that is combined into a primary key for the data set.

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.