saiku basic sql #2

2 machines, 2 units

Saiku Enterprise Analytics with MySQL

Are you tired of hard to tune, over priced, over complicated analytics platforms? Saiku Analytics Enterprise Edition provides a flexible experience that allows you to dig deeper into your data without writing complex SQL queries.

Combining Saiku Analytics with the scalable power of MySQL, we give our users the ability to query relational data with the click of a mouse.

Saiku powered by MySQL are a perfect combination for smaller datasets where the users need quick access to the answers they know are locked away within the data.

Find the data points you need efficently and intuitively with our web based, drag and drop interface. Leverage the power of Juju to connect to different data sources with zero configuration, enabling you to discover data, faster.

Analyse and explore data.

MySQL provides a familiar database with an array of existing tooling, making importing data into MySQL a painless experience. Once the data is imported, Saiku can discover the data stuructures within the database and provide automatic schema generation for users. To improve performance users can also make use of MySQL replciation and scaling to speed up slow running queries.

User driven dashboarding.

Give users the ability to create their own dashboards from Saiku reports. Using the Saiku Dashboard Designer users can build and deploy their own flexible, parameter driven dashboards, without writing a single line of code. Filter reports in unison with combined filters, show the data your users want with the minimum of fuss.

Usage

Give Saiku to everyone.

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 and Mac. 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.
This bundle is a basic Saiku Enterprise Analytics deployment with MySQL. It is designed to allow easy deployment of a scalable OLAP interface driven by a MySQL database . The deployment of this bundle will deploy the following units:

  • 1 Saiku Analytics Enterprise Edition
  • 1 MySQL
  • 1 HA Proxy

Deployment

There are 2 easy ways to deploy this bundle.

GUI

Command Line

Deploy this bundle using juju:

juju deploy ~spiculecharms/saiku-basic-sql
juju expose saikuanalytics-enterprise

Interacting with the bundle

To make use of Saiku you need data. By default the MySQL database is empty, add some data to it!

..........

Bundle configuration