Microsoft Azure Synapse SQL Connector

Back Next

Mapping tasks with CDC sources

Your organization needs to replicate real-time changed data from a mission-critical Oracle production system to minimize intrusive, non-critical work, such as offline reporting or analytical operations system. You can use

Microsoft Azure Synapse SQL

Connector to capture changed data from the Oracle CDC source and write the changed data to a

Microsoft Azure Synapse SQL

. Add the Oracle CDC sources in mappings, and then run the associated mapping tasks to write the changed data to the target.

Data Integration

, click

New

Mapping

Create

The

New Mapping

dialog box appears.

Enter a name and description for the mapping.

On the Source transformation, specify a name and description in the general properties.

On the

Source

tab, select the configured Oracle CDC connection and specify the required source properties.

On the Target transformation, specify a name and description in the general properties.

On the

Target

tab, perform the following steps to configure the target properties:

In the

Connection

field, select the

Microsoft Azure Synapse SQL

connection.

In the

Target Type

field, select the type of the target object.

In the

Object

field, select the required target object.

In the

Operation

field, select

Data Driven

to properly handle insert, update, and delete records from the source.

In the

Data Driven Condition

field, leave the field empty.

In the

Update Column

field, select the key columns to upsert or update data to or delete data from

Microsoft Azure Synapse SQL

. This property is honored only if you select delete, update, or upsert operation in the

Treat Source Rows As

advance property.

In the

Advanced Properties

section, you must select Data Driven in the

Treat Source Rows As

property.

On the

Field Mapping

tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names.

In the

Actions

menu, click

New Mapping Task

The

New Mapping Task

page appears.

In the

Definition

tab, enter the task name and select the configured mapping.

In the

CDC Runtime

tab, specify the required properties.

For more information about the

CDC Runtime

properties, see the

Informatica Cloud Data Integration Oracle CDC Connector User Guide

In the

Runtime Options

tab, specify the following properties in the

Advanced Session Properties

section:

In the

Commit on End of File

field, select the value of the property as

In the

Commit Type

field, select the value of the property as

Source

In the

Recovery Strategy

field, select the value of the property as

Resume from last checkpoint

Click

Save

Run

the mapping.

Alternatively, you can create a schedule that runs the mapping task on a recurring basis without manual intervention. You can define the schedule to minimize the time between mapping task runs.

In Monitor
, you can monitor the status of the logs after you run the task.

Microsoft Azure Synapse SQL targets in mappings

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal