Business Intelligence Exchange (BIX) is an optional add-on product consisting of a ruleset and a stand-alone Java program that can be run from a command line. BIX provides the extract functions of an ETL (extract, transform, and load) utility by using the Pega-BIX ruleset, which supports the Rule-Admin-Extract rule type.
You can also run BIX extracts manually in the Designer Studio. Data can be output as XML or Comma Separated Value (CSV) formats
Before using BIX, ensure that the BIX version you are using matches the installed Pega Platform version. Versions might not match after you update or upgrade the Pega Platform because updates and upgrades do not automatically update add-on products such as BIX. Refer to the BIX User Guide for instructions on upgrading BIX.
When BIX runs as a standalone Java program outside of the Pega Platform, the server that BIX runs on must be able to access the Pega Platform database(s) from which data will be extracted. The following diagram shows a typical deployment architecture for BIX.
An extract, also referred to as an extraction or extraction process, is a process that runs one or more Extract rules. If it runs more than one Extract rule, they are run serially.
Each Extract rule extracts data from a single class. All of the Extract rules for an extract must extract data from the same database.
An extract can be run:
Note: A single Extract rule can be run manually from the Extract rule form, however, this is typically only done in development environments with small volumes of data to test these rules.
Note: This functionality is available when you purchase and install the BIX application.