Azure Synapse as a destination

You can create a data pipeline that loads data from a source endpoint to Azure Synapse. To provide the information SnapLogic® AutoSync needs to connect to Azure Synapse, supply new credentials in the wizard or select the saved credentials that were created in the IIP or the wizard. The create credentials page lists the information necessary to create credentials in the AutoSync wizard.

AutoSync requires a staging location for Azure Synapse. AutoSync only supports staging to Blob storages.

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 Account types:

  • Azure Synapse SQL Account

Known limitations

  • Azure Synapse limits the number of columns to 1,024 per table.
  • For change detection and propagation, AutoSync cannot propagate source column name changes to Azure Synapse when they contain special characters (other than underscore).

Azure Synapse as both source and target

  • When loading data from an Azure Synapse source to an Azure Synapse destination, the source schema must be different than the destination schema.
  • When using Azure Synapse as both a source and a target, the loaded data for some columns might be a different data type than they were in the source. This is because AutoSync maps data through a common data model.

Connection configuration

Azure Synapse properties include the following:

  • Account Properties
    • Credential label: A unique, meaningful name such as Azure-Synapse-Sales. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
    • Hostname: The URL for Synapse, such as organization-synapse.sql.azuresynapse.net
    • Port Number: The Synapse port number. The default is 1433.
    • Database name: The Synapse database name. For example, Sales-DB
    • Username: The username for an account with the correct permissions to write data. For example Sales-admin.
    • Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
    • External Storage Endpoint: The storage URL, in the following format: Blob storage: .blob.core.windows.net
    • Storage Account: The Azure storage account name.
    • Azure Container: The container name.
    • Azure Folder: The folder name.
    • Azure Auth Type: The type of authorization AutoSync should use for the account, Access Key, Shared Access Signature, or Managed Identity.
    • Azure Identity: The managed identity for Azure authorization. Required for all three types of authorization.
    • Azure Access Key: The key Azure generated for the account. Required for Access Key and Shared Access Signature authorization.
    • 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 to use as the destination.