Scenario for Replication to Sybase IQ

Use this scenario to learn how to set up and test replication to Sybase IQ using RTL.

The Oracle database administrator (Oracle DBA), the Sybase IQ database administrator (IQ DBA), and you, as the replication system administrator (RSA), must prepare Oracle, Replication Server, and Sybase IQ for replication and set up the connection to the Sybase IQ database.

In this scenario, dbo is the table owner of the testtab table in the pdb1 database of the ORA_DS primary Oracle server. c1, c2, and c3 are columns in testtab with int, int, and char(10) datatypes respectively, and IQSRVR is the replicate Sybase IQ data server containing the iqdb database.

• Creating Interfaces File Entries
  Create an entry in the interfaces files of the replicate Replication Server and the Sybase IQ data server for each other.
• Creating Test Tables
  Create a test table in the primary and replicate databases, and grant maintenance user permissions to it to test that replication works.
• Creating the Connection to the Primary and Replicate Databases
  Create the primary and replicate database connections.
• Enabling RTL
  Enable RTL at the database level.
• Marking Tables to Prepare for Replication Testing
  Mark tables in the primary Oracle database that you want to replicate to the Sybase IQ database.
• Creating Replication Definitions and Subscriptions
  Create replication definitions and subscriptions for the tables marked for replication to Sybase IQ after you enable and configure RTL.
• Verifying That RTL Works
  Learn how to check that RTL works.