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 a data server name—server_name—and a database name—db_name. The replicate Replication Server looks for an interfaces 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 interfaces file to identify the host and port where the Sybase IQ replicate data server is listening. The interfaces 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 Replication Server Configuration Guide > Configure Replication Server and Add Databases Using rs_init > Configuring a New Replication Server > Editing the Interfaces File.

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.