Data Lineage – interested in integrating PowerDesigner with Solidatus?
PowerDesigner provides comprehensive support for data lineage via the mapping editor and the Data Modement model, but I’m sure SAP will agree that it isn’t the most intuitive data lineage solution on the market. There are several companies I know of that provide comprehensive visualisation and interrogating of data lineage, with the ability to link the metadata they extract from your applications and databases with metadata held in modelling tools.
Solidatus is one such company, here in the UK. They describe their offering as “an intuitive, simple to use web based application that gives you the ability to rapidly map and visualise your organisation’s data landscape — otherwise referred to as data lineage.”
Does your organisation use PowerDesigner for modelling, with or without data lineage? Are you also a customer of Solidatus, or perhaps you’re evaluating the tool? I’m looking for a forward-thinking organisation to work with, to build an integration between PowerDesigner and Solidatus. If you’re interested, please drop me a line.
George dot McGeachie at MetadataMatters dot com
Hi George,
Has there been any changes in last 3 years to maintaining Data Lineage in PD ?
I am returning back to PD after having used Erwin for last 2 years and looking to maintain Data Lineage between various layers of our Data warehouse data model.and generate an automated STM report from PD.
I don't think it has changed, Navin. There was talk of a generic ETL import/export capability but I think that didn't happen.
In an earlier comment (https://answers.sap.com/questions/12016165/data-lineage-model-using-powerdesigner.html) you mentioned that Erwin can keep lineage up to date - I didn't know Erwin Data Modeller could reverse-engineer lineage.
It can, by using a UDP and attaching to each column name in Erwin. You then manually populate this by importing the source model as a source in your target model and later you can generate a report out of this.
Gosh, I thought I liked PD when I switched over from Erwin initially and now I don't after coming back to it. Struggling to generate a simple data dictionary List report repeatedly for a specific set of tables selected in a diagram.
https://answers.sap.com/questions/9760573/generating-a-data-dictionary-report-and-restrictin.html?childToView=13053896&answerPublished=true#