Question
2
Replies
547
Views
Navistar INC
Posted: June 28, 2017
Last activity: July 3, 2017
Closed
How to obtain XSD while using BIX with "Get all properties" option in XML output format
Hi,
In BIX, while extracting the data in XML format using "Get all properties" option, I am unable to see an option to generate XSD file. How can I obtain the XSD for a class while extracting all the properties in XML format using BIX...?
We are using Pega 7.1.9.
Thanks.
Posted: 3 years ago
Hi Ivan,
Thanks for your comment..!
Unfortunately, generating XSD from XML wouldn't work for our requirement, as we will not be able to extract all the data elements through a single work object.
Seems to be a crude way but, by unchecking the Get all properties option, I had to map each and every field in the Class to obtain the schema with all the properties in its hierarchy.
This is to be consumed by our Hadoop Team for BI reporting.
Hi Umakanth!
Unfortunately this is not technically possible. PRPC stores its objects in serialized form in pzPVStream BLOB column. Pega BIX extracts this representation and it doesn't have any predefined schema by design. That actually means that two objects can have entirely different fields (assuming they're not exposed) while being stored in the same database table.
If you still need some kind of XSD schema for BIX unload, I'd recommend generating XML file for a representative entity of this type first and generate XSD from XML. This can be done using Altova XMLSpy for example. I believe there are other tools capable of this task as well.
Overall I think it's a bad idea to reverse this logic and generate XSD in this manner. It will be actually need to be tailored manually as you won't be able to determine exact types and relations for field of your entity reprentated in XML.