ODBC Connector > ODBC connections > ODBC connections

ODBC connections

ODBC connections enable you to connect to a database. You can use ODBC connections in synchronization tasks, mappings, and mapping 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 Data Integration, you must create a system Data Source Name (DSN).