What connection type should be used for mongodb to SPLUNK db connect

[vrmandadi]

Currently we have Splunk db connect app 3.1.4 version and I want to connect to MongoDB .In the DB CONNECT under the connections what connection type should be selected for MongoDB.I dont see anything for MongoDB.What would we the work around to connect to it.

Thanks in Advance

[umlawren]

The JAR file should be in the directory $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers

You should modify the file db_connection_types.conf file in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/default to have the details posted by vrmandadi above:

[mongo]
displayName = MongoDB
jdbcDriverClass = mongodb.jdbc.MongoDriver
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:mongo://<host>:<port>/<database>

Full installation instructions for MongoDB JDBC driver with Splunk DBConnect version 3 are available.

[richgalloway]

Have you installed a JDBC driver for MongoDB on your DB Connect server?

[vrmandadi]

No I have not .So what is the correct JDBC driver that needs to be installed? .This should be under app/drivers folder right?

[nickhills]

https://answers.splunk.com/answers/471879/is-it-possible-to-use-splunk-db-connect-to-search.html

[vrmandadi]

Hello @nickhillscpl thank you for your reply .I did download the jar file but where should the stanza be placed /in which location it should be placed

[mongo2]
displayName = MongoDB2
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:mongodb:// : /
jdbcDriverClass = mongodb.jdbc.MongoDriver
port = 27017