Message Headers
This section lists the headers you can map for the Connector for Microsoft SQL Server CDC.
To map and transform Solace and Microsoft SQL Server CDC message headers and payloads, see Mapping Message Headers and Payloads.
Headers for Microsoft SQL Server CDC as a Source
The Connector for Microsoft SQL Server CDC can be configured only as a source connector.
Microsoft SQL Server CDC Source Headers
| Name | Type | Description |
|---|---|---|
cdc_operation
|
String
|
The type of event operation. |
cdc_db_name
|
String
|
Name of the database. |
cdc_schema
|
String
|
Name of the schema. |
cdc_table_name
|
String
|
Name of the table. |
cdc_commit_lsn
|
String
|
Commit log sequence number. |
cdc_change_lsn
|
String
|
Change log sequence number. |
cdc_key
|
String
|
The key of the event. |
cdc_before
|
String
|
State of the row before the event occurred. |
cdc_timestamp
|
Long
|
The time at which the connector processed the event. |
Solace Target Headers
| Name | Type | Description |
|---|---|---|
scst_targetDestination
|
String
|
A dynamic destination for the message. |
solace_applicationMessageId
|
String
|
The message ID (a string for an application-specific message identifier). |
solace_applicationMessageType
|
String
|
The application message type. |
solace_correlationId
|
String
|
The correlation ID of the message. |
solace_dmqEligible
|
Boolean
|
Indicates whether the message is eligible to be moved to a dead message queue (DMQ). |
solace_expiration
|
Long
|
The UTC time (in milliseconds, from midnight, January 1, 1970 UTC) when the message is supposed to expire. |
solace_httpContentEncoding
|
String
|
The HTTP content encoding header value from interaction with an HTTP client. |
solace_isReply
|
Boolean
|
Indicates whether the message is a reply to another message. |
solace_priority
|
Integer
|
The message priority value in the range of 0-255, or -1 if it is not set. |
solace_senderId
|
String
|
The sender ID for the message. |
solace_senderTimestamp
|
Long
|
The send timestamp (in milliseconds, from midnight, January 1, 1970 UTC). |
solace_sequenceNumber
|
Long
|
The sequence number. |
solace_timeToLive
|
Long
|
The number of milliseconds before the message is discarded or moved to a dead message queue (DMQ). |