Setting up an external database ready for export

Before exporting Business Intelligence data from Powerproject, you must set up the external database to which the information is to be exported.

You should create the database using a suitable database management tool:

For Microsoft SQL Server® databases, use SQL Server Management Studio.
For Oracle® databases, use Oracle SQL Developer or SQL*Plus®.
For SQLite® databases, use one of the many SQLite database creation tools that are freely-available.

Once you have created a database, you need to use the database's standard tools to apply the appropriate SQL script to the database, to create the tables within the database. The Business Intelligence Model Compiler application creates the following *.sql files when you compile a raw Business Intelligence export model, which you can use to create the appropriate tables within a relational database:

<export model name>.sqlserver.sql - apply this script to Microsoft SQL Server databases.
<export model name>.oracle.sql - apply this script to Oracle databases.
<export model name>.sqlite.sql - apply this script to SQLite databases.

For example, if you were to compile a Business Intelligence export model called Partial export.model, the following *.sql files would result:

Partial export.sqlserver.sql
Partial export.oracle.sql
Partial export.sqlite.sql

The *.sql files should be located in one of the following folders:

C:\ProgramData\Powerproject\BIETL\.
Your own \BIETL\ user folder.

After applying the appropriate SQL script to the database, the following groups of tables will exist in the database:

The data tables that are defined in the Business Intelligence export model.
Three control tables, as detailed in the following table.

Table name	Description
BIFIELD	This table defines the means of generating column values.
BITABLE	This table specifies the tables that are to be generated.
CONTROLINFO	This table stores the updating run numbers and dates.

Once you have applied the appropriate SQL script to your database, you are able to export Business Intelligence data to the database using the Business Intelligence Controller.