Skip to content

The data mapping allows you to define all the physical data integration constructs, including joins, filters, transformation operations, etc.. You may forward engineer (export) this metadata into 3^rd^-party data integration DI) tools.

In addition, 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.

Forward Engineering a Data Mapping to a DI Tool

The data mapping allows you to define all the physical data integration constructs, including joins, filters, transformation operations, etc.. You may forward engineer (export) this metadata into 3^rd^-party data integration DI) tools.

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 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 Adjustments to Staging data mapping.

Graphical user interface, text, application, email Description automatically generated

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

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

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.