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.

Note

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.
Key Pair authentication can be used when you connect to Snowflake via ODBC. For details about how to set the connection parameters for the ODBC driver required when you use Key Pair authentication, see the Snowflake web site.

For Key Pair authentication, set the local path of the private key file and the passcode to decode the private key file in the Database connection information of DataMagic. (Although it can be set as a connection parameter of the ODBC driver, we recommend using DataMagic to hide the passcode.)

Connection destination database

For details about the databases that can be connected by using ODBC, see our website.