Mapping documentation tool for a federated VDB

[renaud.daian]

Hello,

we are creating a federated VDB. When working with Teiid Designer, the Package Diagram windows allows to see easily what attribute of the source view maps to what attribute of the target view. The problem is when you work on a federated VDB, a source attribute may be transformed multiple times before being mapped to the published target view. I summary that in the following picture (the arrow means "maps to") : SourceView.attr1 --> IntermediateView1.attr2 --> ... -> IntermediateView.attr2 -> TargetView.attrx

So in this case it is not easy to answer this simple question "What is the source attribute for TargetView.attrx".

Does somebody knows whether some tool is available for that ? The best solution for me would be to have that integrated into Teiid Designer, because it is interactive. But an acceptable solution, could be to have some automatic processor that would generate the mapping (in Excel or csv format, or other) directly from the VDB xmi files.

Regards

Renaud DAÏAN

[shawkins]

The system admin usage table provides dependency information for deployed vdbs - SYSADMIN · Teiid Documentation

Getting the information down to the column level requires a fix however that has not yet in a release - [TEIID-5137] SystemAdmin.usage column dependency issue - JBoss Issue Tracker

Publishing vdbs to Modeshape should provide this level analysis, but I don't have a quick reference for that. blafond or vhalbert may have more thoughts.