This post includes, how to configure or add new datasource configuration to Saiku community edition.Datasource is a name given to the connection setup to a database from a server.The most annoying part in Saiku Datasource configuration is writing the Datasource definitions for cubes.

This post help, How to add any Datasource to Saiku datasource definitions.Saiku connects to a wide range of data sources allowing you to explore the data in real-time directly from the source.

you can add more than one data source at a time in Saiku datasource as per your requirements.some of data source which is supported by Saiku are listed below.

1.Microsoft SQL Server
2.Microsoft Analysis Services
3.Oracle Database
4.Oracle Essbase
5.MongoDB
6.MySQL
7.PostgreSQL
8.Cloudera Impala
9.Actian Vectorwise
10.Amazon Redshift
11.Teradata
12.Vertica

Add new datasource configuration to Saiku to some of the frequently used databases is shown below.

1.How to add PostgreSQL DB datasource to Saiku in the community edition.

type=OLAP
name=dsname
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:postgresql://192.212.12.132:5432/databasename;
Catalog=../webapps/saiku/Example/Demo.xml;;
JdbcDrivers=org.postgresql.Driver;
username=user
password=pass

2.How to add Oracle DB datasource to Saiku in the community edition.

type=OLAP
name=dsname
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:oracle:thin:@192.132.11.124:1521:XE;
Catalog=../webapps/saiku/Example/Demo.xml;
JdbcDrivers=oracle.jdbc.driver.OracleDriver;
username=user
password=pass

3.How to add MSSQL datasource to Saiku in the community edition.

type=OLAP 
name=dsname 
driver=mondrian.olap4j.MondrianOlap4jDriver 
location=jdbc:mondrian:Jdbc=jdbc:jtds:sqlserver://localhost:1433/databasename;
Catalog=../webapps/saiku/Example/Demo.xml;
JdbcDrivers=net.sourceforge.jtds.jdbc.Driver;
username=user 
password=pass

4.How to add MYSQL datasource to Saiku in the community edition.

type=OLAP
name=dsname
driver=mondrian.olap4j.MondrianOlap4jDriver-
location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost:3306/databasename;
Catalog=../webapps/saiku/Example/Demo.xml;
JdbcDrivers=com.mysql.jdbc.Driver;
username=user
password=pass

type=OLAP -Specify that is an OLAP engine.
name= You can specify any name as per your choice for your datasource.
driver= Specify the Mondrian driver.
location=This property includes several parts and all are separated by semicolons.

jdbc:mondrian:Jdbc=jdbc:mysql://localhost:3306/databasename is a JDBC convention for a MySQL database.Similarly, you can be used different JDBC convention for another database also. Here the host is localhost or any remote system and database name is your name of a database to which you want to connect.

Catalog=Catalog defines a path of Mondrian file i.e XML file.this file is present in the web-app folder of tomcat.

username and password=-username and password combination are different as per database.

Default port number of the different database are as follow.

• PostgreSQL-5432.
• Oracle-1521.
• MSSQL-1433.
• MYSQL-3306.

Different JDBC drivers for above database are as follow.

• PostgreSQL-com.mysql.jdbc.Driver.
• Oracle-net.sourceforge.jtds.jdbc.Driver
• MSSQL-oracle.jdbc.driver.OracleDriver
• MYSQL-org.postgresql.Driver

This is the brief introduction of how to configure or add new datasource configuration to Saiku community edition.For continuing learning of Saiku analytics click here.