ODBC Connections
ODBC connections enable you to connect to a database. You can use ODBC connections in Data Synchronization 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 datatype, 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 the ODBC connection in Informatica Cloud, you must create a system Data Source Name (DSN).