If Tableau is used as front-end for Data Virtuality Server it is necessary that Tableau knows the specifics of the SQL dialect that Data Virtuality Server uses.
As not all dialects are equal and the one from Data Virtuality Server does not belong to the default set of Tableau data sources, there are files that can be used for this purpose.
Data Virtuality Suite provides tdc files that Tableau uses in order to rewrite its statements in a manner that they will be entirely understood by DataVirtuality Server.
To use Tableau with Data Virtuality Server, you have to perform the following steps:
- Install the Data Virtuality ODBC drivers and set up a working DSN as described in the Quick Start Guide. Please note, that for use with Tableau Server the DSN should be System DSN, rather than User DSN, and should match the Tableau Server architecture (which is in most cases 64bit).
- Download the BI Frontend Configuration files from http://<yourdatavirtualityservername>:8080/
- Unpack the downloaded zip archive BI-Tools-Configuration-Files.zip and you will find *.tdc files in the tableau folder
- If you use Tableau Desktop, copy the extracted *.tdc files to:
- English version: "%HOMEPATH%\Documents\My Tableau Repository\Datasources\"
- German Version: "%HOMEPATH%\Documents\Eigenes Tableau-Repository\Datenquellen\"
- If you use Tableau Server, copy the extracted *.tdc files to:
- Version 7.0: "C:\Program Files\Tableau\Tableau Server\7.0\vizqlserver\local\data\"
- Version 8.0: "C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources\"
- Version 9.x: "C:\Program Files\Tableau\Tableau Server\[version]\bin"
- Version 10.x: "C:\Program Files\Tableau\Tableau Server\[version]\bin"
- Restart your Tableau Desktop application or restart Tableau Server service accordingly
- In Tableau, use "other datasources (ODBC)" (in German "andere Datenbanken ODBC")
- and choose your configured ODBC DSN
Please note that due to recent changes in the Tableau driver model, a setting has to be made in our current ODBC driver, please find the information in this announcement.
Comments
3 comments
Hi there,
I've followed the steps but was unable to connect and received the following message
An error occurred while communicating with Other Databases (ODBC).
The drivers required to connect to the data source are not installed. The error may need to be resolved through local configuration changes on the Tableau side.
[iODBC][Driver Manager]No data source or driver specified, dialog prohibited
Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection.
Unable to connect to the server "xxxx". Check that the server is running and that you have access privileges to the requested database.
Please advise:)
Thanks,
Ken
Hi Ken!
From the message attached here, the error seems to be originating from the Tableau side. Have you had any luck connecting to Tableau thus far or do you need some additional guidance?
Best,
Amber
Please also see this other post which highlights some compatibility problems in the latest Tableau versions and describes the way to work around these incompatibilities:
https://support.datavirtuality.com/hc/en-us/community/posts/360038669331
Please sign in to leave a comment.