Azure SQL Dynamic Account
In this article
Overview
You can use this account type to connect Azure SQL Snaps with data sources that use Azure SQL 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.
You can Validate an account connection when creating a Azure SQL/Active Directory Account but not when creating a Azure SQL/Active Directory Dynamic Account because the account properties of a dynamic account are provided dynamically as Pipeline parameters. You can specify the Account properties as expressions referencing Pipeline parameters.
Prerequisites
Valid Database and JDBC driver.
Valid Azure Storage credentials.
Limitations and Known Issues
None.
Account Settings
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 fieldset.
Remove icon ( ): Indicates that you can remove fields from the fieldset.
Field Name | Field Type | Description | |
---|---|---|---|
Label* Default Value: N/A | 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 | String/Expression | Specify the server's address to connect to.
| |
Port number* Default Value: 3306 | String/Expression | Specify the database server's port to connect to.
| |
Database name* Default Value: N/A | String/Expression | Specify the database name to connect to.
| |
Username Default Value: N/A | String/Expression | Specify the username that is allowed to connect to the database. Username will be 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 | String/Expression | Specify the password used to connect to the data source. Password wil be used as the default password when retrieving connections. The password must be valid in order to set up the data source.
| |
JDBC JARs | Use this field set to define the JDBC Jar files to be loaded. | ||
JDBC driver class* Default Value: com.microsoft.sqlserver.jdbc.SQLServerDriver | String | Specify the JBDC driver class name to use. | |
Trust all certificates Default Value: Deselected | Checkbox | Select if all SSL certificates are to be accepted for connecting to the database
| |
Azure storage account name Default Value: N/A | String/Expression | Name with which Azure Storage was created. The Bulk Load Snap automatically appends the '.blob.core.windows.net' domain to the value of this property. | |
Azure storage account key Default Value: N/A | String/Expression | Specify the key generated by Azure for this account. | |
Azure storage container name Default Value: N/A | String/Expression | Specify the name of the existing Azure storage container. | |
Advanced properties | Specify advanced properties for connecting to the database. | ||
Auto commit Default Value: Selected | Checkbox/Expression | 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 | Integer/Expression | Specify the number of statements to execute at a time. | |
Fetch size* Default Value: 100 | Integer/Expression | 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 | Integer/Expression | Specify the maximum number of connections a pool will maintain at a time.
| |
Max lifetime (minutes)* Default value: 30 | Integer/Expression | 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 (minutes)* Default Value: 5 | Integer/Expression | 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 | Integer/Expression | 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 Default Value: | Use this field set to set additional URL properties if any. | ||
URL property name Default value: N/A | String/Expression | Specify the URL property name.
| |
URL property value Default value: N/A | String/Expression | Specify the URL property value.
|
Snap Pack History
Related Content
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.