How to Generate Source to Target Report beyond r7
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.