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 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. 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	Select one of the following batch types from the drop-down list: Auto Commits after 10K records. Manual Specify the batch size that you want to set in the Batch Size field.
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.

x

The cdc.config file allows you to set the connection parameters to connect to the SQL Server database which is then read by the iWay CDC SQL Batch Agent (XDCDCSQLBatchAgent).

Sample configuration file (cdc.config)

<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2010 (http://www.altova.com)-->
<tns:executeLEA location="/iwsqlsrvlogevent.dll/SqlTransaction.SqlTransaction/
executeLEA(System.String,System.String,System.String,
System.String,System.Boolean,System.String,System.Boolean,
System.String,System.String,System.Int32,System.Int32,System.Int32,
System.String,System.String)"
xmlns:tns="urn:iwaysoftware:ibse:jul2003:executeLEA">
  <servername>NXCXP3\NXC</servername>
  <database>Northwind</database>
  <user>sa</user>
  <password>test</password>
  <ntauth>false</ntauth>
  <productKey>2BxSWPUs+zudLOUymunlnSnWiZOKSHeIxM8SB2I29ak=</productKey>
  <logEnabled>true</logEnabled>
  <logFileFormat>SQLLEA</logFileFormat>
  <logFolder>C:\test\sqllog1.log</logFolder>
  <maxLogSize>2147</maxLogSize>
  <maxNumberOfLogBackups>2147</maxNumberOfLogBackups>
  <numRequestedOperations>2147</numRequestedOperations>
  <tables>region</tables>
  <markerFile>C:\test\marker1.txt</markerFile>
</tns:executeLEA>

You can subscribe to multiple tables in the database by simply separating the table names with commas.