Whenever a business user inserts or modifies records in the Delegated DataType in Production environment, we need to sync all the lower environments with updated data. Is there any way to implement this ?

  • If your database is Oracle, it comes as part of the database architecture. You can configure golden gate replication in Oracle database, which would keep tables between databases on-sync.

    If it's some other database apart from Oracle, then we need to implement it with a custom logic,

    • using a declare trigger that would update the required tables on each CRUD operations. We can have REST service hosted in all the destination systems.
    • using BIX to extract and load the data on recursive basis.
    • using listeners (JMS/MQ) to post the message to a Queue that would be listened by the destinations.
    • custom background processing that would export the data from source and load it to the target.

    But copying the data from PROD to lower environments does not sound like a realistic requirement. We might fall under GDPR PII issues.

If your database is Oracle, it comes as part of the database architecture. You can configure golden gate replication in Oracle database, which would keep tables between databases on-sync.

If it's some other database apart from Oracle, then we need to implement it with a custom logic,

  • using a declare trigger that would update the required tables on each CRUD operations. We can have REST service hosted in all the destination systems.
  • using BIX to extract and load the data on recursive basis.
  • using listeners (JMS/MQ) to post the message to a Queue that would be listened by the destinations.
  • custom background processing that would export the data from source and load it to the target.

But copying the data from PROD to lower environments does not sound like a realistic requirement. We might fall under GDPR PII issues.

Write a Reply...

-An Initiative Of OneStopPega- Love our work? Support Us🖤