Security Guide

10.4.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5

Back Next

Data Integration Service Sources and Targets

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

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

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.

Rename Saved Search

Table of Contents

Security Guide

Security Guide

Data Integration Service Sources and Targets

Data Integration Service Sources and Targets