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.
-
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.
-
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.