Understanding the BIRT Loader internal database
BIRT Analytics Loader configuration information is stored in dubnium.db, located in:
C:\Program Files\BIRTAnalytics\data\FastDB\databases
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.
BACKUP
Backup of load projects.
USERS
BIRT Analytics Loader users. By default, user Administrator is created.
DATASOURCE
Data sources connection properties.
URIS
Remote data provider URIs.
URIPARAMS
Remote data provider URI parameters.
EXECUTIONS
BIRT Analytics Loader executions.
EXECUTIONLOG
Execution log details.
LANGUAGES
Language details
LOCKS
Users who locked BIRT Analytics Loader.
SHAREDPROJECTS
Backup of load projects.
SHAREDDATASOURCES
Information on shared database connections
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\BIRTAnalytics\data\FastDB\databases\
*Log Files
C:\Program Files\BIRTAnalytics\log\
*Load Project
C:\Program Files\BIRTAnalytics\data\FastDB\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.
*Postloading.xml
An XML file that contains the post loading parameters.