There are replicate database issues that must be addressed in a successful heterogeneous replication system.
Whether or not an ExpressConnect is available for your replicate database. To simplify your replication system and improve performance, use ExpressConnect when it is available for your replicate database.
The requirements of the ECDA database gateway for the particular database server. Configure the DirectConnectâ„¢ access services to work with the replicate database server and Replication Server.
The access and permissions required in the data server for the replication system to apply transactions to the replicate database. Both the replicate Replication Server and the ECDA gateway for a database must have user IDs and passwords defined in the database, with appropriate permissions to access replicate database objects.
The connectivity required to support communication between the replicate data server and other replication system components. ECDA gateways and ExpressConnect (for Oracle or SAP HANA Database) use either the native communication protocol of a data server or the standard ODBC protocol to communicate with a replicate database. ECDA gateways and ExpressConnect (for Oracle or SAP HANA Database) require a connectivity library that you must provide. Replication Server generally requires a database gateway or ExpressConnect (for Oracle or SAP HANA Database) to communicate with a non-ASE data server.
The limitations on replication into the particular data server. For example, Replication Server imposes limitations on some native datatypes in some databases.
The intrusion and impact of the database objects required to support Replication Server operations. Replication Server requires two tables and may require some stored procedures to manage a replicate database.
The replication system management issues specific to the particular data server. For example, different data servers allow different system management options.
For more information about specific replicate database issues for specific databases, see the appropriate topic for your database.