Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
titleINFO

Datameer supports Tableau version 9 and 10 in the formats HyperHYPER, TDE and TDSX. Older versions might not work as expected and are not supported.

Using the HYPER format requires at minimum operating system CentOS 7 with libc6 version >2.15/ libstdc++6 version >6.1.0.
Local execution can be used but is not scaleable.

Info
titleINFO

MapR distributions currently don't support the export to a Tableau server in the TDE format. This is due to the maprfs-x.x.x-mapr.jar which can't be changed by Datameer.

Table of Contents

Requirement: Configuring Tableau Server as a Connection

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

Info
titleINFO

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

Configuring Export Jobs with Tableau Server

...

To export a worksheet to a Tableau connector:

  1. Click the "+ (Plus)" button and choose "Export job, Job" or 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.
    Image Removed 
    Image Removed 
    Image Removed
  2. Select the workbook to export from in the browser.
    Image Removed
  3. in the browser and select "Create New" → "Export Job"The 'New Export Job' tab appears in the menu bar.
    Image Added Image Added
  4. Select the workbook to export from in the browser by clicking on "Select"The dialog 'Select Workbook' opens.
    Image Added 
  5. Select the workbook and confirm with "Select"The name of the workbook appears in the workbook field. 
    Image Added 
  6. Click "Next".  
    Image Added 
  7. Select the worksheet to export from out of the drop-down menu.
    Image Removed
  8. Select the Tableau connector.
    Image Removed
    Image Removed
  9. 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.

    Note
    iconfalse
    titleAs 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.

    Anchortdetde Note
    titleAs 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.

     The 'name of the sheet is displayed in the 'Select Sheet' field. 
    INFO: Only kept sheets are available for export. If the sheet you want to export is missing, modify the workbook settings to keep the sheet. 
    Image Added 
  10. Click "Next".
    Image Added 
  11. Select the Tableau connector by clicking on "Select Connection"The dialog 'Select Connection' opens. 
    INFO: If there is already a valid Tableau connection, you'll find it unter 'connection'. 
    INFO: If there is no valid connection to Tableau Server yet, you can create it here by clicking on "New Connection". 
    Image Added 
  12. Select the required Tableau Server connection and confirm with "Select"The selected connection is displayed in the 'Connection' field.
    Image Added 
  13. Click "Next"The 'Data Details' section opens.
    Image Added 
  14. Insert the name where the Tableau data source will be published under in the 'Data source name' field.
    Image Added 
  15. Select the publish options. 
    Image Added 
  16. Select the file format 'HYPER' from the drop-down for exporting data. 
    INFO: If you don't fulfil the requirements for using the Tableau Hyper file format, select 'TDE'.
    INFO: Downloading data without an export job is
    not possible as a TDE but is supported as TDSX.

    Image Removed

    File type mapping

    Column data field types between Datameer and Tableau differ and are accounted for during export. The following is the list of data type conversions:

    Datameer Data Field TypeTableau Data Field TypeBIG_DECIMALDOUBLEBIG_INTEGERLONG_INTEGERBOOLEANBOOLEANDATEDATETIMEFLOATDOUBLEINTEGERLONG_INTEGERLISTUNICODE_STRINGSTRINGUNICODE_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)
    Note
    titleAs 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.)

    Image Removed

  17. Preview the columns of the workbook to be included and choose how to handle invalid data.
    Image Removed
  18. 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. 
    Image Removed
  19. If needed, add a description and click Save.
  20. only possible for the TDSX format.
    Image Added 
  21. Select the settings for the owner. 
    Image Added 
  22. Enter the upload chunk size. 
    INFO: You can tune this value in case of network troubleshooting. 
    Image Added 
  23. Click "Next"The section 'Mapping' opens.
    Image Added 
  24. Check the preview and decide which columns will be included and whether invalid data is being accepted. 
    INFO: All checkboxes are activated per default. 
    Image Added 
  25. Decide how to handle invalid data. 
    Image Added 
  26. If needed, decide of time-based partitions and click "Next". The section 'Schedule' is shown. 
    INFO: This chapter only appears, when having partitioned data
    Image Added 
  27. Select the schedule method for when to run the export job. 
    Image Added 
  28. If needed, add an advanced information, e.g. custom properties and confirm with "Next"The section 'Save' is shown.
    Image Added 
  29. Add a export job description.
    Image Added 
  30. Mark the check box if you want to have the export job processed right after saving.
    Image Added 
  31. If needed, add your email address in section 'Notification' and confirm with "Save"The dialog 'Save Export Job' opens. 
    INFO: Datameer can only send email notifications if an email server has been configured.
    Image Added 
  32. Select the place to save the export job, name it and confirm with "Save"The export job is displayed in the export job. Exporting to a Tableau Server is finished. 
    Image Added