1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. SQL Server
  5. Database Connectivity
  6. Configuring a Replicat Database Connection

Configuring a Replicat Database Connection

Replicat can connect to the target database to perform DML operations in the following ways:

  • Through ODBC.

  • Through OLE DB if the SQL Server driver supports it.

  • Through OLE DB as the SQL Server replication user. NOT FOR REPLICATION must be set on IDENTITY columns, foreign key constraints, and triggers.

Before you select a method to use, review the following guidelines and procedures to evaluate the advantages and disadvantages of each.