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:

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.