Tableau V3 Connector > Mappings and mapping tasks with Tableau > Tableau V3 objects in mappings

Tableau V3 objects in mappings

When you create a mapping, you can configure a Target transformation to represent a Tableau object.

You can specify a TWB template and TWBX file to the .hyper file to create a TWBX file that you can publish to Tableau. You can choose to create or overwrite data when you publish the .hyper or TWBX file to Tableau.

If you specified Tableau Desktop in the connection properties, the Secure Agent performs the operation on the local machine. You can provide the extract file path and name on the local machine where you want to save the .hyper or TWBX file. You can choose to append or overwrite data when you publish the .hyper to Tableau Desktop.

If you specified Tableau Server or Tableau Online in the connection properties, the Secure Agent publishes the .hyper or TWBX file in Tableau Server or Tableau Online. You can choose to provide a name for the .hyper or TWBX file that you want to publish as data source to Tableau Server or Tableau Online.

Tableau V3 targets in mapping

In a mapping, you can configure a Target transformation to represent a single Tableau object.

You can configure the target properties when you create a mapping on the Target page.

The following table describes the Tableau V3 target properties that you can configure in a Target transformation:

Property	Description
Connection	Name of the target connection.
Target Type	Type of the target object. Select Single Objects.
Object	Select an existing target object. To select an existing target, search for the target file name in the Package Explorer section or expand the package to see all the file extracts available inside the package. You do not have to add different target connections to view all the different .hyper extract files. When you select an existing target object, the extension of the target file name are not displayed. You must ensure that you select the .hyper extract file to avoid any failure. In the Package Explorer section, the empty projects are not displayed. If you want to add new .hyper extract files in the project, create a new target object.
Operation	Target operation. Select Insert.
Create Target	Creates a new target object. Enter a name and path for the target object and select the source fields that you want to use in the target fields. By default, all source fields are included and the default name of the target object is the source object name.

Tableau V3 advanced target properties in mappings

When you configure a mapping, you can configure the advanced target properties.

The following table describes the Tableau V3 advanced target properties:

Property	Description
Extract File Path	The file path where you want to save the generated Tableau .hyper file. Ensure that the file path is on the Secure Agent machine for Tableau Desktop. The Secure Agent uses the following default file path for the target .hyper file: <Secure Agent installation directory>/apps/Data_Integration_Server/<latest version>/main/bin/rdtm This file path does not apply to Tableau Server and Tableau Online. You must configure JVM options to use a different file path for Tableau Server and Tableau Online. To do this, select the DTM type and set JVMOption to -Djava.io.tmpdir=<path> in the Secure Agent properties. Note: This property is mandatory when you create a target and publish the .hyper file to Tableau Desktop.
Extract File Name	Name for the Tableau data extract file with the .hyper extension. Default is the file name you specified when creating the target object. If the operation is for Tableau Server or Tableau Online, the file gets deleted after the Secure Agent publishes the .hyper file to Tableau Server or Tableau Online. To publish a TWBX file to Tableau, you must provide the extract file name salesforce_opportunity.hyper defined in the template. Note: This property is mandatory when you create a target and publish the .hyper file to Tableau Server. For Tableau Server, the Secure Agent overwrites the target object file name when you specify this property.
Target Operation	Creates, appends, or overwrites the .hyper file on the local machine, Tableau Server, or Tableau Online. Select one of the following options to publish the .hyper file: Create Creates a .hyper file. Ensure that a .hyper file with the same name does not exist. The append operation is not applicable for the TWBX file. Append Adds data to an existing .hyper file. Overwrite Deletes the existing .hyper file and creates a new .hyper file. The append and overwrite operations work only if there is an existing .hyper file. Default is Create.
Project Name	Name of the project within a specific site on Tableau Server or Tableau Online where you want to publish the Tableau .hyper file. By default, the Tableau V3 connection publishes the .hyper file to the default project on the site that you specify on Tableau Server. Note: You must enter the Project Name as Default to publish the .hyper file to the default project within a specific site on Tableau Server.
Data Source	Name of the Tableau .hyper file that you want to publish to Tableau Server or Tableau Online. If you do not specify a data source name, the default Tableau .hyper file name remains the source name. If you do not specify a data source name, the extract file name remains the data source name. If you do not specify both the data source name or the extract file name, the metadata file name or the target .hyper file name remains the source name.
Workbook Name	Name for the workbook that you want to publish to Tableau. If you do not specify a workbook name, the name of the TWB template file remains the workbook name. Note: Do not add the .twbx extension in the workbook name as the Tableau V3 Connector adds the extension automatically.
Workbook Template File Name	Name and path of the Tableau packaged workbook file (TWBX) that you want to apply to the .hyper file to generate a TWBX file. Ensure that the workbook is of the extract type. Also, ensure that you provide the absolute path along with the template file name and the TWBX extension. For example, /home/filename.twbx Note: When you use the workbook template file, the data source specified in the template creates the workbook, not the data source specified in the advanced target properties.
Forward Rejected Rows	Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task application forwards rejected rows to the next transformation.