Understanding BIX command-line extractions
After creating a Business Intelligence Exchange (BIX) Extract rule in Pega Platform, you can directly call the ExtractImpl Java class from the Pega Platform distribution directories to run an BIX extraction process from the command line. Running a BIX extraction process from the command line allows for running an extraction process without requiring using Pega Platform to run the process.
During command-line BIX extraction, a stand-alone instance of the PegaEngine is started without requiring opening Pega Platform to run the extract process without activating the Extract rule. The database user that runs the command-line BIX extraction must have all privileges that are needed to start the engine.
You can add other optional parameters that filter the data by any property, including date ranges, and specify other processing options. For more information, see Setting optional command-line BIX parameters.
Running an Extract rule from the command line works in the following way:
- BIX accesses the Pega Platform (source) database by using the information that is defined in the BIX
prbootstrap.propertiesfile starts up the PegaEngine with the Pega Platform source database details, and then gets the
- With the information that is configured in the Java method,
bix.xmlfile, and specified in the Extract rule, BIX extracts the specified data from the Pega Platform source database.
- The extracted data is output in the format that is specified in the Extract rule.
- Configuring the source database for BIX command-line extractions
- Configuring the target database for BIX command-line extractions
- Configuring optional prconfig.xml settings
- Configuring BIX logs for command-line extractions
- Viewing and configuring BIX logs
- Enabling password encryption for BIX command-line extractions
- Running a BIX command-line extraction
- Running a BIX command-line extraction using ANT build files