Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

Sqoop

Sqoop

Effective in version 10.2.2 Service Pack 1, you can use the following new Sqoop features.

Connect to SSL-enabled Oracle and Microsoft SQL Server databases

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
.

Support for connection-param-file Sqoop argument

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
.


Updated November 24, 2020