Preparing a target database

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.

  1. Call the ExtractImpl class with the parameter -X <Path><FileName> to generate a DDL for the target database.
  2. 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: This functionality is available when you purchase and install the BIX application.