Microsoft SQL Server CDC Connector

Back Next

Properties for parameterized sources and connections

The

Sources

page appears in the mapping task wizard if you defined a parameter for the connection or source object in the associated mapping.

If you defined a parameter for the source connection in the mapping, you must select or create a specific CDC connection for the mapping task. Ensure that the connection type is consistent with the source object type. After a connection is selected, you can click

Advanced Options

to configure the optional

Filter Overrides

SQL Query Override

advanced property. For more information about these advanced properties, see Microsoft SQL Server CDC source properties in mappings.

If the mapping uses a specific source connection and a parameter for the source object, you can specify these advanced properties in the mapping and also specify them in the mapping task. In this case, the properties in the mapping task override those in the mapping.

If you defined a parameter for the source object in the mapping, you must select a specific source object for the mapping task. After you select a source object, the

Preview All Columns

button appears under

Data Preview

. However, you cannot preview data for a CDC source object.

When you finish entering information on the

Sources

page, click

Validate

to validate your entries and then click

to proceed to the

CDC Runtime

page.

If the mapping specifies a connection parameter and you edit the mapping to change the source object, check the specific connection in the mapping task to determine if you need to reset it and then

Validate

the mapping task again.

Mapping task configuration

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal