Creating the Connection to Sybase IQ

Set up the connection to the replicate Sybase IQ database.

  1. Use create connection with the using profile clause and the relavant connection profile, and specify your replicate Sybase IQ data server and database.
    For example to create a connection from an Oracle primary data server:
    create connection to IQSRVR.iqdb
using profile rs_oracle_to_iq;standard
set username to dbmaint
set password to dbmaint
go
    You can create multiple replication paths to the Sybase IQ database to distribute replication loads. Use a unique maintenance user ID for each path.
  2. Use admin who to verify that Replication Server connects successfully to Sybase IQ.
Parent topic: Replication Server Installation
Related concepts
Multi-Path Replication to Sybase IQ