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
  2. Use admin who to verify that Replication Server connects successfully to Sybase IQ.