Creating the Connection to SAP IQ

Set up the connection to the replicate SAP IQ database.

  1. Use create connection with the using profile clause and the relavant connection profile, and specify your replicate SAP 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 SAP 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 SAP IQ.