SQL Server / Azure Synapse connection configuration
Overview
When you connect directly to SQL Server / Azure Synapse, select Local DB as the location, select SQL Server as the data type, and configure the detailed settings.
Configuration
SQL Server Authentication
| No | Item | Description |
|---|---|---|
| 1 | User Name | Username for the SQL Server account. |
| 2 | Password | Password for the SQL Server account. |
| 3 | Authentication | Select SQL Server Authentication. |
| 4 | SQL Server Host | |
| 4 | Database | |
| 6 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
| 7 | Enable Transactions | Specify whether to enable transaction control. When ON, transactions are enabled for each connection, and operations are executed within the same transaction. When OFF, each operation is committed automatically (autocommit). |
Windows Authentication
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select Windows Authentication. |
| 2 | SQL Server Host | |
| 3 | Database |
SQL Server Connection String
SDI uses System.Data.SqlClient to connect to SQL Server.
You can connect to SQL Server by using SQL Server Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | SQL Server Connection String |
| 2 | SQL Server Connection String | Enter the details of the SQL Server Connection String. * Do not enter user and password information in the Connection String. Reference:SqlConnection.ConnectionString |