•  Introduction to Microsoft Azure Synapse SQL Connector
  •  Microsoft Azure Synapse SQL Connector assets
•  Connections for Microsoft Azure Synapse SQL
  •  Prerequisites
    •  Azure Active Directory authentication
    •  Service Principal authentication
    •  Managed Identity authentication
    •  Serverless SQL pool
  •  Connect to Microsoft Azure Synapse SQL
    •  Before you begin
    •  Connection details
    •  Azure storage types
    •  Advanced settings
    •  Related links
  •  Verify permissions
•  Mappings for Microsoft Azure Synapse SQL
  •  Microsoft Azure Synapse SQL sources in mappings
    •  Adding multiple source objects
    •  Key range partitioning
  •  Microsoft Azure Synapse SQL targets in mappings
    •  Copy command
    •  Rejected rows
    •  Mapping tasks with CDC sources
    •  Changed data capture limitations
    •  Bulk processing for write operations
    •  Rules and guidelines for configuring update override
  •  Microsoft Azure Synapse SQL lookups in mappings
    •  Enabling lookup caching
    •  Optimize the staging performance for a mapping
  •  Process SQL queries and stored procedures using an SQL transformation
    •  Configuring an SQL transformation
    •  Rules and guidelines for SQL transformations
  •  Dynamic schema handling
    •  Rules and guidelines for dynamic schema handling
  •  IDENTITY column
  •  Parameterization
  •  Rules and guidelines for mappings and mapping tasks
  •  Mappings in advanced mode example
    •  Rules and guidelines for mappings in advanced mode
•  Upgrading to Microsoft Azure Synapse SQL Connector
  •  Connection switching example
  •  Properties retained after the upgrade
  •  Rules and guidelines
•  Migrating a mapping
  •  Use the same object path for the migrated mapping
  •  Use a different object path for the migrated mapping
    •  Migration options
    •  General rules and guidelines
•  SQL ELT optimization
  •  SQL ELT optimization types
    •  Data Integration behavior with source and full SQL ELT optimization
  •  SQL ELT optimization scenarios
  •  Previewing SQL ELT optimization
  •  Configuring SQL ELT optimization
  •  SQL ELT optimization using a Microsoft Azure Synapse SQL connection
    •  Functions with Microsoft Azure Synapse SQL
    •  Operators with Microsoft Azure Synapse SQL
    •  Transformations with Microsoft Azure Synapse SQL
    •  Supported features for Microsoft Azure Synapse SQL mappings
    •  Supported features for Microsoft Azure Data Lake Storage Gen2 source
    •  Configuring a custom query for the Microsoft Azure Synapse SQL source object
    •  Rules and guidelines for SQL ELT optimization
•  Data type reference
  •  Microsoft Azure Synapse SQL and transformation data types
•  Troubleshooting
  •  Troubleshooting a Microsoft Azure Synapse SQL connection
  •  Troubleshooting a mapping or mapping task
  •  Troubleshooting a mapping in advanced mode

Introduction to Microsoft Azure Synapse SQL Connector

Troubleshooting a mapping in advanced mode

CDI_SYNAPSE_AAD_AUTH

CDI_SYNAPSE_SP_AUTH

CDI_SYNAPSE_MSI_AUTH

CDI_SYNAPSE_SERVERLESS_POOL

MSAZURE_SQLDWV3_CONN

MSAZURE_SQLDWV3_CONN-CONN_NAME

MSAZURE_SQLDWV3_CONN-CONN_DESC

MSAZURE_SQLDWV3_CONN-CONN_TYPE

MSAZURE_SQLDWV3_CONN-AGENTGROUPID

MSAZURE_SQLDWV3_CONN-JDBCURL

MSAZURE_SQLDWV3_CONN-JDBCUSERNAME

MSAZURE_SQLDWV3_CONN-JDBCPASSWORD

MSAZURE_SQLDWV3_CONN-SYNAPSECLIENTID

MSAZURE_SQLDWV3_CONN-SCHEMANAME

MSAZURE_SQLDWV3_CONN-AZURESTORAGETYPE

MSAZURE_SQLDWV3_CONN-AZURESTORAGETYPE-AZURE_BLOB

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-AUTHENTICATIONTYPE

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-AUTHENTICATIONTYPE-SHARED_KEY_AUTHENTICATION

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-BLOBACCOUNTNAME

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-SHARED_KEY_AUTHENTICATION-BLOBACCOUNTNAME

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-BLOBACCOUNTKEY

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-SHARED_KEY_AUTHENTICATION-BLOBACCOUNTKEY

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-CONTAINERNAME

MSAZURE_SQLDWV3_CONN-AZURE_BLOB-SHARED_KEY_AUTHENTICATION-CONTAINERNAME

MSAZURE_SQLDWV3_CONN-AZURESTORAGETYPE-ADLS_GEN2

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-AUTHENTICATIONTYPE

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-AUTHENTICATIONTYPE-SHARED_KEY_AUTHENTICATION

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-ADLSACCOUNTNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SHARED_KEY_AUTHENTICATION-ADLSACCOUNTNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-ADLSACCOUNTKEY

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SHARED_KEY_AUTHENTICATION-ADLSACCOUNTKEY

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-FILESYSTEMNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SHARED_KEY_AUTHENTICATION-FILESYSTEMNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-AUTHENTICATIONTYPE-SERVICE_PRINCIPAL_AUTHENTICATION

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-ADLSACCOUNTNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-CLIENTID

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-CLIENTSECRET

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-TENANTID

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-FILESYSTEMNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-AUTHENTICATIONTYPE-MANAGED_IDENTITY_AUTHENTICATION

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-MANAGED_IDENTITY_AUTHENTICATION-ADLSACCOUNTNAME

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-MANAGED_IDENTITY_AUTHENTICATION-CLIENTID

MSAZURE_SQLDWV3_CONN-ADLS_GEN2-MANAGED_IDENTITY_AUTHENTICATION-FILESYSTEMNAME

MSAZURE_SQLDWV3_CONN-EXTDATASOURCE

MSAZURE_SQLDWV3_CONN-STAGINGSCHEMA

MSAZURE_SQLDWV3_CONN-ENDPOINTSUFFIX

MSAZURE_SQLDWV3_CONN-VNETRULE

CDI_SYNAPSE_VER_PERMISSIONS