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 tools, such as Informatica PowerCenter, IBM DataStage, Big Data, and Talend.

1. Go to Application Menu > Data Catalog > Mapping Manager.
2. In the Workspace Mappings pane, right-click a project.
   
3. Click Execute Connector.
   The Connectors page appears.
   
4. On the Connectors page, go to relevant tab based on the export requirements and select an ETL tool.
   The screenshot below displays Talend tab as an example.
   
5. Click .
   The Multi Mapping page appears.
   
6. Select the required mappings and click .
   The following notification appears.



7. Click Download File.
   Selected projects and maps are exported and downloaded as a ZIP file. Unzip this file to use mapping specifications in the TXT format.