Configure SQL Server Accounts

Overview

You can create SQL Server accounts to connect to Microsoft SQL Server databases in your Pipelines. You can configure your account from SnapLogic Platform using the Designer or Manager.

Snap-account compatibility

The Snaps in the SQL Server Snap Pack work with different accounts as shown in the following table:

Snaps SQL Server Account SQL Server Dynamic Account Protocols supported
SQL Server - Select Tick Icon Tick Icon TCP/IP
SQL Server - Insert Tick Icon Tick Icon TCP/IP
SQL Server - Update Tick Icon Tick Icon TCP/IP
SQL Server - Delete Tick Icon Tick Icon TCP/IP
SQL Server - Execute Tick Icon Tick Icon TCP/IP
SQL Server - Bulk Load Tick Icon Tick Icon TCP/IP
SQL Server - Lookup Tick Icon Tick Icon TCP/IP
SQL Server - Merge Tick Icon Tick Icon TCP/IP
SQL Server - Table List Tick Icon Tick Icon TCP/IP
SQL Server - Stored Procedure Tick Icon Tick Icon TCP/IP

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have Enhanced Account Encryption, the following fields are encrypted for each sensitivity level:
  • High: Password
  • Medium + High: Username, Password
  • Low + Medium + High: Server Name, Database Name, Username, Password