pega bix with personal edition 8.5
visit my blog: [ Ссылка ]
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.
BIX can extract data into .xml, .csv, and database schema formats.
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.
After enabling the built-in BIX ruleset to your application, BIX extractions are made available in Pega Platform.
BIX extractions may be run manually from the Extract rule or automatically through the Job Scheduler rule.
A single extraction process cannot concurrently extract from multiple databases or different database instances on the same machine.
Each extraction process can have only a single data source. You can run different extraction processes, extracting from multiple Pega Platform databases, concurrently.
Download pxBIX_08.01.01.zip file from the Pegasystems by raising a request, because its not included in your personal edition software by default.
Import the zip using standard Pega import wizard.
Enable the bix ruleset in your application rule.
In the Application rulesets section, click + Add ruleset.
Enter Pega-BIX: xx-xx-xx in the Application rulesets field where “xx” matches your version of Pega Platform.
Click Save.
Log out and log back in.
BIX is displayed as the Extract selection under SysAdmin in the Rules Explorer.
Step 2: Creating and running an Extract rule
After you enable the built-in Business Intelligence Exchange (BIX) ruleset on Pega Platform, you can create and run Extract rules to extract specific class data from your application.
In the header of Dev Studio, click Create SysAdmin Extract.
Alternatively, in the navigation pane of Dev Studio, click App. Right-click the name of the application from which you want to extract class data, and then select Create SysAdmin Extract.
In the Label field, enter a name for the Extract rule.
In the Context field, select the application, class, and ruleset from which to extract data.
Click Create and open.
On the Definition tab, specify the output format, and then select properties to extract:
Step 2: Creating and running an Extract rule
XML: Extract properties to an XML file according to top-level pages, page lists, and page groups with embedded XML tags.
Comma Separated Value (CSV): Extract properties to comma-separated values in separate text files according to top-level pages, pages lists, page groups, and value properties.
Database Schema: Extract properties directly into an existing relational database outside of the application. The extraction process forms top-level pages, page lists, page groups, and value properties from a selected class into separate tables on the database.
In the Execution History tab, view a list of concurrently running and previously run BIX extractions by clicking on each row.
To manually run a BIX extraction process, in the rule form toolbar, click Actions Run .
In the Label to use for this run field, enter a unique identifier for this BIX extraction.
For XML and CSV extracts, click Perform Extract.
