Data extraction
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 data from your Pega Platform application using the Business Intelligence Exchange (BIX) Extract rule.
- Extract rules overview
After enabling the built-in Business Intelligence Exchange (BIX) rule set on Pega Platform, you can run the BIX extraction processes from the Extract rule to extract class data from your application. Create an Extract rule to define the class data to extract from your application using the Business Intelligence Exchange (BIX) ruleform.
- Using the Job Scheduler rule to extract data with BIX
After you enable the built-in Business Intelligence Exchange (BIX) ruleset on Pega Platform and create a Extract rule, you can schedule Business Intelligence Exchange (BIX) extractions using Pega Platform Job Scheduler rule.
- Unique run identifier
When using Business Intelligence Exchange (BIX), you can provide a unique run identifier for each BIX extraction process to mark additions to both parent and child tables in the database, and parent and child CSV files. This enables you to accomplish the following actions after BIX extraction process:
- Overview of BIX extractions in Pega Cloud environments
After enabling the built-in Business Intelligence Exchange (BIX) ruleset on Pega Platform, you can extract data from your Pega Platform application with an Extract or Job Scheduler rule in your Pega Cloud environment.
- Overview of BIX extractions in on-premises environments
Pega Business Intelligence Exchange (BIX) extracts application class data from your on-premises Pega Platform environment.
- BIX logging
The PegaBIX log file contains information about Business Intelligence Exchange (BIX) extractions that can be useful to determine what caused a problem during a BIX extraction process. BIX extracts class data then writes out a batch of records, one batch at a time. These events, including any error messages, are recorded in the PegaBIX log file.
- Optimizing BIX data extraction performance
Understanding performance enhancements of the Business Intelligence Exchange (BIX) configurations will help you to maximize the throughput of BIX extractions from your applications. Refer to the following table to incorporate enhancement considerations into your BIX extraction process as needed.
Previous topic Understanding invocation errors Next topic BIX extraction overview