x

To configure the iWay CDC SQL Batch Agent using the iWay Service Manager Administration Console:

1. From the Windows Start menu select All Programs, iWay 7.0 Service Manager, and then Console.

   

2. Click Registry in the top pane.

   

3. In the left pane, select Services.

   

   The Service pane opens, as shown in the following image.

   

   The table that is provided lists existing services and a short description for each.

4. Click Add.

   The Services Type pane opens.

   

5. Select com.ibi.agents.XDCDCSQLBatchAgent from the Type drop-down list and click Next.

   The configuration parameters pane for the iWay CDC SQL Batch Agent opens.

   

6. Provide the required configuration parameters for the new agent, which are described in iWay CDC SQL Batch Agent Configuration Parameters.
7. Click Next.

   The Name and Description pane opens.

8. In the Name field, type a name to identify the iWay CDC SQL Batch Agent (for example, SQLBatchAgent_Service).
9. In the Description field, type an optional description for the iWay CDC SQL Batch Agent.
10. Click Finish.

    The new iWay CDC SQL Batch Agent (SQLBatchAgent_Service) is added to the list in the Services pane.

x

Parameter	Description
Configuration parameters for CDCSQL Batch Agent service
Source Database *	The source database for the CDC data. The following databases are available from the drop-down list: INFORMIX (default) ORACLE SQLServer
Target Database *	The target database for the CDC data. ORACLE is the database option that is selected by default.
JDBC DataSource Properties (connect using DataSource via JNDI)
JNDI Name	JNDI name for the requested database. To use an iWay JDBC provider, specify as jdbc/provider. This is a required parameter if you are using JNDI.
JDBC Connection Properties (connect using Driver Manager)
Table File Path	File path for property files for column map for tables.
Column File Path	File path for property files for column map for tables.
Data Source URL	URL to reach the data source. This parameter is required unless you are using a JNDI data source.
JDBC Driver	JDBC driver to use. This parameter is required unless you are using a JNDI data source.
User ID	Default user ID for the connection.
Password	Default password for the connection.
Batch Type	Represents a batch execute with auto commit or manual commit options. Select one of the following commit types from the drop-down list: Auto Commits automatically regardless of the batch size. Manual Splits the entire batch by the value that is specified in the Batch Size field. In addition, a batch execute is applied on the sub-batches and eventually an exclusive commit is applied after all the sub-batches are executed.
Batch Size	If Manual is selected from the Batch Type drop-down list, then specify the batch size that you want to set in this field.