How to: |
The iWay CDC SQL Batch Agent applies SQL statements (INSERT, UPDATE, DELETE) to the target Oracle database tables.
To configure the iWay CDC SQL Batch Agent using the iWay Service Manager Administration Console:
The Service pane opens, as shown in the following image.
The table that is provided lists existing services and a short description for each.
The Services Type pane opens.
The configuration parameters pane for the iWay CDC SQL Batch Agent opens.
The Name and Description pane opens.
The new iWay CDC SQL Batch Agent (SQLBatchAgent_Service) is added to the list in the Services pane.
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:
|
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. |
iWay Software |