Microsoft SQL Server CDC Connector

Back Next

Microsoft SQL Server CDC connection properties

When you configure a SQL Server CDC connection, you must set the connection properties.

The following table describes SQL Server CDC connection properties:

Property	Description
Connection Name	A name for the SQL Server CDC connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + - Spaces at the beginning or end of the name are trimmed and are not saved as part of the name. Maximum length is 100 characters. Connection names are not case sensitive.
Description	Description of the SQL Server CDC connection. Maximum length is 4000 characters.
Type	Type of connection. For SQL Server CDC, the type must be SQL Server CDC .
Runtime Environment	Name of the runtime environment that contains the Secure Agent that you want to use to run mapping tasks.
Listener Location	Host name or IP address of the system where both the PowerExchange Listener that processes PWX CDC Reader requests for SQL Server change data and the PowerExchange Logger for Linux, UNIX, and Windows run. Also include the Listener port number. Enter the value in the following format, where `host_name` can be a host name or IP address: `host_name`:`port_number` For example: MSSCDC1A:1467
User Name	A user name that can be used to access the PowerExchange Listener when PowerExchange Listener security is enabled. If you enabled PowerExchange LDAP user authentication, the user name is an enterprise user name. For more information, see the SECURITY statement in the PowerExchange Reference Manual .
Password	Password that is associated with the user name that is specified in the User Name property.
Collection Name	The SQL Server instance name that is specified in the Instance field of the registration group that contains the registrations for the SQL Server source tables. This value is used to filter the extraction-map metadata that the PWX CDC Metadata Adapter imports when using this connection.
CAPI Connection Name	Name of a CAPX CAPI_CONNECTION statement that is defined in the PowerExchange dbmover configuration file. This statement includes parameters that the PWX CDC Reader uses to extract change data from PowerExchange Logger for Linux, UNIX, and Windows log files. The PWX CDC Reader requires this property value and ignores any default CAPI_CONNECTION statement that is defined in the dbmover configuration file.
Logger DBID	The DBID parameter value that is specified in the PowerExchange Logger for Linux, UNIX, and Windows configuration file, pwxccl.cfg. This value is required only if the PowerExchange Logger extracts change data for articles in multiple publication databases. In this case, you must also set the MULTIPUB parameter to Y in the MSQL CAPI_CONNECTION statement in the PowerExchange dbmover.cfg configuration file. Otherwise, the extraction fails.
Connection Retry Period	Number of seconds that the PWX CDC Reader tries to reconnect to the PowerExchange Listener after the initial connection attempt fails. If a connection cannot be established within the retry period, the mapping task fails. The default is 0, which disables connection retries.
Compression	Controls whether the PowerExchange Listener compresses change data before sending the data over the network to the PWX CDC Reader. Select this property to compress the data. By default, this property is not selected.
Encryption	Controls whether the PowerExchange Listener encrypts change data before sending it over the network to the PWX CDC Reader. Also specifies the type of encryption to use. Select one of the following options: None . Do not use encryption. AES 128-bit . Use a 128-bit encryption key. AES 192-bit . Use a 192-bit encryption key. AES 256-bit . Use a 256 encryption key. The default is None .
Pacing Size	Amount of data, in rows or kilobytes, that the source system passes to the PowerExchange Listener before pausing to wait for another PWX CDC Reader request for more data. Decrease this value to improve session performance. Use 0 for maximum performance. The default and minimum value is 0.
Pacing Units	Type of units to use with the Pacing Size property. Select either Rows or Kilobytes .
Map Location	Host name or IP address of the system where the extraction maps reside. Also include the port number. This value is required when the PowerExchange Listener runs on a PowerExchange Logger for Linux, UNIX, and Windows machine that is remote from the extraction maps. The Listener requires access to the extraction maps to process change data extraction requests. Enter the value in the following format, where `host_name` can be a host name or IP address: `host_name`:`port_number` For example: MSSCDC2B:25100 The Map Location value takes precedence over the Listener Location value for testing connections and importing extraction-map metadata.
Map Location User	A user name that can access the PowerExchange Listener at the location that is specified in the Map Location property.
Map Location Password	Password associated with the user name that is specified in Map Location User property.
Event Table	If you created an event table to stop change data extraction based on user-defined events, enter the name of the PowerExchange extraction map for the event table. The event table must be a SQL Server table on the CDC source system.
Replace Low Values with Spaces	Controls whether to replace embedded nulls in character data with spaces. Select this property to replace embedded nulls. By default, this property is selected.
Custom Properties	Custom properties or connection property overrides. Custom properties are properties that you can specify to override PowerExchange default settings. You can enter multiple properties by using a semicolon (;) as the separator or you can specify a parameter to specify connection property overrides through a parameter file. For example: <property>=<value>;<property>=<value> In most cases, you set custom properties only at the direction of Informatica Global Customer Support. These properties are equivalent to the PWX Override options for the PowerExchange Client for PowerCenter (PWXPC) CDC connections in PowerCenter. To specify connection property overrides through a parameter file, you set a parameter in the form of $<ParameterName> , where you prefix a user-defined parameter name with a dollar sign character ($). Then configure a mapping task for the mapping to use a parameter file that contains the user-defined parameter definition by specifying the parameter file name in the Parameter File Name field on the Runtime Options tab. If you enter the same parameter for both the mapping and connection, the connection custom property takes precedence. If you have a parameter file, the parameter name you specify in this field must match an entry defined in the parameter file. For more information, see the “Connection overrides reference” chapter.

Rename Saved Search

Table of Contents

Microsoft SQL Server CDC Connector

Microsoft SQL Server CDC Connector

Microsoft SQL Server CDC connection properties

Microsoft SQL Server CDC connection properties