Create a broad view of your business by integrating Pega Platform data with data from other systems of record using Business Intelligence Exchange (BIX). BIX extracts transactional data from the Pega database into formats suitable for exporting to a reporting data warehouse, operational data store (ODS), or other downstream process. The BIX extraction process extracts data into .xml, .csv, and database schema formats.
Business Intelligence Exchange (BIX) is a ruleset that can be run manually from the ruleform, automatically using a Job Scheduler, or from the command line (on-premises only). 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. Data is extracted and exported in a format suitable for use in popular business intelligence applications, such as data warehouses. BIX is a batch processing tool that extracts data from one class at a time. You can use it to do a full extract or an incremental extract based upon when a target property changes.
- BIX extraction overview
- Extract rules overview
- Using the Job Scheduler rule to extract data with BIX
- Unique run identifier
- Overview of BIX extractions in Pega Cloud environments
- Overview of BIX extractions in on-premises environments
- BIX logging
- Optimizing BIX data extraction performance
ArticleBIX extraction overview
ArticleEnabling the BIX ruleset