During the last year I was involved in a project that had to migrate HR data from one system (SAP) to another (PeopleSoft) because of a merger. In many data migration projects where PeopleSoft is involved, they end up putting data into the system using Component Interfaces. And to be honest, it’s the only way to go. Unless of course you want to rebuild all the business logic into something else.

But that usually also means that literally all the validations and defaults are put into Application Engines to process the raw data. During this project we made the decision not to do that, yet split the load into two groups; first putting the raw data into PeopleSoft-ready data. Second, putting the transformed data through Component Interfaces.

The rest of this post I would like to put the following to your attention:

• Use of Informatica Powercenter as ETL tool
• Use of Application Engines and Component Interfaces to load data
• Extended use of Application Engines to start off sequential processes and split loads into groups that run simultaneously

Upgrading from one version of PeopleSoft to another one is a complex job. This post gives an overview for a practice case of an upgrade from HRMS v8.3 to HCM v8.9 for three individual hospitals, located in different area’s but with a co-working system.

A mixed team of people from both technical and functional backgrounds from Logica was appointed to fulfill this task.The RFP consisted of a number of guarantees that we were required to give to the client. It also included that the hospitals would like to complete the upgrade within a specified period of time.

BI Publisher provides a utility to facilitate the conversion of Oracle Reports (version 9i and later) to BI Publisher Reports. The conversion is a two-step process requiring a data model conversion and a layout conversion using the following new APIs:

• DataTemplateGenerator API converts the Oracle Reports data model to an XML Publisher data template.
• RTFTemplateGenerator API converts the Oracle Reports layout to an XML Publisher RTF template.

While using this utility, I ran accross a number of errors and an incomplete user guide. Migrating Apps Reports is certainly not a straightforward task. So lets look into this migration utility.