Microsoft SQL Server Connector Overview

You can use a Microsoft SQL Server connection to connect to Microsoft Azure SQL databases. You can also 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 use Microsoft SQL Server objects as sources and targets for Contact Validation tasks, Data Masking tasks, Data Synchronization tasks, mappings, Mapping Configuration tasks, Data 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.