DWWiki is a lightweight wiki-like system for database reporting.
It started as a set of utilities for embedding SQL queries into markdown-formatted documents for creating documentation and reports for my Data Warehousing projects.
It has grown into a SQL-reporting server that is simple, extendable and easy to use for end users of Data Warehouses.
Most of desired features that were (are) lacking in commercial BI and reporting solutions were included in dwwiki. I designed it for myself, my colleagues, and my poor users, who were mostly tied to visual drag-and-drop bloated BI engines.
-
Write a wiki-page in markdown, include SQL queries into the text.
-
Display results of a query as table, graph, chart, map... etc.
-
Link query results together to drill down or drill across.
-
Download query results as csv or xls.
-
Download reports as printable html or as PDF.
-
Connect to several databases.
-
Fine-grained control of user access to databases, tables and reports.
-
Edit reports in your favourite text editor or through simple web text editor.
-
Track report versions with commonly used tools - git, svn, whatever you like.
-
Avoid abstraction layers between the user and the database.
-
Friendly to non-programmers, yet open for advanced users.
-
Keep away from bloated hyper-interactive interface. Keep it simple.
Written in python.
DWWiki engine is built on top of CherryPy.
Charts are rendered using Matplotlib
PDF rendering is done with PDFKit
-
Install Python 2.6 to 2.7.
-
Download dwwiki engine.
-
Run
python dwwikiserver.py
from installation directory. Check stdout if there are any errors or warnings. Ignore warnings. -
Open
http://localhost:8087
in a browser. Read the docs.
See http://dwworks.ru/ru/dwwiki
It's only in Russian at the moment, but not for long.