Configure a mapping task for a mapping with a Microsoft SQL Server CDC source. When you run the mapping task, the SQL Server change records are transmitted to the target. You cannot run mappings for SQL Server CDC.
SQL ELT optimization and Visio templates are not supported for SQL Server CDC mapping tasks.
To begin configuring a mapping task, perform one of the following actions:
In Data Integration, click
New
>
Mapping Task
and then click
Create
.
While the mapping is open, select
New Mapping Task
from the
Actions
menu.
Then enter information on some or all of the following pages in the mapping task wizard:
General Properties
. Enter a name for the mapping task, a project or folder location for the mapping task, and the runtime environment that contains the Secure Agent or Secure Agent Group under which the mapping task will run. If you began creating the mapping task without first opening the mapping, you must also select the mapping with which to associate the mapping task. The description is optional.
Sources
. This page appears only if you defined a parameter for the connection or source object in the mapping. If you defined a connection parameter, select or create the specific CDC connection that you want the mapping task to use. If you defined a source object parameter, select the extraction map for a specific source object. For more information, see
Properties for parameterized sources and connections.
CDC Runtime
. This page appears only for CDC sources. Enter CDC-related properties that are used when the mapping task runs. From this page, you can reset the point in the PowerExchange Logger for Linux, UNIX, and Windows logs from which the PWX CDC Reader starts extracting change data. For more information, see
CDC runtime properties in mapping tasks and
Configuring a restart point for change data extraction.
Targets
. This page appears only if you defined a parameter for the target connection or object in the mapping. For more information about configuring targets in mapping tasks, click the help icon on this page.
Runtime Options
. From this page you can optionally define a schedule for running the mapping tasks, email notifications, advanced options, parameter file location, SQL ELT optimization, execution mode, and advanced session properties. For more information about the session properties, see
Advanced session properties in mapping tasks.