Azure SQL Entra Dynamic Account

In this article

Overview

You can use this account type to connect Azure SQL Snaps with data sources that use Azure SQL Entra Dynamic Account.

Dynamic Account types support Secrets Management, a SnapLogic add-on that allows you to store endpoint credentials in a third-party secrets manager. Orgs using Secrets Management provide the information necessary to retrieve the secrets in expression-enabled dynamic Account fields. During validation and execution, Pipelines obtain the credentials directly from the secrets manager. Learn more about Secrets Management.

Prerequisites

  • Valid Database.

  • Valid Azure Storage credentials.

Limitations and Known Issues

None.

Account Settings

azure-sql-entra-dynamic-account.png

 

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the field set.

  • Remove icon ( ): Indicates that you can remove fields from the field set.

Field Name

Field Type

Description

Field Name

Field Type

Description

Label*

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

String

Specify a unique name for the account instance.

Account properties*

Enter in the information to create a connection to the database.

Hostname*

Default Value: N/A
Example: 191.235.87.130

String/Expression

Specify the server's address to connect to.

 

Port Number*

Default Value: 1433
Example: 3306

String/Expression

Specify the database server's port to connect to.

 

Database name*

Default Value: N/A
Example: sldatabase

String/Expression

Specify the database name to connect to.

 

Authentication Mode*

 

Default Value:
Active Directory Password

Example: Active Directory Service Principal

Dropdown list

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.

  • An Azure Active Directory (Azure AD) service principal is the local representation of an application object in a single tenant or directory. 

  • Service principals define who can access the application, and what resources the application can access.

Username

Default Value: N/A
Example: sladmin

String/Expression

Specify the username to connect to the database. The username is used as the default username when retrieving connections. The username must be valid in order to set up the data source.

 

Password

Default Value: N/A
Example: <Encrypted>

String/Expression

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

 

Trust all certificates

Default Value: Deselected 

Checkbox

Select this checkbox to allow all SSL certificates for connecting to the database.

 

Advanced properties

Specify advanced properties for connecting to the database.

Auto commit

Default Value: Selected
 

Checkbox

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.

Batch size*

Default Value: 50
Example: 90

Integer

Specify the number of statements to execute at a time.

Fetch size*

Default Value: 100
Example: 300

Integer

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

Large values could cause the server to run out of memory.

 

Max pool size*

Default value: 50
Example: 90

Integer

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

 

Max life time*

Default value: 30

Integer

Specify the maximum lifetime (in minutes) of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed.

 

Idle Timeout*

Default Value: 5

Integer

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*

Default value: 10000

Integer

Specify the timeout (in milliseconds) to wait for a connection to be available when the pool is exhausted. Zero waits forever. An exception will be thrown after the wait time has expired.

URL Properties

 

Use this field set to set additional URL properties if any.

URL property name

Default value: N/A
Example: Example corp

String

URL property name

 

URL property value

Default value: N/A
Example: https://www.example.com

String

URL property value


Snap Pack History


Related Links