Skip to content
Lightweight Open Source Business Intelligence and reporting tool for PostgreSQL, MySQL, SQL Server, Oracle Database
Branch: master
Clone or download
Latest commit 518e9d7 May 23, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github/ISSUE_TEMPLATE Add issue templates Apr 9, 2019
.vscode Fix connections Mar 27, 2017
config Make session's secret configurable May 16, 2019
dist Add ability to make reports and dashboards public May 22, 2019
email_templates Add htmlhint and fix htmlhint errors Mar 11, 2019
language Update translations files May 9, 2019
migrations Show layer name in the list of reports May 22, 2019
public Fix filter type dropdown May 23, 2019
script Add a script to change a user's password Oct 3, 2018
server Show layer name in the list of reports May 22, 2019
shared Add a legend for elements used in custom expression May 22, 2019
test Show layer name in the list of reports May 22, 2019
views Add ability to make reports and dashboards public May 22, 2019
.editorconfig Enforce JS style with ESLint and EditorConfig Jun 6, 2018
.eslintignore Remove unused icon font linecons Mar 8, 2019
.eslintrc.js Start testing the AngularJS application Apr 19, 2019
.gitignore Remove bower.json Oct 24, 2018
.htmlhintrc Add htmlhint and fix htmlhint errors Mar 11, 2019
.mocharc.js Start testing the AngularJS application Apr 19, 2019
.stylelintrc.js Add stylelint as a dev dependency and create .stylelintrc.js Feb 26, 2019
.travis.yml Refuse to start the server if there are pending migrations Apr 10, 2019
CHANGELOG.md Add ability to make reports and dashboards public May 22, 2019
LICENSE Make license file more readable May 3, 2019
README.md Make session's secret configurable May 16, 2019
app.js Add ability to make reports and dashboards public May 22, 2019
gulpfile.js Add ability to make reports and dashboards public May 22, 2019
karma.conf.js Add ability to make reports and dashboards public May 22, 2019
migrate-mongo-config.js Fix layers integrity and remove useless properties Feb 18, 2019
package-lock.json Add ability to make reports and dashboards public May 22, 2019
package.json Add ability to make reports and dashboards public May 22, 2019
server.js Refuse to start the server if there are pending migrations Apr 10, 2019

README.md

Urungi

Lightweight Business Intelligence tool for reporting PostgreSQL, MySQL and others, see Supported databases

Supported databases

  • PostgreSQL
  • MySQL
  • MS SQL Server
  • Oracle
  • Google Big Query

Requirements

  • nodejs (>= 8.x)
  • npm
  • MongoDB (>= 3.4)
  • OpenJDK
  • g++ and make (package build-essential on Debian-based distributions)

Installation

  1. Install the requirements listed above

  2. Clone the github repository

    git clone https://github.com/biblibre/urungi.git
    cd urungi
    
  3. Download and install dependencies

    npm ci
    
  4. Run MongoDB migrations

    npx migrate-mongo up
    
  5. (Optional but recommended) Create a local config file and change the session's secret (see Configuration)

Configuration

Urungi uses config to manage its configuration files.

You can change the configuration by creating a file in config/ directory named local-{env}.js (where {env} is one of: production, development) and overriding any properties defined in config/default.js

More info at https://github.com/lorenwest/node-config/wiki/Configuration-Files

Oracle connections

If you are going to use oracle connections, first you need to install in your server the Oracle instant client and then run:

npm install oracledb

More info at https://github.com/oracle/node-oracledb

Starting up the Urungi server

  1. Launch the server

    npm start
    
  2. Point your browser to your ip/server name (eg. http://localhost:8080)

  3. Enter the credentials

    • Username: administrator
    • Password: urungi
  4. Enjoy!!!

Upgrade

To upgrade Urungi to the latest version, follow these steps:

  1. Update sources

    git pull --rebase
    
  2. Update dependencies

    npm ci
    
  3. Update database

    npx migrate-mongo up
    
  4. Restart the server

Tests

Build Status

To run the tests:

npm test

Some tests need SQL databases to connect to. To run those tests, copy config/test.js to config/local-test.js and modify the configured datasources accordingly. If database servers are not available, tests will be skipped.

License

GPL 3.0

You can’t perform that action at this time.