Tips & Tricks, erwin Data Modeler

How to Generate Source to Target Report beyond r7

Tace 28th November 2018

In version 7 of erwin Data Modeler it was easy to produce a Data Browser report of the mappings between columns in your model and their data movement sources. How can you do this in the latest version of erwin Data Modeler, now that the Data Browser has gone?

Assuming you have defined all of the relevant mappings in your model (if you don’t know how to create data movement sources and map your columns to them, check this out) you can get to them using the following query through the ODBC interface:

select
a.name "Target Column",
a.data_source_comment "Transform Comment",
c.name "Source Column",
t.name "Source Table",
s.name "Source Name"
from
data_sources_ref r
join
attribute a on r.id@ = a.id@
join
data_source_column c on r.value@=c.id@
join
data_source_table t on c.owner@=t.id@
join
data_source_object s on t.owner@=s.id@

I use this query with the Query Tool (available from the Tools menu), but you could use it with Crystal Reports, Excel, SQL Server Reporting Services or any ODBC-aware reporting tool.

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
A9Roowwxa cp3jx4 ilg 1