3. Installation

3.1. Directory structure




Top level application directory. Application configuration files and further source directories can be found here.


Source directory with the core application


User configuration directory for filters, projections and views.




Explorer database definitions.


Test database for use in unit tests only.


Cache for Python 2 virtual environment


Cache for webserver

The BI Explorer is a python 2 application that was built to be run from a virtual environment. A virtual environment or virtualenv is a folder that contains all the necessary executables to use the packages that a python project would need.

3.2. Software installation

  • Ensure that the bootstrap requirements are met:

    • python >=2.6 <3 installed

    • python-virtualenv installed

    • postgresql-dev installed; required to compile python pgsql support in the next installation step.

    • supervisord installed

    • postgresql database either installed locally, or reachable via tcp.

Unpack source distribution, and prepare the virtual environment:

$ virtualenv --no-site-packages pyenv

Activate the virtual environment, and proceed to populate it with the python component libraries that explorer needs:

$ source pyenv/bin/activate
$ cd Explorer; python setup.py install

3.3. Database configuration

Explorer requires a PostgreSQL database with a user base table for authentication. A user-specific database schema is used for all explorer queries for that user, and also for storing user specific view configuration.

Example database configuration:

$ createdb dwh
$ psql -d dwh -c "CREATE EXTENSION tablefunc"
$ psql -d dwh -f db/user_table.sql
$ psql -d dwh -c "CREATE SCHEMA explore"
$ Explorer/useradmin.py -c Explorer/development.ini -a user explore password
$ <fill database dwh schema explore with explorer data>