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.