Microsoft SQL Server data consumer
Linkage map extractions can be written directly to a SQL Server or Azure SQL table.
Connection fields
The following fields are required for SQL Server data consumers in the data catalog.
| Field | Description |
|---|---|
| Connection String | The full connection string required to connect to the database. For assistance, please refer to this guide. |
| Default Create Table If Not Exists | A default value for when the data consumer is added to a project. See below. |
| Default Destination Table | A default value for when the data consumer is added to a project. See below. |
info
The default field values will be applied to the data consumer when it is added to a specific project.
Use the Test Connection button to verify the SQL Server database can be accessed.
Project level fields
The following additional fields are available when the data consumer has been added to a specific Linkage Project. Some of these may have default values configured at the data catalog level.
| Field | Description |
|---|---|
| Create Table If Not Exists | Flag indicating if the destination table should be created if it doesn't exist. |
| Destination Table | The name of the table to write the extraction data. |