Forward Engineering a Query Mapping to a BI Tool

The data mapping allows you to define all the physical data integration constructs, including joins, filters, transformation operations, etc. You may export a query mapping (one target table at a time) to BI tools to export joins, etc., (only Tableau has been implemented in this case).

Forward Engineering Export menus are only available with certain licenses.

Steps

1.  Sign in as a user with at least the Metadata Viewing capability object role assignment on the Data Mapping  you are going to edit.

2.  Navigate to the object page for the query mapping inside the data mapping model.

3.  Go to  More Actions… > Export.

4.  Select the 3rd party tool format from the Export to pull-down.

5.  Click Export.

Example

Sign in as Administrator and go to the object page for the CustomerPayment query mapping in the Adjustments to Staging data mapping.

 

Graphical user interface, application Description automatically generated

 

Go to  More Actions… > Export and select the format to export to and click EXPORT.

Only Tableau is supported as an export format at this time.