SQL Server Connection
Use this connection to access data in SQL Server.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Name | No | Required. Name of the connection. Connection names must be unique in a namespace. Connection names can only include letters, numbers, underscores, and hyphens. |
Description | No | Optional. Description of the connection. |
JDBC Driver Name | No | Required. Select the JDBC driver name to use. |
Host | Yes | Required. Host name or IP address of the database server to connect to. Default is localhost. |
Port | Yes | Required. Port number of the database server to connect to. Default is 1433. |
Authentication Type | No | Optional. Indicates which authentication method will be used for the connection. Use ‘SQL Login’. to connect to a SQL Server using username and password properties. Use ‘Active Directory Password’ to connect to an Azure SQL Database/Data Warehouse using an Azure AD principal name and password. |
Username | Yes | User identity for connecting to the specified database. Required for databases that need authentication. Optional for databases that do not require authentication. |
Password | Yes | Password to use to connect to the specified database. |
Connection Arguments | Yes |