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
