Skip to main content

Data model name mapping

Data model name mapping allows you to replace technical database strings with intuitive, business-friendly labels. By translating complex table and column names into clear language, you ensure that your business users can easily navigate and analyze data without needing to understand the underlying source system structure.

Mapping your names

To map your data model names from your data pool diagram:

  1. Click Data Model.

  2. Select the data model you want to map.

  3. Click Name Mapping.

    A screenshot showing how to use name mapping.

  4. Configure your name mapping using either a file upload or from your data pool.

Table and column name mapping from imported data pool

Table and column name mappings can also be imported from a data pool and use the dictionary tables from your source system, such as DD02T and DD03M in SAP.

A screenshot showing a configured name mapping screen.

When mapping your names from the data pool, you must identify the following columns:

  • Technical table / column name: The technical name of the table or column in the data pool which equals the name in the source system if it was not changed.

  • Pretty table / column name: The human readable table or column name in the given language.

  • Language key: The language to which to translate the table or column name.

Name mapping from file upload

You can also map your names from a file upload:

  1. Download a template file (.xlsx) prefilled with your table and column names.

    A screenshot showing how to download current name mapping configurations.

  2. Fill out the human readable version of those names.

  3. Reupload the file to apply the name mappings.

When populating the template, there are three sheets: Table name mapping, column name mapping, and general name mapping.

In these sheets, you'll find the following input columns:

  • TABLE_NAME: The technical name of the table in the data pool which equals the name in the source system if it was not changed.

  • COLUMN_NAME: The technical name of the column in the data pool which equals the name in the source system if it was not changed.

  • LANGUAGE_KEY: The language to which to translate the table or column name.

  • TRANSLATION: The human readable table or column name in the given language.

  • TRANSLATION_KEY: The placeholder translation key.

  • DESCRIPTION: A reference only, providing more information on the translated term.

Related topics