{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":22255,"path":"integrate-applications/tableau-metadata-collector.md","title":"Tableau metadata collector","bundle":null,"doc_type":null,"release":"australia","body":"\n# Tableau metadata collector\n\nTableau metadata collector provides read-only access to metadata from a Tableau account.\n\nThe Tableau collector harvests metadata from Tableau objects \\(such as workbooks and dashboards\\) in the Tableau Online or Tableau Server instances. Use harvested metadata to perform impact analysis and understand how changes to upstream data sources affect Tableau objects.\n\n## Tableau version supported\n\nThe collector supports Tableau Cloud and Tableau Server. Supports Tableau API versions 3.10 and above on Tableau Server v2022.1.\n\n## Authentication supported\n\nThe Tableau collector supports the following authentication methods:\n\n-   [Personal Access Token](https://help.tableau.com/current/server/en-us/security_personal_access_tokens.htm)\n\n-   [Username and password](https://help.tableau.com/current/blueprint/en-us/bp_authentication_authorization.htm#:~:text=Tableau%20credentials%20are%20made%20up,(SSO)%20via%20OpenID%20Connect.)\n\n\n## Metadata cataloged\n\nThe Tableau collector catalogs the following information:\n\n<table id=\"table_dyv_5mk_xhc\"><thead><tr><th>\n\nObject\n\n</th><th>\n\nInformation cataloged\n\n</th></tr></thead><tbody><tr><td>\n\nDatabases\n\n</td><td>\n\nName, Identifier, Description, Database Connection Type\n\n</td></tr><tr><td>\n\nDatabase Schemas\n\n</td><td>\n\nName, Identifier\n\n</td></tr><tr><td>\n\nDatabase tables\n\n</td><td>\n\nName, Identifier\n\n</td></tr><tr><td>\n\nDatabase columns\n\n</td><td>\n\nName, Identifier\n\n</td></tr><tr><td>\n\nTableau Databases\n\n</td><td>\n\nName, Identifier, Connection Type\n\n</td></tr><tr><td>\n\nTableau Database tables\n\n</td><td>\n\nName, Identifier, Connection Type\n\n</td></tr><tr><td>\n\nTableau Database columns\n\n</td><td>\n\nName, Identifier\n\n</td></tr><tr><td>\n\nProjects\n\n</td><td>\n\nName, Description\n\n</td></tr><tr><td>\n\nWorkbooks\n\n</td><td>\n\nName, Description, Creator Email, Creator Name, Creator Tableau User, Preview Image, and Workbook URL **Note:** Unpublished workbooks aren’t cataloged because the Tableau REST APIs don’t return unpublished objects.\n\n</td></tr><tr><td>\n\nDashboards\n\n</td><td>\n\nName, Creator Email, Creator Name, Creator Tableau User, Preview Image, Dashboard URL, Number of Favorites, and Number of Views**Note:** Unpublished dashboards aren’t cataloged because the Tableau REST APIs don’t return unpublished objects.\n\n</td></tr><tr><td>\n\nViews\n\n</td><td>\n\nName, Creator Email, Creator Name, Creator Tableau User, Number of Views, Number of Favorites, Preview Image, and View URL**Note:** Unpublished views aren’t cataloged because the Tableau REST APIs don’t return unpublished objects.\n\n</td></tr><tr><td>\n\nDatasource fields\n\n</td><td>\n\nName, Identifier, Description\n\n</td></tr><tr><td>\n\nCalculated fields\n\n</td><td>\n\nName, Identifier, Description, Calculation Formula, Category, Role, Type\n\n</td></tr><tr><td>\n\nGroup fields\n\n</td><td>\n\nName, Identifier, Description, Category, Role, Type\n\n</td></tr><tr><td>\n\nBin fields\n\n</td><td>\n\nName, Identifier, Description, Category, Role, Type, Bin Size\n\n</td></tr><tr><td>\n\nColumn fields\n\n</td><td>\n\nName, Identifier, Description, Category, Role, Type\n\n</td></tr><tr><td>\n\nMetrics\n\n</td><td>\n\nName, Identifier, Description, Creator Email, Creator Name, Creator Tableau User, Metric Url\n\n</td></tr><tr><td>\n\nCustom SQL tables\n\n</td><td>\n\nName, Identifier, Description, SQL Query\n\n</td></tr><tr><td>\n\nEmbedded data sources\n\n</td><td>\n\nName, Identifier, Last refresh date\n\n</td></tr><tr><td>\n\nPublished data sources\n\n</td><td>\n\nName, Identifier, Description, Last refresh date\n\n</td></tr></tbody>\n</table>## Relationships between objects\n\nCatalog pages show relationships between the following data asset types:\n\n<table id=\"table_kvt_2nk_xhc\"><thead><tr><th>\n\nData asset page\n\n</th><th>\n\nRelationship\n\n</th></tr></thead><tbody><tr><td>\n\nDatabases\n\n</td><td>\n\n-   Schemas contained within the database\n-   Tables contained within the database\n\n</td></tr><tr><td>\n\nDatabase Schemas\n\n</td><td>\n\nTables contained within the schema\n\n</td></tr><tr><td>\n\nDatabase tables\n\n</td><td>\n\n-   Schema containing database table\n-   Database containing the database table\n-   Views using the database table as a data source\n-   Column fields using the database table as a data source\n\n</td></tr><tr><td>\n\nDatabase columns\n\n</td><td>\n\n-   Tables containing the database columns\n-   Column fields referencing the database columns\n\n</td></tr><tr><td>\n\nTableau Databases\n\n</td><td>\n\nTableau Tableau Database table contained within the Tableau Database\n\n</td></tr><tr><td>\n\nTableau Database tables\n\n</td><td>\n\nTableau Column contained within the Tableau Database table\n\n</td></tr><tr><td>\n\nTableau Database columns\n\n</td><td>\n\nTableau Column Field referencing the Tableau Database Column\n\n</td></tr><tr><td>\n\nProjects\n\n</td><td>\n\n-   Views contained within the project\n-   Workbooks contained within the project\n-   Dashboards contained within the project\n-   Subprojects contained within the project\n-   Published Data source\n\n</td></tr><tr><td>\n\nWorkbooks\n\n</td><td>\n\n-   Projects that contain a workbook\n-   Data sources embedded within the workbook\n-   Views contained within the workbook\n-   Custom SQL Tables embedded within the workbook\n\n</td></tr><tr><td>\n\nDashboards\n\n</td><td>\n\n-   Fields used by dashboard\n-   Custom SQL tables used by dashboard\n-   Projects containing dashboard\n-   Tables used by dashboard\n-   Workbooks containing dashboard\n-   Views embedded in dashboard\n\n</td></tr><tr><td>\n\nViews\n\n</td><td>\n\n-   Fields used by view\n-   Custom SQL tables used by view\n-   Projects containing view\n-   Database Tab;es used by view\n-   Workbooks containing view\n-   Dashboards that embed the view\n-   Metrics presenting the view\n\n</td></tr><tr><td>\n\nDatasource fields\n\n</td><td>\n\n-   Views that use the datasource field\n-   Dashboards that use the datasource field\n-   Data source fields containing the datasource field\n\n</td></tr><tr><td>\n\nCalculated fields\n\n</td><td>\n\n-   Views that use the calculated field\n-   Dashboards that use the calculated field\n-   Data sources containing the calculated field\n\n</td></tr><tr><td>\n\nGroup fields\n\n</td><td>\n\nData sources containing group field\n\n</td></tr><tr><td>\n\nBin fields\n\n</td><td>\n\nData sources containing group field\n\n</td></tr><tr><td>\n\nColumn fields\n\n</td><td>\n\n-   Data Source containing the column field\n-   Views that use the column field\n-   Dashboards that use the column field\n\n</td></tr><tr><td>\n\nCustom SQL tables\n\n</td><td>\n\n-   Views using Custom SQL table\n-   Dashboards using Custom SQL table\n-   Workbooks using Custom SQL table\n\n</td></tr><tr><td>\n\nEmbedded data sources\n\n</td><td>\n\n-   Fields contained within the embedded data source\n-   Workbook containing embedded data source\n\n</td></tr><tr><td>\n\nPublished data sources\n\n</td><td>\n\nFields contained within the published data source\n\n</td></tr></tbody>\n</table>## Lineage for Tableau\n\nCollected lineage information:\n\n|Object|Lineage available|\n|------|-----------------|\n|Database columns and tables|Fields that use database columns and tables|\n|Projects|Databases, Database schemas, Database Tables, Database Columns, Workbooks, Views, Dashboards, custom SQL tables, and Data sources that projects contain|\n|Dashboards|Fields and tables that dashboards source their data from|\n|Views|Fields and tables that views source their data from|\n|Fields|Columns, tables, and other fields that a field uses its data from|\n|Tableau Database tables|Tableau Databases containing the Tableau Database table|\n|Tableau Database columns|Fields that reference the Tableau Database column, Tableau Database tables containing the Tableau Database column|\n|Published data sources|Embedded data sources that were derived from published data source|\n|Embedded data sources|Database tables and Database columns that the Embedded data source uses data from.|\n|Custom SQL Tables|Database tables and Database columns that the Custom SQL Table uses data from. Note: Lineage isn’t created between Custom SQL Tables and columns or tables that aren’t available in the API.|\n\n**Note:** Cross-system lineage isn’t supported for ODBC connections or when columns or tables are unavailable in the API.\n\nSupported data sources for cross-system lineage:\n\n-   Postgresql\n-   Snowflake\n-   BigQuery\n-   Redshift\n\n-   **[Prepare to run the Tableau collector](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/prepare-to-run-tableau-collector.md)**  \nSet up API access, authentication, and permissions before running the collector.\n-   **[Create a Tableau metadata collector](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-tableau-metadata-collector.md)**  \nCreate a collector to import metadata from Tableau.\n\n**Parent Topic:**[Configuring metadata collectors](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/configure-metadata-collectors-dc.md)\n\n"}}