My company has bought Pega 7. We want to migrate some processes implemented in legacy system Visual Basic on Microsoft SQL Server into Pega 7 Case types.
Once we have created the case type in Pega, we want to migrate all inflight and resolved cases from legacy system into Pega 7 platform and create its corresponding cases types.
I would very much appreciated if someone could tell us how to approach this data migration or if there is any documentation available in PDN to do so.
Our first approach would be to export all inflight cases from legacy system into a csv file and read each line from a Pega Service File Listener, this service file listener will call an activity responsible to create the case type, map the info retrieved from the csv file and bring the case to its current stage or status based on the info taken from CSV file.
We do not know whether this is a feasible approach as we need to create case type and flow info such as pxFlow(), pxStageHistory(), etc .. and our case type there will be several parties and workbaskets involved so therefore it look to us that it can be quite complex the data migration by following this approach.
***Edited by Moderator: Pallavi to update platform capability tags***
These I believe have to be licensed separately and if you have it, then an option would be to create a data flow that starts with a table based data-set pointing to your legacy data. The data flow can enhance your legacy data with information from Pega then create corresponding case types when appropriate.
I would suggest speaking to your account team to get this further sorted out.