How to get the old cases/work data to display in Pega dashboard?
Hi Team,
I have a requirement:
We have a Java application and all the data created from Java app is storing in an External DB.
Now we are implementing that in Pega application and Pega Dashboard is bedded in java application.
All the old cases created in java application should be displayed in Pega Dasboard.
How to do that? the old cases/work data should be displayed in Pega dashboard and how to connect this?
After linking this can we open the old case in Pega app.
Thanks.
***Updated by Moderator: Marissa to branch from this thread into a new one***
Pegasystems Inc.
US
Hello,
If the old application has the data in a database, you could use our various tools to read the data as an external data source and load it into the clipboard. From there, it's a property to display, just like any other.
Thanks,
Mike
Cognizant
IN
Hi Mike,
Thanks for the information.
Could you please elaborate the solution.
I will clarify my scenario once again:
We have a Java application and we are re-writing that into Pega and completed some work types.
how to get old Java application data(Objects) into new Pega application as a Case/WorkObject/CoverObject and how to add pega properties to that Java Object like pyID and etc.,
so it should behave like a workoject created in Pega for reporting/opening in Pega application and all.
Thanks.
Pegasystems Inc.
US
Hello,
It's hard to get into specifics without knowing how your old application is designed. If you have tables of data in a database, you should be able to query them, like any other DB table. If they are stored in some other format, you may need to do some transitional work. The good news is that Pega can read flat files, XML files, or any other number of industry standard ways for systems to pass data. You've got options. The biggest limitation would be on the legacy side.
Thanks,
Mike
Cognizant
IN
Thanks for the reply.
I have data in Data base tables and we have to create Pega Work Object for each record in DB.
Ex: we have 600 unique records in DB(of Java application) and for each record we need to create a Pega side Work Object.
is File listener/Service File option best suits for this situation? or suggest me some other options.
Thanks, AB
Carelon Global Solutions India LLP
IN
Hi Abhi,
For your requirement, I assume that your data is stored in some DB and if it is so, then for creating work objects, you need to write some activities explicitly which can connect to the DB and get data row-by-row and creates a Work object for each row. We had somewhat related requirement for our application and we used SQL DB to which we connected from PEGA end and migrated the data from previous application to current application.
But for your data model changes, I feel that there must be some Pega Data classes to be created on our end and make sure that they have a mapping with some table on the external DB end.
Thanks,
Praveen.