This is the latest in our occasional series of data models which we have produced using Safyr®. These give some insight into those common business areas in SAP and ORACLE applications for which an understanding of how the underlying metadata is structured are often required for Information Management projects.
It’s a group of tables in the form of a data model from a PeopleSoft system showing a set of Customer tables and relationships.
I used Safyr® for PeopleSoft to achieve this very quickly and easily.
The model was created following some analysis in Safyr and then exported to Safyr’s own ERDiagrammer tool. The diagram is shown at the ‘Primary and Foreign Key’ display level. This masks some of the complexity of having a diagram showing all the attributes of each table, especially as some of the PeopleSoft tables have a lot of attributes.
Data model from a PeopleSoft system showing a set of Customer tables and relationships.