Configuring the iWay CDC SQL Batch Agent

In this section:

How to:

The iWay CDC SQL Batch Agent applies SQL statements (INSERT, UPDATE, DELETE) to the target Oracle database tables.


Top of page

x
Procedure: How to Configure the iWay CDC SQL Batch Agent

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 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.


Top of page

x
Reference: iWay CDC SQL Batch Agent Configuration Parameters

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 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.



x
Creating the Configuration File (cdc.config)

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). The table(s) in the database is referenced by its OBJECT ID. To retrieve this OBJECT ID, you have to query the SQL Server database using the following command:

SELECT OBJECT_ID ('tablename')

where:

tablename

Is the name of the specific table.

Sample configuration file (cdc.config)

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="LoggingEnabled" value="true"/>
    <add key="LogFileFormat" value="SQLServerCDC"/>
    <add key="LogFolder" value="c:\\"/>
    <add key="MaxLogSize" value="20971520"/>
    <add key="MaxNumberOfLogBackups" value="0"/>
    <add key="NoRequestedOperations" value="10000"/>
  </appSettings>
  <dbSettings>		
    <Server>IWSQL2000-VM</Server>
    <Database>Northwind</Database>
    <Tables>885578193,901578250</Tables>
    <User>sa</User>
    <Password>sa</Password>
    <NTauth>false</NTauth>
     <ProductKey>a15ygC5/X8/0tj/cmmZfdOAbWdyQ/hzdR/JhIS2TDYg=</ProductKey>
  </dbSettings>
</configuration>

iWay Software