You can configure Sqoop to connect to secure relational databases such as Oracle and Microsoft SQL Server.

Use the appropriate JDBC connection string and the connect argument in the JDBC connection to connect to an SSL-enabled Oracle or Microsoft SQL Server database.

For more information, see the

Informatica Big Data Management 10.2.2 Service Pack 1 User Guide

.

You can define the

connection-param-file

argument to connect to an SSL-enabled Oracle database. The

connection-param-file

is a property file that specifies the extra JDBC parameters that Sqoop must use to connect to the SSL-enabled database.

The contents of this file are parsed as standard Java properties and passed into the driver when you create a connection.

You can specify the

connection-param-file

argument in the

Sqoop Arguments

field in the JDBC connection.

Use the following syntax:

--connection-param-file <parameter_file_name>

For more information, see the

Informatica Big Data Management 10.2.2 Service Pack 1 User Guide

.