How to Generate Source to Target Report in r8

In version 7 of CA 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 r8, 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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *