Question
Infosys
US
Last activity: 24 Feb 2016 14:36 EST
BIX question
I am new to BIX. I know BIX is a java tool that can extract data from BLOB (pzPVStream) and write data into specified format, such as XML, CSV etc.
In our application, we have work object of class "ACME-Work", whenever a work object is saved, we use database trigger (please note, this is not PRPC Rule-Declare-Trigger) to insert the BLOB from work table into an "AuditHistory" table.
We also have a class "AuditHistory-ACME-Work", which maps to this "AuditHistory" table; even though in the pzPVStream column, it contains the BLOB data of "ACEM-Work" work object.
The question is:
How to configure BIX, to make it extract data from pzPVStream of "AuditHistory" table, and knows that data in BLOB is of class "ACEM-Work", and generate output file correctly? Is it possible out-of-box? We are using PRPC 6.2 SP2
Accepted Solution
Infosys
US
I just want to provide an update.
In the extract rule, we used "get all properties option". The apply to class of the extract rule is "AuditHistory-ACME-Work".
Class "AuditHistory-ACME-Work" maps to a table. In the table, in the pxObjClass column, we set the value to "AuditHistory-ACME-Work". In the same table, in pzPVStream, we insert the BLOB of work object "ACME-Work"
BIX runs, and get XML from the BLOB without any issue.
Apparently, BIX does not perform validation when "get all properties option" is used to generate XML.
Pegasystems Inc.
US
I assume you are using older version of BIX, start with this: https://docs-previous.pega.com/business-intelligence-exchange-bix-23-user-guide
Pegasystems
IN
Few questions
1) Is AuditHistory-ACME-Work inheriting from ACME-Work? Is it part of the same classgroup?
2) Did you try creating an extract rule on AuditHistory-ACME-Work and see if it works correctly? Please try not to extract pxObjClass for XML (unless you are using get all properties option)
Infosys
US
Hi Rajiv,
Thank you for replying. To answer your questions;
1) AuditHistory-ACME-Work does not inherit from ACME-Work currently, but we can make it so. They are not part of same classgroup. They are in separate tables.
2) We are using the get all properties option. We will try create extract rule on AuditHistory-ACME-Work, and see whether it works.
My question to you, does your comments above imply that if "get all properties option" is used, then BIX will ignore the pxObjClass and property definition in the class etc. , and it will dump whatever in the BLOB into a XML file, without validation etc? Actually, that is what we need, Can you please confirm?
Pegasystems
IN
My note was to make you aware if you select specific properties to extract and that has pxObjClass as one of the properties because the class of the extract is different from what is stored in the table, the extract will fail.
Accepted Solution
Infosys
US
I just want to provide an update.
In the extract rule, we used "get all properties option". The apply to class of the extract rule is "AuditHistory-ACME-Work".
Class "AuditHistory-ACME-Work" maps to a table. In the table, in the pxObjClass column, we set the value to "AuditHistory-ACME-Work". In the same table, in pzPVStream, we insert the BLOB of work object "ACME-Work"
BIX runs, and get XML from the BLOB without any issue.
Apparently, BIX does not perform validation when "get all properties option" is used to generate XML.