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 data sources that are appropriate for your DataMagic software.

Note

  • Use 32-bit ODBC data sources for the 32-bit version of DataMagic, or use 64-bit data sources for the 64-bit version of DataMagic.

  • For Redshift, use the driver included in the installation module.

  • For details about how to obtain and install 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.

  • The ODBC driver for Snowflake is affected by the system locale.

    If SHIFT-JIS is set for the system locale in Windows, the ODBC driver uses SHIFT-JIS as the kanji code type for inputting or outputting data to DataMagic. (The kanji code type in the Snowflake database itself remains UTF-8.)

    In this case, code conversion from SHIFT-JIS to UTF-8 or vice versa is performed between the ODBC driver and Snowflake. For this reason, characters that do not exist in SHIFT-JIS cannot be input or output. This limitation is due to the specifications of the ODBC driver.

    By setting UTF-8 for the system locale in Windows, you can change the Snowflake kanji code type to UTF-8 for inputting or outputting data to DataMagic.

Connection destination database

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

URL: https://www.hulft.com/en/