Replicate database connectivity for Sybase IQ

You do not need to use a database gateway when you use Sybase IQ as a replicate data server; the replicate Replication Server connects directly to the Sybase IQ replicate data server.

A Replication Server database connection name is made up of two parts: a data server name—server_name, and a database name—db_name. The replicate Replication Server looks for an interface file entry containing the Sybase IQ replicate database server_name specified in the database connection.

Use dsedit to make an entry in the Replication Server interface file to identify the host and port where the Sybase IQ replicate data server is listening. The interface file entry name must match the server_name portion of the Replication Server database connection. Restart Replication Server to activate the new entry in the Replication Server interfaces file. See “Editing the interfaces file,” in Chapter 2, “Configuring Replication Server and Adding Databases with rs_init” in the Replication Server Configuration Guide for your platform.

Create an entry for the replicate Replication Server in the interfaces file of the Sybase IQ replicate server to allow Sybase IQ to connect to Replication Server and retrieve data when Replication Server sends an INSERT ... LOCATION statement to Sybase IQ.

Replication Server logs in to the Sybase IQ replicate data server using the user_name and password specified in the database connection. For Sybase IQ replicate databases, the user_name and password should be the maintenance user ID and password that you created earlier.