When you create a connection object for the Data Integration Service to process mappings, data profiles, scorecards, or SQL data services, you can define a connection to a database secured with the SSL protocol.
The Data Integration Service connects to the source or target database through JDBC drivers. When you configure the connection to a secure repository database, you must include the secure connection parameters in the JDBC connection string.
Set up a database secured with the SSL protocol to use as a source or target.
In the Administrator tool, create a connection.
In the
New Connection
dialog box, select the connection type. and click
OK
.
You can create a connection to a secure DB2, Microsoft SQL Server, or Oracle database.
In the
New Connection - Step 1 of 3
dialog box, enter the properties for the connection and click
Next
.
In the
New Connection - Step 2 of 3
page, enter the connection string to the database.
To connect to a secure database, enter the secure database parameters in the
Advanced JDBC Security Options
field. Informatica treats the value of the
Advanced JDBC Security Options
field as sensitive data and stores the parameter string encrypted.
The following list describes the secure database parameters:
EncryptionMethod
Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to
SSL
.
ValidateServerCertificate
Optional. Indicates whether Informatica validates the certificate that the database server sends.
If this parameter is set to True, Informatica validates the certificate that the database server sends. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
If this parameter is set to False, Informatica does not validate the certificate that the database server sends. Informatica ignores any truststore information that you specify.
Default is True.
HostNameInCertificate
Optional. Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.
TrustStore
Required. Path and file name of the truststore file that contains the SSL certificate for the database.
TrustStorePassword
Required. Password for the truststore file for the secure database.
Informatica appends the secure JDBC parameters to the connection string. If you include the secure JDBC parameters directly to the connection string, do not enter any parameters in the
Advanced JDBC Security Options
field.
Test the connection to verify that the connection to the secure database is valid.
Complete the process to create the relational connection.