![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Hi I have raised your question internally. I will let you know what transpires. ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.