Question
Virtusa consulting services
IN
Last activity: 17 Mar 2023 7:29 EDT
activity to retrive the work table data and write it datatable
Work table, linking tables, link_attachment, link_data_attachments......14 table
Evenry table have a blob
Any records in table table changes -- > write into ReportingDB (case ID/pzInsKey , XML of the Blob)
how to achieve this step by step or detailed solution please
***Edited by Moderator Marije to change type from Pega Academy to Product***
Accepted Solution
Updated: 17 Mar 2023 7:29 EDT
NCS Pte. Ltd
SG
Hi @Niharikapa,
Can you please look into BIX solution from Pega? Details available below.
https://community.pega.com/system/files/media/pdf/pega-platform-81-bix-user-guide.pdf
Other than this there is no OOTB solution available.
You can also use declare trigger for the classes but it will have a direct impact to your application performance (unless you design to do this via batch nodes)
If you just need the xml data as a blob, you can create trigger / agents to achieve this.
Thanks.
DXC
SG
@Niharikapa 1. BIX is one option which should try to explore, as this can be used as scheduled to run to get the following as work table is the one which you need to consider
2 If you want to do it in event driven approach then you can use kafka with data flow approach.
Virtusa
IN
@gasharma are there any java functions which can convert clipboard page to xml format. Please provide syntax if you can.
Also is there DX API Method which we could use for encrypting and decrypting of blob cloumns.
Aaseya IT Services Pvt.Ltd
IN
@AjitS291089 Use @getXMLOfPage() function to get xml content of clipboard page.
ex: @getXMLOfPage(myStepPage)
DXC
SG
@AjitS291089 The current ootb DX apis which bring case/assignment details should be doing the encrypting/decrypting of the blob data in pega tables. Are you looking for custom encrypting and decrypting for your tables then currently they do not have we need to do it custom. Another alternative will be to go for db encrypt. Configure --> System -->Setting --> DB Encryption.