Export work object of multiple tables (more than 20) and import other environment
Requirement :export work object data of prod enviroment(example work object or case id ABC123) data related to this work object contains in 20 or more tables and each table has multiple records few tables more than 10000 records.
This data need to be export prod enviroment and import to non-prod enviroment for the purpose of debug the issues.
all this requirement need to be implemented through pega rules ( not DBA export and imprt)
Please can you share you inputs and idea to implement this for the purpose of export from prod and import to non-prod enviroment.