Azure SQL Account
In this article
Overview
You can use this account type to connect Azure SQL Snaps with data sources that use Azure SQL account.
Prerequisites
Valid database to connect
Valid JDBC JAR file
Limitations
None.
Known Issues
Supports only reading JSON files.
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*
| String | Specify a unique label for the account. | |
Account properties* | Enter in the information to create a connection to the database. | ||
Hostname*
| String/Expressions | Specify the server's address to which you must connect. | |
Port number*
| Integer/Expressions | Specify the port number of the database server to which you must connect. | |
Database name*
| String/Expressions | Â Specify the name of the database to which you must connect. | |
Username
| String/Expressions | Specify the username allowed to connect to the database. Â | |
Password  Default Value: N/A | String/Expressions | Specify the password used to connect to the data source. | |
JDBCÂ JARs* Â Â | Use this field set to specify the JDBC JAR files to be loaded. Add each JAR file in a separate row. The Azure SQL Snap Pack uses the 11.2x driver by default. If you specify any specific driver, ensure that you provide a version higher than 9.1 that is compatible with the Microsoft Authentication Library for Java, becuase this Snap Pack uses the MSAL4J; otherwise, you may encounter errors. | ||
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/Expressions | Specify the Azure Storage account name to use for authorization. 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/Expressions | Specify the key generated by Azure for this account. | |
Azure storage container name  Default Value: N/A | String/Expressions | Specify the name of an existing container. | |
Advanced properties | Use this field set to specify the advanced properties. | ||
Auto commit  Default Value: Selected | Checkbox/Expressions | 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 | Select this checkbox to prevent the sharing of session state. Connection pooling keeps the connections active. When the Snap uses a connection and creates a table during execution, the table gets locked and is not released even after the Snap is executed and the connection is returned to the pool. If another Snap or the same Snap uses the same connection from the pool and reads the metadata of the same table, it displays an error that the resource is locked. We recommend you to select this checkbox for Snaps that use session state, for example, creating a temporary table. | |
Batch size* Â Default Value: 50 | Integer/Expressions | Specify the number of statements to execute at a time. | |
Fetch size* Â Default Value: 100 | Integer/Expressions | Specify the number of rows to fetch at a time when executing a query. Â | |
Max pool size* Â Default Value: 50 | Integer/Expressions | Specify the maximum number of connections a pool will maintain at a time. Â | |
Max lifetime (minutes)* Â Default Value: 30 | Integer/Expressions | Specify the maximum lifetime (in minutes) of a connection in the pool. | |
Idle timeout (minutes)*  Default Value: 5 | Integer/Expressions | 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/Expressions | 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 | String/Expressions | Specify a name for the URL property if any. | |
URL property value Default Value: N/A | String/Expressions | Specify a value for the URL property name. |
Snap Pack History
Related Content
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.