Exporting mapping models to files in CSV format

You can export the contents of a mapping model file to a file in comma separated values (CSV) format by using a wizard. After the contents of the mapping model are in CSV format, they can be easily imported into other tools (for example, spreadsheets). You can use this feature to more easily view mapping model contents and also communicate information about mapping models to team members who do not have access to the workbench.

Before you begin

Create a mapping model in a data design project.

About this task

When you export a mapping model to a file in CSV format, the contents of the mapping model are transformed as follows:
  • For one-to-one mappings, the resulting CSV file contains one row for each mapping.
  • For many-to-one mappings, there are multiple rows, one for each source and target pair.
The following mapping model elements are included in the CSV file:
Mapping model element Description
Mapping status Identifies whether the mapping has been proposed or accepted. A proposed status means that a relationship has been discovered, but has not been explicitly accepted as a mapping.
Mapping annotations User-defined annotations that provide additional information about the mapping. These annotations are added to the CVS file at the end of the row for each mapping. For example: Annotation1 – Value1, Annotation2 – Value2
Source and target node information Information about the source and target nodes, including:
  • Name - for example: Column1
  • Location (including project location) - for example:
    {/project1/Invoice.dbm}:/Database1/Schema1/Table1/Column1
  • Data type
  • Required (TRUE or FALSE)
  • Documentation
  • Primary key value and annotations
Source and target table information Information about the source and target tables, including:
  • Name - for example: Table1
  • Owner (Schema)

Procedure

To export a mapping model to a file in CSV format:

  1. Click File > Export from the main menu.
  2. On the first page of the wizard that opens, expand the Data node, select Export a mapping model to a file in CSV format, and click Next.
  3. Specify an existing mapping model to export, and specify a name and location for the CSV file. You must specify a new CSV file.
  4. Click Finish.

Results

The contents of the mapping model are transformed into CSV file format, and the resulting file is saved in the location that you specified.

Feedback