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: Modeling Peoplsoft DataWarehouse
Topic Summary: PeopleSoft Physical and Logical Models
Created On: 5-Jun-2007 13:46
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.
 5-Jun-2007 13:46
User is offline View Users Profile Print this message


Michael Schievelbein

Posts: 4
Joined: 15-May-2007

We are attempting to model our Peoplesoft DataWarehouse.  We need to keep track of both the delivered 52K+ tables and 20K+ views on the pysical layer, in addition we plan on using SA ERP to model the logical layer and inport it into System Architect.  Our problems are multifold and I need to see if anyone has found a workaround or different process. 

When we try to RDE (Reverse Database Engineer) the underlying Oracle Database, SA will only let us bring in 10114 tables per physical data model.  This would be o.k., because we only need to MODEL around 5000 of the tables that are used, but we need to import all 52K+ tables and create definitions for them so we can keep track of them for metadata repository needs.  We cannot just create the table dfinitions via XML import or similar, because every table has to be represented on a Physical Model and we run into the 10K limit again.

I would be happy only modeling the logical side of the Peoplesoft instalation, but when we use SA EPR, it only shows 19K Entities which does not coorispond to the 52K tables, so I do not know what is missing, and I have no way of knowing if developers have installed custome non-Peoplesoft tables by using SA ERP, I only have the audit capabilities using System Architect RDE functionality.

Any suggestions or workarounds are appreciated.  We really need to be able to do all of this Meta-Data Management in order to complete our EA functionality.

Michael Schievelbein
MRM/Dept of Interior
Report this to a Moderator Report this to a Moderator
 7-Jun-2007 10:39
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi

I have raised your question internally. I will let you know what transpires.
If any other users have been in similar situations maybe you have some advice?

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
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.