Output Tableau - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Outputs Data360 Analyze data to the Tableau Data Engine (TDE) file format, allowing you to work with the output data within the Tableau application.

You can use this node to publish your data directly to Tableau Server or Tableau Online.

The following Data360 Analyze data types are supported: String, Long, Double, Integer, Boolean, Unicode, Date, Time, and Datetime.

CAUTION:
This node has been deprecated and will not be supported in a future release.

Creating a Tableau TDEfile

To output data to a Tableau TDE file, you just need to specify where to output the file in the OutputFilename property. See the OutputFilename property details below for more information.

If you want to specify a maximum number of records to include in the output, you can do this in the MaxRecords property.

Note:

  • The suffix of the output file must be ".tde".
  • Long will be converted to Double.
  • Time will be preceded by 1970/1/1 when stored in the Tableau format. Example: time 23:24:25 will be stored as 1970/1/1 11:24:25PM. When using the Tableau application to view the stored data, you may want to get the time portion only - you can do this by using the Tableau application functions to extract the time portion from the datetime value.

Uploading a file to Tableau Server or Tableau Online

To create a TDE file that is uploaded directly to Tableau Server or Tableau Online, enter the server connection and data source details as follows:

  1. Enter the URLof the server that you want to connect to in the Hostname property e.g. https://example.online.tableau.com/.
  2. Enter your Tableau user credentials in the Username and Password properties to sign in to Tableau Server / Tableau Online, as required.
  3. In the DataSourceName property, specify a name for the data source that will be created on the Tableau server when you upload your data.
  4. In the ProjectName property, specify the name of the Tableau project where you want to upload your data.
  5. If you also want to download a local copy of the TDE file, specify where to download the file in the OutputFilename property.

Properties

OutputFilename

Optionally click the folder icon and browse to the Tableau output file to which you want to output the data in Tableau format.

If the file does not exist, specify the output filename for the Tableau file e.g. C:\Users\<user>\Documents\Output_Tableau.tde, and a new file will be created. The folder where the file resides must exist. If not, the node will fail.

Note: If you are using the server edition, the output file will be created on the Data360 Analyze server. If you wish to open the file, and you don't have access to the file system on the server, you will need to download the file onto your local machine.

MaxRecords

Optionally specify a maximum number of records in the input to be output to the Tableau file.

If 0 is specified, all records will be converted.

The default value is 0.

Hostname

Optionally specify the URL of the server to connect to.

Username

Optionally specify the username of the user to sign in as. The user must have permissions to publish to the specified site.

Password

Optionally specify the password of the user to sign in as.

SiteID

Optionally specify the site ID. Leave this property blank to connect to the default site.

DataSourceName

Optionally specify the name of the data source to create on the server.

A value is required for this property if you are publishing to Tableau Server.

ProjectName

Optionally specify the name of the project to publish the extract to.

A value is required for this property if you are publishing to Tableau Server.

Overwrite

Set to True to overwrite an existing file that has the same name, otherwise set to False. This property applies to both the local case and the server case.

The default value is False.

Inputs and outputs

Inputs: indata.

Outputs: None.