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
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.
2.How to add Oracle DB datasource to Saiku in the community edition.
3.How to add MSSQL datasource to Saiku in the community edition.
4.How to add MYSQL datasource to Saiku in the community edition.
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.
Different JDBC drivers for above database are as follow.
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.