Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Run Sqoop jobs for Netezza Database using Informatica BDM 10.2.1 or later versions
Solution
​Perform the following steps for configuring Sqoop Connectivity to Netezza Database:

  1.  Get the JDBC driver & related license jar, if any, for Netezza (Example: nzjdbc[version].jar).
  2.  Copy them into ‘$INFA_HOME/externaljdbcjars’ location.
  3.  Create a JDBC connection from Informatica Administrator console with the following ‘JDBC Driver Class Name’ and ‘Connection String’ attributes:

 

JDBC Driver Class Name

netezza.Driver

Connection String

--infaownername false jdbc:netezza://[host]:[port]/[database_name]

 

Default JDBC connection port for Netezza is 5480. Read more on the different ports of Netezza from here

4. Enable the Sqoop connectivity in the JDBC connection by changing the value of attribute ‘Use Sqoop Connector’  from ‘None’  to ‘Sqoop v1.x’.

5. In the ‘Additional Sqoop arguments’  section of the connection, enter the following:

 

--connect --verbose

 

Note: It is not required to enter the JDBC URL again in the ‘Additional Sqoop Arguments’ attribute. During the job execution, URL entered earlier in the ‘Connection String’ section would be re-used.

 

The same steps could be repeated for any relational sources having JDBC driver based connectivity, by providing the appropriate ‘Driver Class Name’ and ‘JDBC URL’ values. 

 

All the jar files, including the Netezza driver, when placed under ‘$INFA_HOME/externaljdbcjars’ location, would be transferred to the Hadoop data nodes using ‘infa_rpm.tar’ file.  As an additional step, ensure to restart the Informatica Domain so that the jar would get picked up and the test connection could be successful. 

 

Similarly, in case of ‘Developer Client’, for connectivity, the jar should be kept under ‘%INFA_CLIENT_HOME%\externaljdbcjars’ location. Say for 10.2.2, the default location would be ‘C:\Informatica\10.2.2\clients\externaljdbcjars’. 


More Information
infaownername’ Sqoop argument is available in Informatica 10.2.1 with EBF-11494 or from Informatica 10.2.2 version onwards, without any additional EBFs​.
Reference
Applies To
Product: Data Engineering Integration(Big Data Management)
Problem Type: Configuration; Connectivity
User Type: Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:11/19/2019 1:11 AMID:604910
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)