About Instantiating with Initial Load Extract

Using the initial load Extract for instantiation, you can replicate data precisely from a source to a target database with zero data loss. To configure this Extract, you'll require a combination of file-based initial load and change data capture (CDC) processes.

In Microservices Architecture, the process of instantiation includes the following tasks:

• Add and configure an Initial Load Extract: This Extract is used to copy the existing contents of one or more tables from the source to the target database.

• Configure Change Data Capture: Used to copy transactional changes from the source to the target database.

Description of the illustration gwuad_dt_026_file-replicat.png

Note:

MA doesn’t support loading data with an Oracle GoldenGate direct load.

File-based initial load process is the preferred method for performing data replication in MA. It’s key components are:

• Initial Load Extract and Replicat: Replicates the existing content of the database tables.

• Primary Extract and Replicat: Replicates change data from the database tables.

• Distribution Paths: Transfers trail files to the target system.

Before you begin, make sure that the database credential alias is created.

You can use the Oracle GoldenGate web interface, Admin Client, or cURL commands to set up this configuration.