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 pre-defined 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.

The rs_oracle_to_iq connection profile is part of the Replication Server installation package, and it is registered when you install Replication Server. The 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 rs_oracle_to_iq connection profile, which translates Oracle datatypes to Sybase IQ datatypes.
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
```