SQL Server as a destination

You can create a data pipeline that loads data from a source endpoint to an on-premises SQL Server database. To provide the information SnapLogic® AutoSync needs to connect to SQL Server, supply new credentials in the wizard or select saved credentials. The Create credentials page describes how to create credentials in the AutoSync wizard.

After selecting SQL Server as a source, you'll be asked to select a Groundplex that has connectivity to your on-premises SQL Server database. The Connect to on-premises endpoints page provides details about limitations and constraints.

Supported account types

The IIP provides multiple Account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list only includes compatible Accounts. AutoSync supports the following IIP Accounts:

  • SQL Server Account

Connection configuration

SQL Server properties include the following:

  • Account Properties:
    • Credential label: A unique, meaningful name such as SQL-Server-Sales. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
    • Hostname: The name of the machine hosting the database.
    • Port Number: The port number to connect to the database. Default value: 1433
    • Database name: The name of the database. For example, MyDB.
    • Username: A username for an account with the correct permissions for AutoSync to synchronize data.
    • Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
    • Share: (Optional) Select a user group to share this configuration with. Org admins create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
  • Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select schema: AutoSync populates this list from the account. Choose the schema that contains the tables to load as a source.