SQL Server CDC Account
Overview
You can use this account type to establish a connection between SQL Server CDC Snap and SQL Server.
Prerequisites
- You must be assigned the “SYSADMIN“ server role.
Account settings
- Expression icon (
): Allows using JavaScript
syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If
disabled, you can provide a static value. Learn more. - SnapGPT (
): Generates SnapLogic Expressions
based on natural language using SnapGPT. Learn
more. - Suggestion icon (
): Populates a
list of values dynamically based on your Snap configuration.
You can select only one attribute at a time using the icon.
Type into the field if it supports a comma-separated list of values. - Upload
: Uploads files. Learn more.
| Field / Field set | Type | Description |
|---|---|---|
| Label | String |
Required. Specify a unique label for the account. Default value: N/A Example: SQL Server CDC HR Account |
| Server name | String/Expression | Required. Specify the server address to which the application must connect. Default value: N/A Example:
|
| Port | Integer/Expression | Required. Specify the database server's port number to which the application must connect. Default value: 1433 Example: 1433 |
| Database name | String/Expression | Required. Specify the user of the database. Default value: N/A Example: CDCDemoDB |
| Username | String/Expression | Required. Specify the user of the database. Default value: N/A Example: cdcuser |
| Password | String/Expression | Required. Specify the password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid in order to set up the data source. Default value: N/A Example: Password123DB |