![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Intelligent ERDs Topic Summary: How do I autogenerate diagrams based on parameters Created On: 21-May-2007 18:55 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
We are using System Architect to help us keep track of a PeopleSoft environment. There are over 50,000 tables in over 100 Data Subject Areas. We are using SA ERP to export from PeopleSoft to System Architect and manage the DSAs. We can create Logical Diagrams for each DSA or for the entire environment, but these are still overwhelming, some with over 1000 tables. We currently track for all of the tables and elements, whether they are used or not within our environment.
I am trying to figure out if using VBA or similar, if we can create a script that will only model all of the USED tables for a given DSA but not show the UNUSED ones. Even better yet, if there are UNUSED attributes, I would like them to not show up. This would give us publishable diagrams of only what is important to our users and not all of the extras.... |
|
![]() |
|
![]() |
|
We did something 'similar' quite a while ago - modelling data held in a SAP BW warehouse, which contains a large number of tables.
The approach we took was to obtain an xml file from SAP BW that defined the tables that we were interested in. We then had a Telelogic consultant write a macro that parsed the xml and converted the interpreted contents into SA. IIRC it took about 3 days work for the consultant. The key is obtaining a file from the source that just contains the data that you are interested in, and defining what types of objects you want them created as in SA. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.