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).

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 3^rd 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.

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