CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Extracting Data for Multiple Publication Databases

If you plan to extract data from a Microsoft SQL Server distribution database that contains information for articles in multiple publication databases in a single pass, you must set some parameters for extraction processing to succeed.

This requirement applies to extraction of data directly from the change stream in real time extraction mode or from PowerExchange Logger for Linux, UNIX, and Windows log files in continuous extraction mode.

Specify the following parameters:

In the MSQL CAPI_CONNECTION statement in the dbmover configuration, verify that the MULTIPUB parameter is set to Y, the default setting. If you do not use this setting, the extraction will fail with message PWX-15757.

If you plan to extract data for single publication database, set this parameter to N for more efficient extraction processing.

If you use the PowerExchange Logger for Linux, UNIX, and Windows, set the following parameters:

In the PowerExchange Logger configuration file, pwxccl, ensure that you define the DBID, DISTDB, and DISTSRV parameters. These parameters are usually required for PowerExchange Logger processing of SQL Server sources.

In the PowerCenter PWX MSSQL CDC Change or Real Time connection definition, specify the PowerExchange Logger DBID parameter value for the

Logger DBID

attribute.

To perform a database row test, specify the PowerExchange Logger DBID parameter value in the

MSS LUW DBId

field in the CAPXRT Advanced Parameters dialog box.

Planning for SQL Server CDC

Download Guide

Watch

Comments

Communities

Knowledge Base