Microsoft SQL Server Connector > Introduction to Microsoft SQL Server Connector > Microsoft SQL Server Connector overview
  

Microsoft SQL Server Connector overview

You can use Microsoft SQL Server Connector to connect to Microsoft SQL Server databases from Data Integration. Use Microsoft SQL Server connector to read data from or write data to Microsoft SQL Server databases.
You can also use a Microsoft SQL Server connection to connect to Microsoft Azure SQL Database. You can connect to audit-enabled Azure SQL Database and pre-V12 Azure SQL Database. You can connect to Azure SQL Database from Secure Agents deployed on Azure virtual machines. You can also connect to an Azure SQL Database managed instance.
You can use Microsoft SQL Server objects as sources and targets for synchronization tasks, mappings, mapping tasks, replication tasks, and PowerCenter tasks. You can create, update, or delete records when you use Microsoft SQL Server Connector to write to Microsoft SQL Server databases.