•  Introduction to Microsoft SQL Server Connector
  •  Microsoft SQL Server Connector assets
•  Connections for Microsoft SQL Server
  •  Prepare for authentication
    •  Prepare for Kerberos authentication
  •  Connect to Microsoft SQL Server
    •  Before you begin
    •  Connection details
    •  Authentication types
    •  Advanced settings
    •  Related links
  •  Configure SSL with the serverless runtime environment
•  Synchronization tasks with Microsoft SQL Server Connector
  •  Microsoft SQL Server sources in synchronization tasks
  •  Microsoft SQL Server targets in synchronization tasks
  •  Advanced properties for Microsoft SQL Server sources and targets in synchronization tasks
  •  Microsoft SQL Server lookup in synchronization tasks
  •  Synchronization task example
•  Mappings and mapping tasks with Microsoft SQL Server Connector
  •  Microsoft SQL Server sources in a mapping
  •  Key range partitioning
    •  Configuring key range partitioning
  •  Pass-through partitioning
    •  Processing Unicode characters
  •  Microsoft SQL Server targets in a mapping
    •  Configuring an update override for the target
  •  Microsoft SQL Server lookups in mapping
  •  Microsoft SQL Server mapping task example
  •  Rules and guidelines for Microsoft SQL Server tasks
  •  SQL ELT optimization
    •  Full SQL ELT optimization
    •  Source SQL ELT optimization
    •  SQL ELT optimization functions
    •  SQL ELT optimization variables
    •  Configuring SQL ELT optimization
    •  Cross-schema SQL ELT optimization
    •  Rules and guidelines for SQL ELT optimization
•  Replication tasks with Microsoft SQL Server
  •  Microsoft SQL Server sources in replication tasks
  •  Microsoft SQL Server targets in replication tasks
•  Data type reference
  •  Microsoft SQL Server and transformation data types

Introduction to Microsoft SQL Server Connector

Microsoft SQL Server and transformation data types

MSREL_MSSQLSERVER_CONN

MSREL_MSSQLSERVER_CONN-CONN_NAME

MSREL_MSSQLSERVER_CONN-CONN_DESC

MSREL_MSSQLSERVER_CONN-CONN_TYPE

MSREL_MSSQLSERVER_CONN-AGENTGROUPID

MSREL_MSSQLSERVER_CONN-SUBTYPE

MSREL_MSSQLSERVER_CONN-AUTHENTICATIONTYPE

MSREL_MSSQLSERVER_CONN-USERNAME

MSREL_MSSQLSERVER_CONN-PASSWORD

MSREL_MSSQLSERVER_CONN-DOMAIN

MSREL_MSSQLSERVER_CONN-HOST

MSREL_MSSQLSERVER_CONN-PORT

MSREL_MSSQLSERVER_CONN-INSTANCENAME

MSREL_MSSQLSERVER_CONN-DATABASE

MSREL_MSSQLSERVER_CONN-SCHEMA

MSREL_MSSQLSERVER_CONN-CODEPAGE

MSREL_MSSQLSERVER_CONN-ENCRYPTIONMETHOD

MSREL_MSSQLSERVER_CONN-CRYPTOPROTOCOLVERSION

MSREL_MSSQLSERVER_CONN-VALIDATESERVERCERTIFICATE

MSREL_MSSQLSERVER_CONN-TRUSTSTORE

MSREL_MSSQLSERVER_CONN-TRUSTSTOREPASSWORD

MSREL_MSSQLSERVER_CONN-HOSTNAMEINCERTIFICATE

MSREL_MSSQLSERVER_CONN-METADATA_ADVANCED_CONNECTION_PROPERTIES

MSREL_MSSQLSERVER_CONN-RUN-TIME_ADVANCED_CONNECTION_PROPERTIES