Pentaho CDE Dashboard using MongoDb (No Sql database)

Hey Guys, 

Here I would like to explain how to use mongodb as data source for creating interactive visualization dashboard using c-tools.

There is no direct way to use Mongo DB in CDE dashboard one and only one and easy approach will use ‘Kettle Query’ option in the Pentaho code to get the required result set for visualization.

Let's assume you have a collection called ‘Test’.

ETL Design:

Below mention screen shot is the ETL design that i’m using to get my required result set.

Creating Dashboard:

Steps :

 

Prepare the layout as per your requirement.

Used the dashboard component as your requirement .Here I’m using pie chart for creating the dashboard.

In Data sources section take “KETTLE Queries”. (Upload the ktr file to your dashboard folder using the Pentaho User Console).

In “Kettle Tran formation file” property locates the uploaded ktr file. (for eg: sample. ktr).

Give the step name which is giving the required result (for example: Sample).

Provide the required data source name under pie chart .

Save the dashboard and Preview it you will see the required output.

OutPut:

Cheers !!! Have Fun

If you have any question you can ask me or else you can drop me email :
 

Sumit Bansal

BI Developer