You can enable secure communication from PowerCenter to Microsoft SQL Server. When you read or write data to a third-party database, you can secure the communication with SSL encryption provided by the third-party database. In PowerCenter, you can configure secure communication to Microsoft SQL Server when you run a mapping with Microsoft SQL Server sources or targets.

To configure secure communication to Microsoft SQL Server on the machine where you run the PowerCenter Integration Service, perform the following tasks:

Import a Microsoft SQL Server SSL certificate to a truststore.
Configure a Microsoft SQL Server data source.
Test a Microsoft SQL Server connection to Microsoft SQL Server.
Create the Microsoft SQL Server connection in PowerCenter and run the mapping.