Table of Contents


  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in a Hadoop Environment
  5. Mapping Objects in a Hadoop Environment
  6. Mappings in the Native Environment
  7. Profiles
  8. Native Environment Optimization
  9. Data Type Reference
  10. Function Reference
  11. Parameter Reference

Sqoop Sources

Sqoop Sources

Sqoop sources are valid in mappings in a Hadoop environment if you use the Hive engine.
You can include a JDBC-compliant database as a Sqoop source in an Informatica mapping that runs in a Hadoop environment:
For example, you can include the following sources in a Sqoop mapping:
  • Aurora
  • Greenplum
  • IBM DB2
  • IBM DB2 for z/OS
  • Microsoft SQL Server
  • Netezza
  • Oracle
  • Teradata
If you create a password file to access a database, to run the mapping successfully, you must ensure that the password file exists on HDFS.
Consider the following restrictions when you configure a Sqoop source in a mapping:
  • If you override the default query in the mapping with an advanced query, the Sqoop import process fails.
  • If you specify a sort condition in the mapping, the Data Integration Service ignores the Order By condition.

Updated July 03, 2018