ODBC Connector > Introduction to ODBC Connector
  

Introduction to ODBC Connector

You can use ODBC Connector to read data from and write data to any application that is ODBC compliant. You can also write to a flat file target.
Use an ODBC connection in mappings, synchronization tasks, and mapping tasks to connect to sources, targets, and lookups.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

Example

You want to migrate sales data from DB2 to Salesforce. You do not have DB2 Connector to read sales data from the DB2 source and Salesforce Connector to write to Salesforce. As both the endpoints are ODBC-complaint, you can use ODBC Connector to read from DB2 and write to Salesforce.
Important: If Informatica offers a dedicated connector specific for your database type, use that connector instead of ODBC Connector. For example, use Oracle Connector instead of ODBC Connector to connect to an Oracle database.