Microsoft SQL Server Connector > Introduction to Microsoft SQL Server Connector

Introduction to Microsoft SQL Server Connector

You can use Microsoft SQL Server Connector to connect to Microsoft SQL Server databases from Data Integration. You can read data from or write data to the Microsoft SQL Server databases.

You can also use a Microsoft SQL Server connection to connect to the following databases:

•Microsoft Azure SQL Database
•Audit-enabled Azure SQL Database and pre-V12 Azure SQL Database
•Azure SQL Database from Secure Agents deployed on Azure virtual machines
•Azure SQL Database managed instance
•Amazon RDS SQL Server and Azure SQL Server private endpoints on virtual networks

You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.