Before extracting BIX data to the target database, you must create a schema to match the extracted data. You can use BIX to generate an SQL file that creates the appropriate schema.
-
Call the ExtractImpl class with the parameter
-X
<Path><FileName>
to generate a DDL for the target database.
-
Run the SQL script against the target database using your database tools.
Note:
To use the -X parameter, the output format of the
Rule-Admin-Extract
rule that you specify must be Database schema.
The user must also have Write access to the directory. If the output format is XML or
CSV, an error message displays:
BIX cannot generate a database schema when the
selected output type is set to CSV or XML.
Note: For Pega Cloud applications, BIX is an add-on service
that Pega configures if you choose it as part of your subscription. For on-premises
applications, BIX is available when you purchase and install the BIX application.