Execute ETL Service (com.ibi.agents.XDETLAgent)

Syntax:

com.ibi.agents.XDETLAgent

Description:

Executes EDA ETL procedures and returns ICM codes to specified edges. You can invoke this service from a process flow. For more information, see the iWay Integration Tools Designer User's Guide.

Parameters:

Parameter	Description
SQL DML *	SQL statement.
Data Source URL *	URL to reach the data source.
Document Return Type *	Document to return. Select one of the following options from the drop-down list: Status Original Input Statistics
User ID	Default user ID for the connection.
Password	Default password for the connection.
Search Code	Search code to search for (for example, XXX,YYY,ZZZ).
Statistic Handler	The RPC to call to fetch ETL statistics. Called only when return document is set to Statistics.
Handler Parameters	Parameters passed to the Statistic Handler.
Stats Wait	The amount of time in seconds to wait after an unsuccessful attempt to retrieve statistics.
Stats Retry	The number of attempts to try retrieving ETL statistics.

Edges:

The following table lists the available line edges for the Execute ETL Service (com.ibi.agents.XDETLAgent).

Line Edge	Description
OnError	Error
OnSuccess	Success
OnFailure	Failure
OnCustom	OnError OnSuccess OnFailure fail_connect fail_parse