/
SQL Server Connection

SQL Server Connection

Use this connection to access data in SQL Server.

Configuration

Property

Macro Enabled?

Description

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