In this article
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Overview
You can use this account type to connect <Snap Pack name> Azure SQL Snaps with data sources that use <Account Type Name> account.
Prerequisites
Valid client ID.
Valid tenant URL.
...
...
Limitations
Known Issues
Supports only reading JSON files.
....
Account Settings
<Insert image here>
Appsplus panel macro confluence macro | ||
---|---|---|
| ||
**Delete Before Publishing** Choose from the following sentences to document specific field types. Drop-down lists/Option Buttons (radio buttons): You must list the LoV and describe them if their meaning isn't apparent. In this case, format the LoV in italics, regular font for the LoV's description. In either case, list the LoVs as a bullet list.
Check boxes:
Text Fields
Numeric Text Fields
Notes in field descriptions
|
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
...
Info |
---|
|
...
|
...
|
Field Name | Field Type |
---|
Description |
---|
Label* Default Value: N/A |
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 |
191.235.87.130 | String |
None.
Specify a unique label for the account.
Field set
Specify advanced parameters that you want to include in the request.
This field set consists of the following fields:
Field 1
Field 2
Field 3
Field 1*
Default Value:
Example:
String
Debug mode checkbox is not selected.
Field 2
Default Value:
Example:
String
None.
Troubleshooting
...
Error
...
Reason
...
Resolution
...
Account validation failed.
...
The Pipeline ended before the batch could complete execution due to a connection error.
...
Verify that the Refresh token field is configured to handle the inputs properly. If you are not sure when the input data is available, configure this field as zero to keep the connection always open.
...
Related Links
...
Endpoint Doc Link 1
...
Endpoint Doc Link 2
...
Endpoint Doc Link 3
...
/Expression | Specify the server's address to connect to.
| ||||
Port Number* Default Value: 1433 | 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.
| |||
Authentication Mode*
Default Value: Example: Active Directory Service Principal | Dropdown list | Select either of the following options for Azure SQL Authentication:
| |||
Username Default Value: N/A | 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 | 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 | Integer | Specify the number of statements to execute at a time.
| |||
Fetch size* Default Value: 100 | 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 | 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. If you specify 0, the Snap waits infinitely until the connection is available. Therefore, we recommend you not to specify 0 for Checkout Timeout. | |||
URL Properties | Use this field set to set additional URL properties if any. | ||||
URL property name Default value: N/A | String | URL property name
| |||
URL property value Default value: N/A | String | URL property value |
...
Snap Pack History
...