Connection Profiles

With Replication Server 15.2, you can use connection profiles that contain connection configurations and replicate database object definitions relevant to each type of actively supported non-ASE data server. Connection profiles specify the function-string class, error class, and class-level translations to be installed.

You can use these connection profiles and simple syntax to create connections between actively supported data servers such as Adaptive Server Enterprise, IBM DB2, Microsoft SQL Server, and Oracle. Replication Server uses the connection profile to configure the connection and create replicate database objects for you.

You can also use connection profile options to specify other actions such as whether commands should be batched and the command separator to use.

For more information on support for non-ASE data servers, see the Replication Server Heterogeneous Replication Guide and the Replication Server Administration Guide Volume 1. For the updated configuration process, see the Replication Server Configuration Guide for your platform.

• using profile Clause
  Use the using profile clause with the create connection command to create a connection between a non-ASE database and Adaptive Server using a connection profile.
• Command to List Available Connection Profiles
  Use the admin show_connection_profiles command to list the profile name, version, and comments for each profile defined in Replication Server.
• System Tables for Connection Profiles
  The rs_profile and rs_profdetail system tables support connection profiles.