Table of Contents

Search

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

Sqoop Targets

Sqoop Targets

Sqoop targets are valid in mappings in a Hadoop environment.
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, Sqoop ignores them.


Updated November 09, 2018