Recently I have had the pleasure of working with a couple of consulting firms who have been very creative with Metadata Workbench and the “Extension” features (Extension Mappings and Extended Data Sources) that were introduced last year in release 8.1.1. These companies have deep expertise on Information Server and DataStage as well as other ETL tools, and they have built tooling that automatically generates Extensions.
This is just a technical heads-up….. No bias here, nor am I doing their marketing, but it’s important that everyone knows that building lineage in Workbench for non DataStage processes is very do-able…all it takes is some creativity and awareness of the shell, 3GL program, or other ETL tool or process you are trying to illustrate…..we’ve had some entries in the forum on this subject, and some of you have asked me questions about it offline. Wanted to share these other resources.
Here are their sites if you are interested.
Accantec. http://www.accantec.com Cognos Data Manager. Accantec is based in Germany and has deep Cognos expertise. They have built tooling to illustrate Cognos Data Manager processes in Metadata Workbench for complete lineage.
Compact. http://www.compactBI.com Expertise in Informatica, AbI, others. They too have a solution that represents these tools within Metadata Workbench, often in combination with DataStage.