In this section: |
The iWay Real Time Data Replication (RTDR) extension is composed of the SQL Batch Insert Iterator object and the Data Integration object.
Note: There is a known issue in iWay 7.x releases where performing a Test Run on a process flow containing the RTDR object causes the Test Run operation to hang without releasing the connection. This issue will be resolved in iWay Version 8. If you plan to use this functionality, then contact Customer Support and a backported patch for your iWay 7.x release will be provided. Please note, this known issue does not impact the runtime execution. A process flow containing the RTDR object will execute without any issues during runtime. You may also perform a Test Run on the process flow without any issues, by deploying the process flow to iSM and running it with the flow command. For more information on configuring and using the iSM flow command, see the iWay Service Manager Command Reference Guide.
In the simplest use case, the iWay RTDR extension can be used to replicate data from a source database to a target database. The source and target databases can be the same or different types. Both databases must exist prior to replication.
In a more complex use case, the iWay RTDR extension can be used to extract data one row at a time from a source database, cleanse or transform the data, and then insert the row into another database. The source and target databases must exist prior to execution.
| iWay Software |