Using a 'Staging' Server with OData
For some of our customers who have a more established BI function and advanced analytical requirements, they have used other methods of pulling the data via ODBC into their own 'staging' server. One approach is to use 3rd party adapters and connectors:
ODBC Driver
An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL. To view all tables within one connection and write custom SQL scripts, you can install and connect directly to an ODBC driver using Tableau, for example:
Connect > To a Server > More > Other Databases (ODBC)
A pop-up window then appears to type in the relevant details:
Tableau ODBC Driver documentation:
https://help.tableau.com/current/pro/desktop/en-us/examples_otherdatabases.htm
For ODBC, we recommend CData’s ODBC Driver:
CData documentation on connecting to OData through Tableau via the ODBC driver: https://www.cdata.com/kb/tech/odata-odbc-tableau.rst
NOTE: the screen shots above are using Tableau 2019.1. There are slight differences in the format of the discovery URL in older versions.
Last updated
