Data Replication into Non-Adaptive Server Data Servers

Sybase offers several Open Server gateway application products that you can use to access non-Sybase database servers for a replicate database.

• Interface for Replication Server with Non-ASE Data Servers
  Replication Server updates the replicate data stored in databases by submitting requests to data servers. Support for Adaptive Server is provided with Replication Server. If your database is managed by a data server other than Adaptive Server, you must provide an interface for Replication Server to use.
• Sybase Database Gateway Products
  Sybase Enterprise Connect Data AccessConnect provides the Sybase middleware building blocks for connectivity between clients and enterprise data sources. Using ECDA simplifies the integration of non-Sybase replicate databases into a Sybase replication system.
• ExpressConnect for Oracle
  ExpressConnect for Oracle (ECO) is a library that is loaded by Replication Server 15.5 or later for Oracle replication.
• Maintenance User
  Replication Server logs in as the maintenance user specified in create connection for the database.
• Function-String Class
  The Replication Server managing a database requires a function-string class. Replication Server provides function-string classes for Adaptive Server, and with its non-ASE data server support features, Replication Server provides function-string classes for all actively supported data servers.
• Error Class
  An error class determines how Replication Server handles the errors that are returned by your gateway. Use the create error class command to create an error class for your gateway.
• rs_lastcommit Table
  Each row in the rs_lastcommit table identifies the most recent committed transaction that was distributed to the database from a primary database. Replication Server uses this information to ensure that all transactions are distributed.
• rs_get_lastcommit Function
  Replication Server sends an rs_get_lastcommit function call to the gateway to retrieve the last transaction committed in the database from each source primary database.