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:
IBM DB2 for z/OS
Microsoft SQL Server
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.