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.
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:
- Enter the URLof the server that you want to connect to in the Hostname property e.g.
https://example.online.tableau.com/. - Enter your Tableau user credentials in the Username and Password properties to sign in to Tableau Server / Tableau Online, as required.
- In the DataSourceName property, specify a name for the data source that will be created on the Tableau server when you upload your data.
- In the ProjectName property, specify the name of the Tableau project where you want to upload your data.
- 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.
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.