On this Page
This account is used by the Snaps in the Azure SQL Snap Pack.
You can create an account from Designer or Manager. In Designer, when working on Pipelines, every Snap that needs an account prompts you to create a new account or use an existing account. The accounts can be created in or used from:
Selecting the Disable Connection Pooling checkbox forces the session state to close the existing connection and reopen another connection to the database for each Snap until the Pipeline is executed, which might affect the performance. Hence, we recommend that you select the Disable Connection Pooling checkbox only when there is clear isolation between Snap executions within a Pipeline.
In Manager, you can navigate to the required folder and create an account in it (see Accounts). To create an account for binary files:
Azure SQL Active Directory Account
Azure SQL Active Directory Dynamic Account
Avoid changing account credentials while Pipelines using them are in progress. This may lead to unexpected results, including locking the account. |
If the Snap fails to connect to the database, it will retry three more times. 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. The difference between Azure SQL/Active Directory Account and Azure SQL/Active Directory Dynamic Account is that in the latter you can specify the Account properties as expressions referencing Pipeline parameters. |
Active Directory-based authentication is not supported in the Azure SQL Bulk Extract Snap. |
Account Encryption
|
With the Dynamic Account, you can specify the Account properties as expressions referencing Pipeline parameters. Account Settings
Account Encryption
|
Account Encryption
|
With the Dynamic Account, you can specify the Hostname, Username, Database name, and Password dynamically using Pipeline parameters since they support SnapLogic expressions. You will need to enable the expression-mode by clicking the button to pass values dynamically as Pipeline parameters. Account Settings
Account Encryption
|