Issue

ProcessInstanceInfo table is storing all the process related information in blob format. Since the process is having some sensitive info like customerID and accountID etc we want to mask the data present on it.

Select * from ProcessInstanceInfo where id = 1 produces following:

’ z    RuleFlow
 J… Horg.drools.core.marshalling.impl.SerializablePlaceholderResolverStrategy¶¬í sr java.util.ArrayListxÒ™Ça 
I sizexp     w      t 20000sr java.lang.BooleanÍ r€Õœúî 
Z valuexp sr 7com.abc.xyz.test.ProducerRequest½cã™À5¼ L bpmWorkFlowObjectt 1Lcom/abc/xyz/test/BPMWorkFlow;L RequestXmlt Ljava/lang/String;L provisioningRequestTypeq ~ L workFlowRequestObjectt 5Lcom/abc/xyz/test/WorkFlowRequest;xpsr /com.abc.xyz.test.BPMWorkFlowiìHIb&ú L processInstanceIdq ~ L processWorkFlowIdq ~ L 
signalEventIdq ~ L versionq ~ xpt 192t HelloWorld.Subprocesst 
RESPONSEppt OPsr 3com.abc.xyz.test.WorkFlowRequest-pïÖx«Š 
L 
accountNumberq ~ L 
correlationIdq ~ L 
customerIdq ~ L deviceTechnologyq ~ L lineItemNumberq ~ L  losIdNoP1q ~ L     losIdNoP2q ~ L orderDueDateq ~ L orderIdq ~ L orderSourceq ~ L   orderTypeq ~ L requestHostq ~ L wfReqidq ~ xpz   t 1234pt    844028877t 
Ct 12345ppt 01/26/2017 12:00t 
0448856484t M2Mt 
Activationt 10.10.10.10t 699856555155sr 8com.abc.xyz.test.ProducerResponsebÍ}^ ”9 L 
exceptionInfot 3Lcom/abc/xyz/test/ExceptionInfo;L statusq ~ xpsr 1com.abc.xyz.test.ExceptionInfoÅZ—¬kw L  errorCodeq ~ L errorDeatilsq ~ L errorSourceq ~ xppppt successt 167t http://localhost:9191/producer/sendsr java.lang.Long;‹äÌ#ß 
J valuexr java.lang.Number†¬•”à‹  xp       Àt 20000q ~ xR©
RuleFlowÀ
HelloWorld.Subprocess 
(:""§
(
B
connectionTimeOut     B
isError    
B
Req    B
Resp    B
RespWorkitemId    B
Url    B
processInstanceId    B
readTimeOut    B
workflowRequest    ` j%_49E36817-AF00-4B52-A41F-D7D8B9C88D1Dj%_3A00FE55-4989-4163-A111-564F5DBE2AACj%_9C5AF4BA-0247-4018-B6AF-1E323ED304D8r)
%_3E9E2E73-B40C-48DF-9206-E847B3500DCB
r)
%_4E1316C9-1925-4DEA-A8DB-06EB9FD0B830wF
zM2M_Subprocess€

Š
/com.abc.xyz.test:HelloWorld:2.0.0-1-SNAPSHOT

Where 1234 are customer sensitive data. How to obfuscate them?