To use Tableau with Data Virtuality Server, an installed Data Virtuality ODBC Driver and a Tableau Datasource Customisation (.tdc) file are needed.
Data Virtuality ODBC Driver
The Data Virtuality ODBC Driver needs to be installed on the system that runs the Tableau program which shall connect to Data Virtuality Server.
The driver can be downloaded from the Data Virtuality Server instance. The download page for a particular instance is reachable via http://<yourdatavirtualityservername>:<port>. The port depends on the configuration of the instance, commonly 8080 or 443 are used.
The Windows installer for the driver can be also acquired via Data Virtuality Driver download area.
Detailed driver installation instructions for Windows, Linux and macOS can be found in the Data Virtuality Administration Guide/Installation.
Tableau Datasource Customisation File
- Download the BI Frontend Configuration files from the Data Virtuality Server instance.The download page for a particular instance is reachable via http://<yourdatavirtualityservername>:<port>. The port depends on the configuration of the instance, commonly 8080 or 443 are used.
- Unpack the downloaded zip archive BI-Tools-Configuration-Files.zip. It contains - beside other directories - a folder with name tableau. That folder contains the Tableau Datasource Customisation file "Data Virtuality.tdc" which is meant to be used with Data Virtuality Server.
- The file is configured to work with a Windows Operating system and a "2019" Tableau version. If Tableau runs on another operating system or is a different version than "2019", the file needs to be adapted before usage:
- The Tableau Version version in the line shown below (which shows default configuration) needs to match to the Tableau Version.
-
<connection-customization class='genericodbc' enabled='true' version='2019'>
-
- The driver name stated in the line shown below (which shows default configuration) needs to match the driver name used for installation.
-
<driver name='DataVirtuality Unicode(x64)' />
- On macOS and Linux that driver name is configured within installation process. Within the examples from Data Virtuality Administration Guide/Installation, that driver name is "Data Virtuality ODBC Driver".
- On Windows the driver name depends which driver version has been installed:
- "DataVirtuality Unicode(x64)"
- "DataVirtuality Unicode"
- "DataVirtuality ANSI(x64)"
- "DataVirtuality ANSI"
-
- The Tableau Version version in the line shown below (which shows default configuration) needs to match to the Tableau Version.
- Place this file in
- Tableau Desktop macOS:
- /Users/<your user>/Documents/My Tableau Repository/Datasources/
- Tableau Desktop Windows:
- c:\Users\<your user>\Documents\My Tableau Repository\Datasources\
- Tableau Server Windows:
- before Tableau Server 2018.2
- c:\Program Files\Tableau\Tableau Server\<version>\bin\
- Tableau 2018.2 Server and newer
- c:\Program Files\Tableau\Tableau Server\packages\bin.<build number>\
- or for all Tableau Server versions
- c:\ProgramData\Tableau\TableauServer\data\tabsvc\vizqlserver\Datasources\
- before Tableau Server 2018.2
- Tableau Server Linux:
- /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/
- Tableau Desktop macOS:
- Restart your Tableau program.
Create a connection from Tableau Desktop
A connection from Tableau Desktop is created via "Other Datasources (ODBC)" (2), reachable in the "Connect"/"To a Server"/"More" (1) menu. Chosing it will open a dialog, either DSN (3) or Driver can be used to connect.
- DSN: The DSN needs to be created before it can be used with Tableau. Detailed instructions for Windows, Linux and macOS can be found in the Data Virtuality Administration Guide/Installation. Once the DSN is selected, a click on connect will read the needed connection parameters from configuration and fill the Tableau dialog.
- Driver: If a driver is chosen, the needed connection parameters can be filled manually and will be applied then to the Tableau dialog.
Please note that due to changes in the Tableau driver model, a setting has to be adapted in our ODBC driver configuration for old driver installations on switch from Tableau version older than 2018.3 to a newer version. Please find the related 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.