Problem with connecting mongodb with helical insight

Database Support
#1

Hi,
I want to create connection between HI and mongodb. i created data source as mentioned in database-support/connect-helical-insight-mongodb/ .
but still i am not able to get data from mongo db and getting exception _"ERROR GenericService:108 - An exception has taken place. The stackTrace is _
com.helical.efw.exceptions.EfwServiceException: Couldn’t get database metadata.".And I have 1 more doubt regarding query i have written in mongoDB datasource
sql: ‘select cast(_MAP[‘severity’] AS VARCHAR(30)) AS “severity”,\n cast(_MAP[“user_id”] AS integer) AS user_id from “report”.“tickets”’

if i remove sql querry part it works but not able to see data from mongodb.
PFA mongo-model.json and log file

https://drive.google.com/open?id=0B7PH2--pRsBqbllQMk9STlFsUmc
Can Any one give suggestion on this?

#2

HI Punkit,
Looking in to the log file you have shared, there is issue with the mongo-model.json file you have created. Where you have wrongly mapped table name specified as “report” but in mongo sql you have written having table name as report.ticket.

Thanks,
Helical Insight Team

#3

Hi,Thanks for Reply and Sorry I had shared wrong file correct file is shared now and let me know where i am wrong and please correct me.

some times it gives stackoverflow exception,and sqlparser Exception…

#4

Hi, Pulkit
Thanks for sharing the updated file, Looking at the mongo-model.json which you have provided, it has same value (report) to name parameter in both the schemas. Instead provide different schema names.

I have attached updated mongo-model.json file, use this mongo-model.json file and create the metadata using workflow.

mongo-model.zip (480 Bytes)

You can refer below blog for creating metadata using workflow.
http://www.helicalinsight.com/technical-guide/create-metadata-workflow/

Regards,
Helical Insight Team

#5

Hi.
With Helical Insight version 3.0 you can connect and use MongoDB directly from the frontend. Please refer to the below blogs to understand the same.

Connecting To MongoDB Using Apache Drill : http://www.helicalinsight.com/technical-guide/connecting-mongodb-using-apache-drill/
Connecting To MongoDB Via Dremio : http://www.helicalinsight.com/technical-guide/connecting-mongodb-via-dremio/