Understand and manage your PeopleSoft 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.