ODBC Connections
ODBC connections enable you to connect to a database. You can use ODBC connections in Data Synchronization tasks, mappings, and Mapping Configuration tasks. When you create the system DSN, you must specify the data source name and the connect string. Choose a database driver that is compatible with the database to which you want to connect.
If you use the MySQL ODBC 3.51 driver for an ODBC connection and you select a MySQL target that has a column with a Double data type, an error similar to the following is displayed:
Column [A1_NUMBER_18_0] has scale greater than precision.
To resolve the error, upgrade to the MySQL ODBC 5.1 driver.
Note: Before you configure an ODBC connection in Informatica Cloud, you must create a system Data Source Name (DSN).