Label*

Default Value: N/A
Example: Azure SQL Active Directory Account

String

N/A

Specify a unique label for the account.

Account properties*

Enter the information to create a connection to the database.

Hostname*

Default Value: N/A
Example: test.database.windows.net

String/Expression

N/A

Specify the server's address to which you must connect.

Port number*

Default Value: 3306
Example: 8080

Integer/Expression

N/A

Specify the port number of the database server to which you must connect.

Database name*

Default Value: N/A
Example: DB1

String/Expression

N/A

 Specify the name of the database to which you must connect.

Authentication mode*

Default Value: Active Directory Password
Example: Active Directory Service Principal

Dropdown list

N/A

Select either of the following options for Azure SQL Authentication:

• Active Directory Password: Provide Username and Password for authentication.

• Active Directory Service Principal: Provide Client ID and Client Secret from service principals for authentication.

• Active Directory Service Principal Certificate: Provide Client ID and Keystore values for client certificate-based authentication.

Client ID*

Default Value: N/A
Example: d4cbb84cbd-cv87-bc75-78yv-90fcd-b319c51

String/Expression

Appears when you select Active Directory Service Principal Certificate as the Authentication mode.

Specify the ID of an Azure Active Directory application.

Keystore*

Default Value: N/A
Example: CertificateWithoutPwd.pfx

String/Expression

Appears when you select Active Directory Service Principal Certificate as the Authentication mode.

Specify the location of the keystore file. The location can be SLDB or any other unauthorized endpoint.

Keystore password

Default Value: N/A
Example: 1234test

String/Expression

Appears when you select Active Directory Service Principal Certificate as the Authentication mode.

Specify the password for the keystore file.

Key alias*

Default Value: N/A
Example: thisisanalias

String/Expression

Appears when you select Active Directory Service Principal Certificate as the Authentication mode.

Specify the alias of the private key used from the keystore file.

Private key passphrase

Default Value: N/A
Example: 1234test

String/Expression

Appears when you select Active Directory Service Principal Certificate as the Authentication mode.

Specify the passphrase for the private key.

Username

Default Value: N/A
Example: sladmin

String/Expression

Appears when you select Active Directory Password as the Authentication mode.

Specify the username that is allowed to connect to the database.
This username is used as the default username when retrieving connections and must be valid to set up the data source.

Password

Default Value: N/A
Example: P#2,nxu0oiX2&?

String/Expression

Appears when you select Active Directory Password as the Authentication mode.

Specify the password used to connect to the data source.
This password is used as the default password when retrieving connections and must be valid to set up the data source.

Trust all certificates

Default Value: Deselected

Checkbox

N/A

Select if all SSL certificates are to be accepted for connecting to the database

Advanced properties

Use this field set to specify the advanced properties.

Auto commit

Default Value: Selected

Checkbox/Expression

N/A

Select this checkbox to commit each of the batches immediately after it is executed. If the Snap fails, only the batch being executed at that moment is rolled back.

Deselect this checkbox to commit the output only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap finds invalid input data before it sends the insert request to the server, and routes the error documents to the Error view.

Disable connection pooling

Default Value: Deselected

Checkbox

N/A

Select this checkbox to prevent the sharing of session state.

We recommend you select this checkbox for Snaps that use session state, for example, creating a temporary table.

Batch size*

Default Value: 50
Example: 60

Integer/Expression

N/A

Specify the number of statements to execute at a time.

Fetch size*

Default Value: 100
Example: 80

Integer/Expression

N/A

Specify the number of rows to fetch at a time when executing a query.

Max pool size*

Default Value: 50
Example: 60

Integer/Expression

N/A

Specify the maximum number of connections a pool will maintain at a time.

Max lifetime (minutes)*

Default Value: 30
Example: 50

Integer/Expression

N/A

Specify the maximum lifetime (in minutes) of a connection in the pool.

Idle timeout (minutes)*

Default Value: 5
Example: 8

Integer/Expression

N/A

Specify the maximum amount of time (in minutes) a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool.

Checkout timeout (milliseconds)*

Default Value: 10000
Example: 100

Integer/Expression

N/A

Specify the timeout (in milliseconds) to wait for a connection to be available when the pool is exhausted.

URL properties

Use this field set to define URL properties to use if any.

URL property name

Default Value: N/A
Example: MAX_CONCURRENCY_LEVEL

String/Expression

N/A

Specify a name for the URL property if any.

URL property value

Default Value: N/A
Example: 3

String/Expression

N/A

Specify a value for the URL property name.