Last modified on: 01 Feb 2022
The Tableau exporter is a custom exporter designed to allow Denodo Scheduler Server to export data from different sources into a hyper file according to the version of Tableau.
Hyper are data file format used by Tableau, a business intelligence software that helps people see and understand their data.
If you're using Tableau 10.5 and later you have to install Extract API 2.0. See the How to install Extract API 2.0. Old versions don't support Extract API 2.0.
Additionally, you have to download Tableau Exporter from the Denodo Support Site. Once uncompressed, connect to the Scheduler Server via the Scheduler WebAdmin Tool and log in.
Once connected, click on Configuration → Plugins in order to access the Plugins Configuration section.
Click on the New Plugin button in order to access the new plugin input form.
Select the Tableau Exporter’s jar with dependencies file, which will be called something similar to denodo-tableau-exporter-[denodo_version]-[exporter_version]-jar-with-dependencies.jar (version numbers might change), and click on the Accept button, and after the success page, you will see your new exporter in the Plugins section.
The Extract API 2.0 is available on the Tableau website. Go to the https://onlinehelp.tableau.com/current/api/extract_api/en-us/help.htm#Extract/extract_api_installing.htm%3FTocPath%3D_____3 page and choose the appropriate version for your platform. The programming language must be Java.
Note that the data extract process takes part in the Scheduler Server and therefore this is the server that must be configured.
For Linux, follow these steps:
sudo apt-get install libpcre16-3
sudo ln -s /usr/lib/x86_64-linux-gnu/libpcre16.so.3 /usr/lib/x86_64-linux-gnu/libpcre16.so.0
Install the library in CentOS:
sudo yum install ncurses-compat-libs
Install the library in OpenSuse:
sudo zypper install libncurses5
In this link it is also explained how to configure the installation to use Extract API 2.0. And in this link there is a section about troubleshooting with the Extract API.
The exporter offers some configuration parameters:
Mandatory
NOTE: adding @{jobTime} to the output file name is normally a good idea to avoid file name collision, which might result in previous output files being deleted. For example, a useful output name could be: @{projectName}_@{jobName}_@{jobTime}.tde or @{projectName}_@{jobName}_@{jobTime}.hyper
Optional
Select a job and edit it to add a new Tableau exporter.
Click on Edit Job → Exporters Section → New Exporter → TableauSchedulerExporter.
Fill, at least, the mandatory fields. For example:
Execute the job, and the client_export_output_file.tde will be created into the selected folder. You can see the data by opening the file using Tableau Desktop and build views as you can see below: