Exporting to a Tableau Server

Datameer supports data export to Tableau in Hyper, TDE and TDSX formats.

Configuring Tableau Server as a Connection

A Tableau Server connection with Datameer must be created before exporting data.

Learn about setting up a connection between Datameer and Tableau Server.

Configuring Export Jobs with Tableau Server

80 (HTTP) and/or 443 (HTTPS) need to be open to export data from Datameer to a Tableau server.

To export a worksheet to a Tableau connector:

1. Click the + (Plus) button and choose Export job, right-click on a folder, select Create New then choose Export Job, or right-click on the workbook to export from and select New export job.
    
    
   
2. Select the workbook to export from in the browser.
   
3. Select the worksheet to export from the drop-down menu.
   
4. Select the Tableau connector.
   
   

5. Fill out the Data Details, including giving the file a name published on the Tableau server, deciding if data should be overwritten, and which project on the Tableau server to assign the file.

   As of Datameer v6.1

   An option allows you to designate the owner for an export file on the Tableau server. Choose between either the current Datameer owner of the connection or a specific owner on the Tableau server.

   If the user of the Datameer connection isn't a Tableau Server admin, you can only choose the owner of the connection. If the user is later set as a Tableau Server admin, the option to change to a different Tableau owner is possible.

   If the owner has been set to be a specific owner on the Tableau server and that owner is later deleted, the next time the export jobs runs, the radio button automatically reverts back to Use Owner from the Datameer connector on Tableau.

   As of Datameer v6.3

   Export using the TDE (Tableau data extract) file format. TDE files are a local copy of a subset or the entirety of the data that you can use to share, work offline, and improve your database performance.

   This feature is only supported for Datameer installations running on Linux.

   Downloading data without an export job is not possible as a TDE but is supported as TDSX.

   

   File type mapping

   Column/wiki/spaces/DAS60/pages/4620163738 between Datameer and Tableau differ and are accounted for during export. The following is the list of data type conversions:

   Datameer Data Field Type	Tableau Data Field Type
   BIG_DECIMAL	DOUBLE
   BIG_INTEGER	LONG_INTEGER
   BOOLEAN	BOOLEAN
   DATE	DATETIME
   FLOAT	DOUBLE
   INTEGER	LONG_INTEGER
   LIST	UNICODE_STRING
   STRING	UNICODE_STRING

   When there is data overflow

   • BIG_DECIMAL => DOUBLE => positive/negative infinity on overflow
   • BIG_INTEGER => LONG_INTEGER => arithmetic exception => record dropped (or job aborted, based on your export job setting)

   As of Datameer v7.4

   As of Datameer 7.4, export using the Tableau Hyper file format is supported and all Datameer versions above 7.4.7 will show the Hyper format. 

   (Note, however, that although Datameer allows the option, Tableau Server before v10.5. will not support the export into Hyper format. When export is created and triggered to an unsupported Tableau Server, ingest of the Hyper format file will be refused.)

   

6. Preview the columns of the workbook to be included and choose how to handle invalid data.
   
7. Choose when to run the export job. Export jobs can either be run manually, run each time the workbook in Datameer is calculated, or at specifically scheduled times.
   Custom properties can be added in the Advanced section as well as logging specifications. 
   
8. If needed, add a description and click Save.