Sybase IQ as Replicate Data Server

Learn about the replicate database issues and considerations specific to the Sybase IQ data server in a Sybase replication system and how to connect and configure replication to Sybase IQ.

Sybase IQ is the ideal platform for reporting and data analysis. However, to be more effective for reporting, Sybase IQ requires real time data.

Replication Server includes a real-time loading (RTL) solution for replication directly into Sybase IQ that you can use instead of the continuous replication mode that sends each logged change to the replicate database according to the primary database log-order.

Compared to the continuous replication mode, RTL achieves better performance when replicating directly into a Sybase IQ replicate database by performing compilation and bulk apply.

• Real-Time Loading Solution
  RTL groups as many compilable transactions as possible, compiles the transactions in the group into a net change, and 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
  Learn about the configuration issues for the Sybase IQ server.
• Scenario for Replication to Sybase IQ
  The scenario to set up replication to Sybase IQ using RTL and to test that replication works is described.
• 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.
• System Table Support in Replication Server
  Replication Server uses the rs_tbconfig table to store support table-level configuration parameters, and the ref_objowner and ref_objname columns in the rs_columns table to support referential constraints.
• 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.
• Migration 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.
• Replication Server and Sybase IQ InfoPrimer Integration
  Replication Server integrates with Sybase IQ InfoPrimer to support replication between a primary Adaptive Server database with a schema that is different from a replicate Sybase IQ database.