Question
Cognizant
US
Last activity: 7 Nov 2016 7:42 EST
Is it possible to Extract data using BIX from a table without Blob (pzpvstream) column.
Is it possible to Extract data using BIX from a database table without Blob (pzpvstream) column.
I have read in discussion forum that it is possible. Could you please let us know whether it is possible or not ?
Forum: https://pdn.pega.com/forums/prpc/pegarules-database/bix-extraction-from-table-with-no-pzpvstream
Our application was developed in Pega 7.1.6.
GovCIO
US
Hi Rajiv/KAtheresan,
I have a quick question after reading this post. My question is like we know BIX is mainly used to extract the data from BLOB. For that only, we buy this product but when I saw this post then I am little confused on the purpose of BIX. I think we can write our own logic to extract the data from a non-BLOB column table without using BIX tool, right? With a curiosity I am asking this question. Please don't think otherwise.
Thanks,
Ravi Kumar Pisupati.
Pegasystems
IN
Hi Ravi,
There are two reasons for this
1) Customers wanted a uniform mechanism to extract data for both BLOB and non-BLOB based tables
2) For customers on the Pega cloud, extraction of data was difficult because of security and other constraints
-Rajiv
GovCIO
US
Thanks Rajiv for the clarification. Now I see the importance of BIX especially for #2.
Thanks,
Ravi Kumar Pisupati.
JP Morgan Chase
US
Does that still mean the class have to be an internal class with pxCommitDateTime , pzInsKey, pxInsName columsn right?
Can we use BIX to extract the external class tables ?
Pegasystems
IN
You can extract data from external tables. But if you are using "Use last update date time as start" option, then pxCommitDateTime column is used to restricts the records that need to be extracted. With 7.2, we have now introduced a new symbolic called "Last Extraction Time" which can be used in the filter conditions of the extract rule instead of the checkbox. This can be applied to any date time property.
Pegasystems
IN
This is not supported. Every version of Pega platform has its own BIX version packaged in the additional products folder of Pega platform distribution image.