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
Can Any one give suggestion on this?