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 Targets

Sqoop Targets

Sqoop targets are valid in mappings in a Hadoop environment if you use the Hive engine.
You can include a JDBC-compliant database as a Sqoop target in an Informatica mapping that runs in a Hadoop environment:
For example, you can include the following targets in a Sqoop mapping:
  • Aurora
  • Greenplum
  • IBM DB2
  • IBM DB2 for z/OS
  • Microsoft SQL Server
  • Netezza
  • Oracle
  • Teradata
You can insert data. You cannot update or delete data in a target. If you configure update arguments, the Sqoop program ignores them.
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. If a column name contains a special character, the Sqoop export process fails.

Updated July 03, 2018