Ask the Expert - BIX Output Formats with Yesovardhan Kambhampaty
Meet Yesovardhan: Yesovardhan joined Pega last year, and has worked on the Data Engine portion of the platform. Along with BIX, he also works on Search and Report Defintions.
Message from Yesovardhan: Hello! I’d love to answer your questions on BIX, especially how it's target formats work. BIX is a very important part of your toolset, and I’d be happy to help you get a better understanding of it.
While naming the extract files, we can use %d or %t to include extract date/date time in the file name. These regular expressions format date in "YYMMDD" and "YYMMDDHHmmssSSS" respectively. Is there a way we can format it in a customized way like "YY-MM-DD"
We use RichTextEditor in our application hence the data in this property contains html code like <p> etc. When we see the bix extract, this property has some junk values in place of that html code. How can we get rid of this junk values in the bix extract?
My question is towards the restrictions in the Cloud environment. In Cloud 1.1 architecture with PRPC V7.2.1/BIX 7.1, we are able to do database-to-database extraction, but this isn't supported in the Cloud 2.1 architecture. Please could you explain the reason behind this limitation, and will it be supported in the future BIX upgrade?
My Question is regarding the enhancements to BIX product.
I have worked on multiple large scale projects in BIX with DB and XML as output formats. Somehow I feel that there is a scope of improvement to the product. Lets say for database, adding a primary key while generating the schema DDL which makes it easy for the downstream systems to consume the data.
I also want to know what kind of enhancements can we expect from pega to BIX product? Are you planning to roll off any new features/improve the product?