Replication Server Installation

Replication Server automatically installs the required connection profile which provides function strings and classes to support replication into SAP 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 SAP IQ, and creating the tables required for replication in the replicate SAP 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 an SAP 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 SAP IQ replicate database by the connection profile:
- rs_ase_to_iq – installs Adaptive Server-to-SAP IQ class-level translations.
- rs_oracle_to_iq – translates Oracle datatypes to SAP 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 SAP IQ replicate database.
Sets the default function-string class and error class connection properties to configure the connection to SAP IQ:
```
set error class rs_iq_error_class
set function string rs_iq_function_class
```

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

Parent topic: SAP IQ Replicate Database Configuration