This checklist covers all the tasks required to preparing the target operating environment and configure Straight Oracle Replication. It assumes two things: First that a Oracle system exists on the target platform. Second, that the Oracle LogMiner API Capture has been configured and tested on the Source platform, see that Implementation Checklist.
| # | Task |
| Prepare Environment | |
| 1 | Perform the base product installation on the Target System |
| 2 | Identify/Authorize/Prepare Operating User(s) |
| 3 | Verify Execution Authorization of Connect CDC SQData components |
| 4 | Create Variables Directories |
| Environment Preparation Complete |
| Engine Configuration Tasks | |
| 1 | Create Application Directory Structure |
| 2 | Collect DDL for tables to be replicated and Create Target tables |
| 3 | Generate Public/Private Keys for Engine, Update Auth Key File on Source System |
| 4 | Create Straight Replication Script |
| 5 | Prepare Engine Shell Script |
| Engine Configuration Complete | |
| Verification Tasks | |
| 1 | Start the Oracle Capture agent and SQDAEMON on Source System |
| 2 | Start the Engine on Target System |
| 3 | Apply changes to the source tables using SQLPlus or other means. |
| 4 | Verify that changes were captured and processed by Engine |
| Verification Complete | |
The following sections focus on the Engine Configuration and communication with the Source platform Controller Daemon. Detailed descriptions of the other steps required to prepare the environment for SQData operation are described in previous sections.