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 – translates Adaptive Server datatypes to Sybase IQ datatypes
    • rs_oracle_to_iq – 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