Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 21-May-2007 18:55
User is offline View Users Profile Print this message


Michael Schievelbein

Posts: 4
Joined: 15-May-2007

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....


Report this to a Moderator Report this to a Moderator
 27-Jul-2007 10:09
User is offline View Users Profile Print this message


Mike Parmley

Posts: 1
Joined: 12-Feb-2007

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.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.