Connecting to a database by using ODBC
In DataMagic, you can connect to a database by using ODBC.
To connect to a database by using ODBC, DataMagic DB Connection Option (ODBC) is necessary.
Use either 32-bit or 64-bit ODBC driver that are appropriate for your DataMagic software.
-
For details about how to install ODBC drivers, see each supplier's website.
-
For Redshift, use the driver included in the installation module.
-
For details about how to obtain the ODBC driver for Snowflake, see the Snowflake web site.
-
Other packages might also be required when you install the ODBC driver for Snowflake. Install the packages according to the description on the Snowflake web site.
- Connection destination database
-
For details about the databases that can be connected by using ODBC, see our website.