In this article
You can configure a new SQL Server account in Fast Data Loader (FDL) by using the user credentials from your existing account in SQL Server.
Login credentials and access to SQL Server account. Contact your administrator, if you do not have access or settings details. For more information on SQL Server account, see SQL Server documentation.
Access to SQL Server enterprise snap pack in SnapLogic’s Intelligence Integration Platform. For more information, see https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1379205212
SnapLogic supports SQL Server 2008 to 2016. The Fast Data Loader was tested against SQL Server 11.00.2100.
Create new connection tag
Required. Enter a name that will help identify your SQL Server account in FDL.
Required. Enter the target server address.
Required. Enter the database server's port to connect to.
Required. Enter the database name to connect to.
Enter a valid username that is allowed to connect to the database. This username is used as the default for retrieving connections.
Enter a valid password to connect to the database. Password is used as the default password for retrieving connections.
You might encounter the following errors when you validate and save your integration:
Asset conflict error.
You cannot have another account in FDL with the same name. If you enter the existing account name, the Asset conflict error message is displayed.
Ensure that account name is unique. You can click Overwrite to overwrite the existing configuration with the new one, or click Cancel and enter a unique name for your account.
Failed to validate account.
You might have entered invalid username and password.
Multiple attempts with invalid credentials may lock your account.
Ensure that you enter valid SQL Server account credentials.
Contact FDL customer support at firstname.lastname@example.org for further assistance.
What to do next: Select destination endpoint from the following: