Versions Compared

Old Version 1

changes.mady.by.user Aryn Wiebe

Saved on

compared with

New Version Current

changes.mady.by.user Aryn Wiebe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSTEP 2: Use the 64 bit ODBC Administrator to create the ODBC data source

  1. On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.

Image RemovedImage Added

  1. Open the System DSN tab and click Add.

  1. Choose the latest Snowflake ODBC driver and click Finish.

  1. Enter your ODBC configurations:

    • Server URL: XXX.snowflakecomputing.com

    • User Credentials (username and password)

    • User Role

    • Warehouse Name

    • Database name

    • Database Schema

Expand
titleSTEP 3: Test the data source connection

Once the data source is created, click on Test and receive success notification. Click OK to complete setup.

Image RemovedImage Added

If unsuccessful, you may need to speak to your DBA (database administrator) or consider using Snowflake’s connectivity diagnostic tool SnowCD for troubleshooting.  

...

Expand
titleSTEP 4: Confirm IguanaX has detected the ODBC library in Settings > Database

In IguanaX, Settings > Database confirm the ODBC library has been detected and loaded correctly.

If not, click Edit to manually add the ODBC shared library path. If you don’t know the location, you can search for the odbc32.dll

Image Added