x

For demonstration purposes only, this section describes how to configure the iWay CDC SQL Batch Agent using the iWay Service Manager Administration Console.

Note: The configuration of the iWay CDC SQL Batch Agent is usually performed in a process flow using iWay Designer in iWay Integration Tools.

1. From the Windows Start menu select All Programs, iWay 6.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 CDCSQL Batch Agent {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. Select ORACLE from the drop-down list.
Target Database *	The target database for the CDC data. Select one of the following databases from the drop-down list: ORACLE (default) SQLServer
JDBC Connection Properties (connect using Driver Manager)
Table File Path	File path table mappings properties file.
Column File Path	File path for column mappings properties file.
Data Source URL *	URL to access the target 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.

x

The column and table properties files referenced in the Table File Path and Column File Path parameters of the iWay CDC SQL Batch Agent are used to map column names or table names from the source database to the target. The format for both properties is a simple key value pair, such as COLUMNA=COLUMNB or TABLEA=TABLEB.

A usage case for the table properties file is when you are replicating changes from the Oracle table SCOTT.CLASSES to a table in SQL Server called classes. The entry SCOTT.CLASSES=SCOTT must be added to the table properties file.