Enfocus Community

when doing a odbc lookup everything's fine, but:
using excel as odbc datasource the tables (sheets) are referenced as system tables, not as standard tables.

So they aren't showing up using the database connector.

When trying with MS-Query, there's an option to show these table making them accessible, but there isn't such an option in Switch.

Any idea?

Ralf.

Hi Ralf,

I don"t know if your Switch runs on Mac, but if it is the case, this will help you:

If you want to access your ODBC database from Excel: OS X Sandboxing is blocking access to /usr/local
Solution :
1. move the ODBC driver (mysql-connector-odbc-8.x.x-etc folder) from /usr/local/ to /Library/ODBC/
2. Edit the ODBC driver path in the “ODBC drivers” tab of your ODBC manager, change /usr/local/ to /Library/ODBC/
3. recreate DSN
More info: https://community.hortonworks.com/quest ... -hive.html