activity to retrive the work table data and write it datatable

General
, , , , , ,
1

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

2

Hi @Niharikapa,

Can you please look into BIX solution from Pega? Details available below.

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.

3

@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.

4

@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.

5

@AjitS291089 Use @getXMLOfPage() function to get xml content of clipboard page.

ex: @getXMLOfPage(myStepPage)

6

@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.