SAP IQ as Replicate Data Server

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

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

Replication Server includes a real-time loading (RTL) solution for replication directly into SAP 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 an SAP 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.
• SAP IQ Replicate Data Servers
  The replicate Replication Server interacts directly with the replicate SAP IQ data server by logging in to the SAP IQ replicate database and applying the replicated transactions.
• Replication Intrusions and Impacts on SAP IQ
  The only significant intrusions or impacts to the SAP IQ replicate database are the system tables created in the SAP IQ replicate database through the connection profile, and temporary tables created in the SAP IQ replicate database to accommodate RTL bulk apply.
• Replicate Database Connectivity for SAP IQ
  You do not need to use a database gateway when you use SAP IQ as a replicate data server; the replicate Replication Server connects directly to the SAP IQ replicate data server.
• SAP IQ Replicate Database Permissions
  To apply transactions in a replicate database, Replication Server and SAP IQ require a maintenance user ID.
• SAP IQ Replicate Database Configuration
  Learn about the configuration issues for the SAP IQ server.
• Multi-Path Replication to SAP IQ
  Create multiple connections from Replication Server to the replicate SAP IQ database to increase replication throughput and performance, and reduce latency and contention.
• 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.
• Scenario for Replication to SAP IQ
  The scenario to set up replication to SAP IQ using RTL and to test that replication works is described.
• 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 SAP IQ.
• Replication Server and SAP IQ InfoPrimer Integration
  Replication Server integrates with SAP IQ InfoPrimer to support replication between a primary Adaptive Server database with a schema that is different from a replicate SAP IQ database.