Tips & Tricks, erwin Data Modeler

Developing ETL specifications in erwin Data Modeler

Tace 28th November 2018

This video demonstrates how to document ETL steps in erwin Data Modeler 7.3

Note that this video does not have a soundtrack.

After watching this video, you will be able to:

  • Enable the Data Movement option
  • Create a data source
  • Map a target column to one or more source columns
  • Define a Data Browser report with source to target mapping details
  • Run the report and export it to Excel
product cta bg
Find out more

erwin Data Modeler

erwin Data Modeler is the industry-leading data modelling solution that enables organisations to discover, design, visualise, standardise and deploy enterprise data through an intuitive, graphical facility built on industry standards and best practices.

Read more
erwin Data Modeling Product CTA Banner, erwin data modeling, erwin data modeling, erwin data modeler download, erwin data modelling, erwin data modeller, erwin data modeller tutorial, erwin by quest, erwin quest. quest Erwin, data modeling tool, data management strategy
RELATED

Tips and tricks

erwin DM R14 – Importing objects into erwin DM models from Excel

There are various methods which one may use to import objects such as attributes and entities from excel into an erwin model. Which one you use will be highly dependent on both the format of your source data and how you want to integrate the new objects into erwin. Are you simply creating a new model from an excel definition, or are you using excel to integrate automation with your modelling?

Read more arrow_red Created with Sketch.

Creating Attributes from Custom Domains

Read more arrow_red Created with Sketch.

Saving DDL scripts to a Git Repository – erwin DM

In much the same way that we can save a model to the Mart Server repository for centralised storage, erwin Data Modeler 12.0 can integrate with Git repositories such as GitLab and GitHub to store DDL scripts generated using the forward engineer.

Read more arrow_red Created with Sketch.