IBM services offer a utility for getting business terms out of a logical data model maintained in ERwin version 7.0 and loading them into Business Glossary.
Has anyone used this tool and, if so, how is it used? Are there any instructions for it? How easy is it to use? What does it actually do?
The utility was written by Riccardo Tani, but I hear that Riccardo has left IBM.
Pinned topic erwin2bg
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-02-16T06:25:40Z at 2012-02-16T06:25:40Z by RayWurlod(ZenithSolutions)
YuJo 0600029RTJ4 Posts
Re: erwin2bg2011-11-01T06:06:21ZThis is the accepted answer. This is the accepted answer.Hi,
I didn't use it, but I did make another XML Stylesheet(XSL) to convert ERwin 7.2 data model into a BG XML import file. Here is the process :
- Save ERWin model as AllFushion Repository(XML) format;
- run msxsl(Microsoft XML Framework 4), using the ERwin XML file and the XSL file as input, and convert the model into another XML schema;
- Import the generated XML into Business Glossary via InfoSphere web console.
This has been tested on 8.1.2. The benefit of using XSL is it's a script file and you can easily control and change how your logical data model is mapped to categories and terms in BG.
The subject area diagrams need another Visio VBA program to convert into HTML, and if you want to be able to jump to the table in metadata repository by clicking a box on the diagram, it requires some extra steps.
Happy to discuss more !
RayWurlod(ZenithSolutions) 270002XABQ3 Posts
Re: erwin2bg2012-02-16T06:25:40ZThis is the accepted answer. This is the accepted answer.We decided to install version 8.7, in which it is possible to import logical data models via the ERwin bridge. You can then run an istool glossary ldm2bg command to get at the business terms contained in the logical data model.