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 rs_oracle_to_iq connection profile, and specify your replicate Sybase IQ data server and database.
    For example:
    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.