saikuanalytics #3

Supports: trusty


Web based OLAP tool which allows users to query data stored in JDBC compliant databases and NOSQL clusters.


Saiku Analytics Community Edition

Saiku allows business users to explore complex data sources, using a familiar drag and drop interface and easy to understand business terminology, all within a browser. Select the data you are interested in, look at it from different perspectives, drill into the detail. Once you have your answer, save your results, share them, export them to Excel or PDF, all straight from the browser.

Saiku connects to a wide range of data sources allowing you to explore the data in real-time directly from the source.

Some examples are:

  • Microsoft SQL Server
  • Microsoft Analysis Services
  • Oracle Database
  • Oracle Essbase
  • MongoDB
  • MySQL
  • PostgreSQL
  • Cloudera Impala
  • Actian Vectorwise
  • Amazon Redshift
  • Teradata
  • Vertica
  • Exasol

Extend the functionality of your application with self service analytics. Allow your users to explore their data and answer their own questions. Customise Saiku so it fits seamlessly into your application or website.

Saiku is designed to be as easy to deploy as it is to use. Saiku is 100% thin client. It works on any modern browser on PC, Mac and Tablet. Saiku can easily be integrated into existing security frameworks and is optimised to run on commodity server hardware even with large user communities. Intelligent caching reduces the performance impact on the underlying database and minimises network traffic.


Step by step instructions on using the charm:

juju deploy tomcat
juju deploy saikuanalytics
juju add-relation saikuanalytics tomcat
juju expose tomcat

You can then browse to http://ip-address:8080 to configure the service.

There are a number of actions available:

  • addschema

To programatically add a schema to your running Saiku server you can run: juju action do saiku/0 addschema name=my_schemaname content="$(cat /path/to/my/schema.xml)"

This will upload your schema to the server and deploy it in the repository.

  • adddatasource

To programatically add a data source to your running Saiku server you can run:

This will upload a new data source to your running Saiku server and (optionally) refresh the schema cache.


Default login is admin/admin, this should be changed within the administration console once you have logged in.

Contact Information


(boolean) A short description of the configuration option
(int) A short description of the configuration option
(string) A short description of the configuration option
Default Value