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 All Permissions or Metadata and Data Read permission for the resources in Catalog 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. To hide the Export option in the catalog for all users irrespective of the permissions assigned, configure the LdmCustomOptions.enableTDEExport custom property for the Catalog Service and set the value as false in Informatica Administrator.

Note: You must rerun the Catalog Service after you configure the LdmCustomOptions.enableTDEExport custom property 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:

•Create the necessary database connections in the Informatica Administrator console for resources, such as Teradata, Hive, and Oracle.

•Assign the required permissions and privileges to the non-administrator users to export and view the asset data in the Tableau Desktop.

•Set the row count value that you want to export in the Custom Properties of Informatica Administrator. Configure the dpRowLimit custom property to a value that you want to export. By default, Enterprise Data Catalog exports 50,000 row values to a TDE file.

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.