Enterprise Data Catalog User Guide > Perform Asset Tasks > Export Asset Data to a Tableau Data Extract File
  

Export Asset Data to a Tableau Data Extract File

You can export asset data from resources, such as Hive, Teradata, and Oracle in Enterprise Data Catalog to a Tableau Data Exact (TDE) file.
You can export data from data assets, such as tables, and views to a TDE file. After you export asset data, view the TDE file in Tableau Desktop. To export asset data to a TDE file, verify that you have enabled the data read privilege and data read permission for the resource in Informatica Administrator. To view classified information of the asset data in Tableau Desktop, verify that you have enabled the sensitive data read privilege in Informatica Administrator.

Prerequisites

Before you export the asset data to a TDE file, contact your administrator and make sure that the following prerequisites are met:

Exporting Asset Data to a Tableau Data Extract File

Export asset data to a TDE file and view the details of the asset in Tableau Desktop.
    1. From the overview tab of a table, or view, open the menu () and select Export.
    The Export Data window appears.
    2. From the Select a connection drop-down list, select the database connection, and then click OK.
    Enterprise Data Catalog downloads the TDE file to your machine.
    Note: If you use a Hive connection to export, TDE export file does not include the data types, such as Array, Map, and Struc. If you use any other connection type, TDE export file does not include the binary data types.
    3. Open the exported TDE file in Tableau Desktop application to view the asset details.