Replication from Oracle to Sybase IQ Using Real-Time Loading

You can use real-time loading (RTL) to replicate from Oracle to Sybase IQ in the Real-Time Loading Edition (RTLE) of Replication Server 15.6.

• Real-Time Loading Solution
  RTL groups together as many compilable transactions as possible, compiles the transactions in the group into a net change, then uses the bulk interface in the replicate database to apply the net change to the replicate database.
• Sybase IQ Replicate Data Servers
  The replicate Replication Server interacts directly with the replicate Sybase IQ data server by logging in to the Sybase IQ replicate database and applying the replicated transactions.
• Replication Intrusions and Impacts on Sybase IQ
  The only significant intrusions or impacts to the Sybase IQ replicate database are the system tables created in the Sybase IQ replicate database through the connection profile, and temporary tables created in the Sybase IQ replicate database to accommodate RTL bulk apply.
• Replicate Database Connectivity for Sybase IQ
  You do not need to use a database gateway when you use Sybase IQ as a replicate data server; the replicate Replication Server connects directly to the Sybase IQ replicate data server.
• Sybase IQ Replicate Database Permissions
  To apply transactions in a replicate database, Replication Server and Sybase IQ require a maintenance user ID.
• Sybase IQ Replicate Database Configuration Issues
  Learn about the configuration issues for the Sybase IQ server.
• Scenario for Replication to Sybase IQ
  Use this scenario to learn how to set up and test replication to Sybase IQ using RTL.
• Tables with Referential Constraints
  You can use a replication definition to specify tables that have referential constraints, such as a foreign key and other check constraints, so that RTL is aware of these tables.
• Display RTL Information
  You can display information on configuration parameter properties and table references.
• Net-Change Database
  Replication Server has a net-change database that acts as an in-memory repository for storing the net-row changes of a transaction, that is, the compiled transaction.
• Mixed-Version Support and Backward Compatibility
  RTL can replicate referential constraints specified in replication definitions only if the outbound route version is later than 15.5.
• Migrating from the Staging Solution to RTL
  Migrate to the real-time loading solution if you are currently using the staging solution for replication to Sybase IQ.