Microsoft SQL Server Connector

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 use a Microsoft SQL Server connection to connect to Microsoft Azure SQL databases. You can connect to audit-enabled Azure SQL databases and pre-V12 Azure SQL databases. You can connect to Azure SQL databases 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.


Updated June 03, 2020