|
|
Daman's PeopleSoft Data Validation
Utility: streamlining data population for PeopleSoft HRMS 7.5
This flexible extension to data movement
solutions helps
- Minimize Incorporated services and costs PeopleSoft HRMS data validation business rules have been loaded, tested,
and verified by Daman Incorporated. Business rules contain the PeopleSoft HRMS embedded validation logic to ensure
the integrity of the incoming data.
- Reduce customization effort Application logic has been isolated, modularized, and defined using
natural language syntax which can be effectively manipulated by users without technical expertise.
- Provide maximum reusability Different business rules can be applied to a variety of application
resources. Individual rules may specify multiple conditions and complex relationships can be specified.
- Enables open integration Integration is supported through Daman's Business Rules Management
System technology. BRMS supports the leading component models, allowing for further processing and reporting flexibility.
- Automate the validation process Validation rules are generated automatically and are called automatically
during program execution.
Validating the integrity of data inbound to an ERP package such as PeopleSoft HRMS
is critical to the success of a data conversion. If proper data validation is not performed while attempting to
load data into PeopleSoft's HRMS application, the successful and timely deployment of the application is at severe
risk. From experience, the probability of success without data validation is near zero.
Thus, the biggest challenge experienced by all PeopleSoft data conversion teams is understanding and building the
data validation rules for data fields in hundreds of tables found in PeopleSoft's HRMS application within a very
short timeframe. Unless the data conversion team has access to significant expertise regarding PeopleSoft's HRMS
data validation rules and the PeopleSoft meta data tables which need to be referenced to ensure data integrity,
the data conversion team will find itself performing many iterations of testing before achieving success.
A solution backed by Daman's BRMS technology
To deal with the challenges of data conversions, Daman Incorporated has developed the PeopleSoft Data Validation
Utility for loading data into PeopleSoft applications and has integrated this utility with various data movement
tools such as the ETI*EXTRACT Tool Suite. This utility dramatically reduces the effort and time spent in analysis
and definition of data validation rules; allows data conversion teams to concentrate on data transformation activities;
allows capture of meta data of validation logic, while also facilitating reuse of developed business rules; and
supports the development of a solution that operates on varied platforms ranging from MVS and Unix to Windows NT.
The Data Validation Utility has been built using Daman's proprietary Business Rules Management System (BRMS) technology
to store and manage all the data validation rules. The rules can be accessed by 3GL (C, C++, COBOL, Java, and others)
or 4GL (perl, FOCUS, and others) programs running on any platform. This unique and revolutionary solution provides
significant flexibility in supporting data conversions to PeopleSoft on any platform and any database.
|