Exporting Mapping Specifications to ETL Tools

Once the mappings are considered 'approved for coding', you can export the mappings as coding requirements to automatically generate ETL/ELT jobs for industry leading ETL tools like Informatica PowerCenter, IBM DataStage, Microsoft SQL Server SSIS, and Talend.

  1. Go to Application Menu > Data Catalog > Mapping Manager > Workspace Mappings.
  2. Expand the desired project node and click the desired mapping.

    3. The Mapping Specification tab appears on the center pane.

  3. Click .

    4. The Export Window appears.

  4. Click ETL Engineering tab.
  5. Select the desired ETL tool and click .

    6. Multi Mapping page appears.

  6. Select the mapping to be exported from the tree and click .
  7. Download the XML / DTSX file by clicking the Download File hyperlink.

The mapping specification is exported.