ODBC lookup excel system tables

Post Reply
w3gmbh
Newbie
Posts: 7
Joined: Mon Dec 16, 2013 4:14 pm

ODBC lookup excel system tables

Post by w3gmbh » Wed Jul 22, 2020 1:42 pm

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.

laurentd
Member
Posts: 36
Joined: Wed Mar 13, 2019 2:06 pm

Re: ODBC lookup excel system tables

Post by laurentd » Mon Aug 03, 2020 12:16 pm

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
Laurent De Wilde, Solution Architect @ Enfocus

Post Reply