Understanding the BIRT Analytics Loader internal database
BIRT Analytics Loader configuration information is stored in dubnium.db, located in:
C:\Program Files\BIRTAnalytics\data\FastDB\Loader
dubnium.db is a SQLite database. To view and edit the sqlite database, use a SQLite editor such as one of the following:
SQLite Manager, an add‑in for the Firefox web browser from the following URL
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
DB Browser for SQLite from the following URL
http://sqlitebrowser.org/
The tables in dubnium.db are listed in
Table 6‑2.
Table 6‑2 BIRT Analytics Loader internal database tables
Table | Description |
BACKUP | Backup of load projects. |
DATASOURCE | Data sources connection properties. |
EXECUTIONLOG | Execution log details. |
EXECUTIONS | BIRT Analytics Loader executions. |
LANGUAGES | Language details |
LOCKS | Users who locked BIRT Analytics Loader. |
PROJECTS | Load projects. |
SCHEDULER | Information about scheduled tasks. |
SCHEDULERLOG | Scheduled tasks logs. |
SHAREDDATASOURCES | Information on shared database connections |
SHAREDPROJECTS | Backup of load projects. |
URIPARAMS | Remote data provider URI parameters. |
URIS | Remote data provider URIs. |
USERS | BIRT Analytics Loader users. By default, user Administrator is created. |
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.