Posted: 18 Feb 2021 1:30 EST Last activity: 1 Mar 2021 3:20 EST
Pega 5.x Application Data Extration Process
To give a background of this issue we are planning to decommission one of our Legacy System which is running on Pega 5.3x Version and we need to take full data backup(work Objects)
Since its is running on Pega 5.x we cannot use BIX (BIX can be used from Pega 6.X) only. Now I am working on this BIX Extraction process .
Below is the approach that I have taken.
As Part of POC we are following the below Approach instead of copying the media
Schema for both Rules & Data– Point to Pega 6 Instance and validate whether we can access Work Objects without any issue (compatibility validation – might not be mandatory).
If all Looks good, go with BIX extract– wherein, have mutual discussion along with business on CSV,XML etc / file output formats.
We have created new instances in Pega 6.2 Platform and successfully pointed to Pega 5 Schemas but we are unable to fetch the data(Application rules of Pega 5) from it.
By configuring as External DB Class mapping we are able to see the table information but we are not able see the Application rules 0f Pega 5 Application in Pega 6 Application.
Though I have configured new schemas pointing to Pega 5 DB by default system is pointing to Pega 6 DB Schemas.
If we are able to point default DB instances to Pega 5 Instances we may get the solution working(My assumption)
So I need your help to find is there any configuration that I need to change in our Application DB so that it will point to Pega 5 Application DB Schemas ( We are using WAS(Web Sphere Application Server)).
Your help will be highly appreciated!!!
Thank you in advance!!!
***Edited by Moderator: Pooja Gadige to move from Pega Academy to Product***
@Anil N I dont think just pointing to DB from PRPC 6.X version will be able either copy the WO data and extract it. Its better to first create 6.X instance using rule migration from 5.3 by skimming to major version. I am not sure whether the skimming in 5.3 for large application will be successful. But you can try it. Once its done then you can write utility to copy the Work Object to 6.X by creating Database instance for 5.3 DB. This will be easier to copy the data and then you can easily extract from 6.3 for BIX. I hope it makes sense.