Replication Server Installation

Replication Server automatically installs the required connection profile which provides function strings and classes to support replication into Sybase IQ.

Connection Profiles

Connection profiles allow you to configure your connection with a predefined set of properties by setting the function-string class and error class, installing the user-defined datatypes (UDD) and translations for Sybase IQ, and creating the tables required for replication in the replicate Sybase IQ database.

Connection profiles, such as rs_ase_to_iq and rs_oracle_to_iq are a part of the Replication Server installation package, and are registered when you install Replication Server. A connection profile:

Customizes function strings, error classes, and user-defined datatypes. The function string replaces several default Replication Server function strings with custom function strings designed to communicate with a Sybase IQ data server and access the tables and procedures. These function strings are added to the Replication Server default rs_iq_function_class. RTL treats customized function strings as non-compilable commands.
Customizes class-level datatype translations. Class-level translations identify primary datatypes and the replicate datatypes the data should be translated into. Class-level translation is supplied for the Sybase IQ replicate database by the connection profile:
- rs_ase_to_iq – installs Adaptive Server-to-Sybase IQ class-level translations.
- rs_oracle_to_iq – translates Oracle datatypes to Sybase IQ datatypes
To see all the available profiles, use the admin show_connection_profiles command.
Creates the rs_threads, rs_lastcommit, and rs_ticket_history tables in the Sybase IQ replicate database.
Sets the default function-string class and error class connection properties to configure the connection to Sybase IQ:
```
set error class rs_iq_error_class
set function string rs_iq_function_class
```

Creating the Connection to Sybase IQ
Set up the connection to the replicate Sybase IQ database.
Setting Sybase IQ Database Options
You can use the rs_session_setting function with the create function string command to set the values for Sybase IQ parameters for the duration of the connection to the Sybase IQ replicate database. For example, you can set parameter values to optimize performance.

Parent topic: Sybase IQ Replicate Database Configuration