Ways we can migrate the data from MS-Access to PRPC DB
we have a requirement to migrate legacy data (Ms Access 7 Excel ) to Pega. What are the ways we can migrate the data from MS-Access to PRPC DB ? One of the application we are building has some history information in MS-Access and we wants to explore the options we have ? Please suggest.
***Updated by moderator: Lochan to branch reply and create new post***
Pegasystems Inc.
IN
Hi,
Please check below link.It may help you.
https://community1.pega.com/community/pega-product-support/question/migration-data-ms-access-pega
Coforge DPA
IN
Hi Ankit,
If its just data instances which you want to in pega then follow this approach.
You can use the options we have in the data explorer where you can import the excel sheet and if created record in Pega Database. In order to do that first you need create the data class and define the properties/columns required by using data wizard. And you can download the template using export and them copy the values into the template and import them.
Pegasystems Inc.
PL
Hi,
Or you may use third-party tools to migrate the data between different types of database, e.g.:
- https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL
- https://wiki.postgresql.org/wiki/Microsoft_Access_to_PostgreSQL_Conversion
- https://dbconvert.com/access/postgresql/
Thanks,
Lukasz