Tableau Server
Tableau is a business intelligence tool that allows you to connect to data, and create dashboards that can be shared. Tableau has a desktop component and a server component.
Objects Extracted
Enterprise Data Catalog extracts metadata from the server component of Tableau:
- •Bin
- •Calculation Dimension
- •Calculation Measure
- •Tableau Column
- •Columns
- •Condition
- •Connection
- •Dashboard
- •Data Source
- •Data Source Filter
- •Data Source Joins
- •Data Sources
- •Dimension
- •Dimension Table
- •Directory
- •Fact Table
- •Field
- •File
- •Filter
- •Group
- •Hierarchy
- •Hierarchy field
- •Join
- •Mark
- •Marks
- •Measure
- •Namespace
- •Page
- •Parameter Dimension
- •Parameter Measure
- •Parameters
- •Project
- •Proxy Field
- •Proxy Table
- •Published Data Source
- •Query
- •Relationship
- •Row
- •Rows
- •Session
- •Set
- •Shared Filter
- •Story
- •Tableau Table
- •Tableau Data Source
- •Tableau Server
- •Tableau Workbook
- •Temporary Field
- •Temporary Table
- •Unpublished Worksheet
- •Workbook
- •Workbook Data Source
- •Worksheet
Permissions to Configure the Resource
To connect to Tableau Server, Enterprise Data Catalog uses the credentials of a user created on the Tableau Server. Make sure that you configure the user account with the following license levels and permissions:
- •Interactor license level.
- •View and Download permissions for all projects, workbooks, and data sources for which you want to extract metadata.
Resource Connection Properties
The General tab includes the following properties:
Property | Description |
|---|
Server | The host name or the IP address where the Tableau server runs. |
Site | Specify the site if the Tableau server has multiple sites installed. The value is case sensitive. |
Username | The user name to connect to the Tableau server. |
Password | The password associated with the user name. |
Worker Threads | Number of worker threads required to retrieve metadata asynchronously. |
Auto Assign Connections | Specifies to automatically assign the connection. |
The Metadata Load Settings tab includes the following properties:
Property | Description |
|---|
Enable Source Metadata | Select to extract metadata from the data source. |
Enable Reference Resources | Option to extract metadata about assets that are not included in this resource, but referred to in the resource. Examples include source and target tables in PowerCenter mappings, and source tables and files from Tableau reports. |
Retain Unresolved Reference Assets | Option to retain unresolved reference assets in the catalog after you assign connections. Retaining unresolved reference assets help you view the complete lineage. The unresolved assets include deleted files, temporary tables, and other assets that are not present in the primary resource. |
Group By | Specify to group workbooks in the following categories: - - Project
- - My Workbooks
- - All Workbooks
|
Repository Objects | Imports the repository objects such as workbooks and data sources. For any workbooks, the dependent data sources are also imported. |
Memory | Specifies the memory required to run the scanner job. Select one of the following values based on the data set size imported: Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal |
JVM Options | JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters: - - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
- - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
- - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
- - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
- - -DhandleIdCollisionForTableau=true. Handles the duplicate object conflicts with the extracted Tableau objects.
|