Safyr® for PeopleSoft Metadata Visualization and Discovery – powerful exploration software to access, understand and exploit your metadata.
Safyr® for PeopleSoft is a powerful metadata visualization and discovery technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized PeopleSoft systems. This is a critical task for accelerating effective delivery of a wide range of information led projects. You utilise it to speed up the source data discovery process for many projects such as data catalog, data governance, data warehouse, data analytics, master data, data integration, data migration and more.
PeopleSoft presents you with challenges when you come to try to make sense of its metadata. For example there are thousands of tables and attributes for you to navigate, so finding the right ones for your project can be time consuming and difficult. In addition the relationships between the tables are not defined in the database system catalog. They are contained within the dictionary tables. This means you need a specialist tool to help you to make sense of the data model, analyse and find what you need and then use those results in other technologies to accelerate source data discovery.
Safyr is particularly useful if you have significantly extended the set of standard PeopleSoft tables and/or have multiple instances of PeopleSoft to manage. And, for example if you have implemented the PeopleSoft Pension administration module which usually requires significant customisation to meet customer requirements.
Using Safyr with the PeopleSoft Pension Application module.
Data teams at a US state use Safyr to provide them with rapid and accurate insight into the complex metadata in their PeopleSoft Pension Administration application
“The customizations required in the Pension Administration module of PeopleSoft are extensive. With proper scrutiny and discipline around modifications to the module (and system as a whole) and discipline around the Metadata of the objects, Safyr can positively impact downstream use of the data in the system”
Safyr® for PeopleSoft is a powerful exploration technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized PeopleSoft systems. This is a critical task for accelerating effective delivery of a wide range of information led projects.
Customers use Safyr to solve the 3 challenges associated with PeopleSoft metadata discovery.
Discovery: Locating the source of the useful, business ready metadata in your applications. There is very little of any value in the data system catalog. The useful metadata is in a series of data dictionary tables in the PeopleSoft application layer.
Scoping and curation: Once the metadata has been located, the next challenge is to find the table or tables necessary for your task and save them for use in other tools and systems.
Delivery: The final hurdle is to provision the metadata into other tools and technical formats. These include data catalog and governance solutions such as Collibra, Informatica EDC, Alation, Infogix, ASG and Adaptive as well as data modeling tools such as SAP PowerDesigner, ER/Studio, erwin. Or you might want to use the information in Excel, CSV, XML or JSON formats.
Learn more about Safyr for PeopleSoft below.
List all PeopleSoft Tables
Safyr reveals details of all the tables in the PeopleSoft database, including any added by the user.
It’s easy to search the tables and to see the numbers of relationships to other tables in the PeopleSoft system, and the number of Rows in each table.
Show full details of a PeopleSoft Table
Each table can be expanded to show all the Fields, the Primary Key and Foreign Keys and a detailed description of each Field, all based upon the definitions in the PeopleSoft Data Dictionary.
See Parent and Child Tables for a PeopleSoft Table
Safyr extracts Relationship information to help the user understand how PeopleSoft joins tables. Using this information, details of the related tables for a given table can be displayed. In addition, its easy to filter out any of the related tables that do not contain data.
We can help with your Business Case for Safyr.
See tables in a Hierarchy of PeopleSoft Modules
As well as seeing tables in list form, Safyr provides a Hierarchy of PeopleSoft modules, grouping the Tables by business areas like Order Entry, Payables and Receivables.
Visualize PeopleSoft Tables as a Data Model
Tables can be grouped into Subject Areas with Safyr and then visualised as an Entity Relationship diagram, either using Safyr’s built-in ERDiagrammer, or a range of popular data modelling tools including ERwin, ER/Studio and PowerDesigner.
An accurate and relevant PeopleSoft data model will often be an important step in understanding PeopleSoft data. Request a PeopleSoft Data Model that best fits your requirement.