SpagoBI data set: use javascript to access to MongoDB data base

Question

Since data set in SpagoBI could be created using scripts, I need to connect, query my MongoDB data base using javascript (or Groovy). I need to use scripts to be able to execute aggregation on the mongoDB data, I can't use aggregation directly on my MongoDB because my data type is String

I dont know how to access my Database using scripts

Any ideas?

score 2 · Accepted Answer · answered Sep 14 '15 at 14:56

You should create a Mongo dataset. The steps to create are:

Step1: Create a Mongo datasource in the administrator console. Notes: the type must be JDBC and the value for Class input field must be "mongo" JDBC: {unit_host}:{port}/${db} CLASS: mongo

Step2: now you can create a dataset. The procedure is the same of the query datasets. The difference here is the language.. JS instead of SQL.

Take a look at the SpagoBI wiki in particolar here: http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/data_set#HQueryDataSet28Mongo29

score 0 · Answer 2 · answered Sep 08 '15 at 06:58

0

When connecting to mongoDB, you pass auth stuff in the url. Since the scripts lies on the client side, it would be hard to make the connection secure (unless you are talking about backend JavaScript). Anybody would be able to see how to connect to your DB and for instance delete all content.

I would suggest a simple api to interface the database. Then u control the access to what a user can do towards the database.

Or have I misunderstood the scenario?

answered Sep 08 '15 at 06:58

William

741
4
9

Thanks for your response, I am actually talking about a backend Javascript. Finally, I have used groovy. – sabrina2020 Sep 15 '15 at 09:44

SpagoBI data set: use javascript to access to MongoDB data base

2 Answers2