Microsoft SQL Server Connections Overview
Create a Microsoft SQL Server connection to connect to Microsoft SQL Server so that the Secure Agent can read data from and write data to Microsoft SQL Server. You can use a Microsoft SQL Server connection to connect to Microsoft Azure SQL databases.
You create a Microsoft SQL Server connection on the Connections page. Use the connection when you create a Contact Validation tasks, Data Masking tasks, Data Synchronization tasks, mappings, Mapping Configuration tasks, Data Replication tasks, and PowerCenter tasks.
Note: When you enable SSL encryption, you cannot connect to a Microsoft SQL Server instance if the Secure Agent runs on Windows 32-bit or Linux 32-bit operating systems.