Understanding the BIRT Loader internal database
BIRT Analytics Loader configuration information is stored in dubnium.db, located in:
C:\Program Files\Actuate11SP4\BIRTAnalytics\dubnium\qloader\dubnium.db
dubnium.db is a sqlite database. To access the sqlite database, you can use SQLite Manager, an add‑in in the Firefox web browser. The main tables in dubnium.db are listed in
Table 6‑2.
Table 6‑2 BIRT Loader internal database tables
Table | Description |
PROJECTS | Load projects. |
USERS | BIRT Analytics Loader users. By default, user SYSTEM is created. |
USERS | Data sources connection properties. |
FILES | Remote data provider definitions. |
URIS | Remote data provider URIs. |
URIPARAMS | Remote data provider URI parameters. |
EXECUTIONS | BIRT Analytics Loader executions. |
EXECUTIONLOG | Execution log details. |
LOCKS | Users who locked BIRT Analytics Loader. |
BACKUP | Backup of load projects. |
SCHEDULER | Information about scheduled tasks. |
SCHEDULERLOGS | Scheduled tasks logs. |
VERSION | Database (dubnium.db) version. |
The scripts, logs, and repository generated by BIRT Analytics Loader are stored in the FastDB installation folder. By default, these folders are:
Repository
C:\Program Files\Actuate11SP4\BIRTAnalytics\dubnium\databases\
Log Files
C:\Program Files\Actuate11SP4\BIRTAnalytics\dubnium\log\
Load Project
C:\Program Files\Actuate11SP4\BIRTAnalytics\dubnium\loading-projects\
Contains load projects. Every project is stored in a different folder. The names of these folders is a sequential number, such as 1, 2, 3, and so on.
A project folder contains the following sub-folders and files:
Data
A folder where you upload and store source files with data.
Transformations
A folder where the transform files are stored. These files are generated in XML format.
Definitions
A folder where the definitions of files and column information are stored. These files are generated in XML format.
Descriptor.txt
An XML file that contains the project name and its creation date.
Control.xml
An XML file that contains the declaration of files to load.