Splunk® DB Connect

JDBC Driver for MongoDB

This documentation does not apply to the most recent version of Splunk® DB Connect. For documentation on the most recent version, go to the latest release.

Configure a JDBC connection to MongoDB Standalone using Splunk JDBC Driver for MongoDB

Authentication

It supports a basic authentication method using user and password attributes passed as a property or as a part of the connection string as query parameters. It requires to provide the authSource value as the database name associated with the user's credentials.

JDBC connection string

Using this driver the JDBC connection string should start with the prefix jdbc:standalone-mongodb:// followed by the IP address / FQDN, port and database name, such as jdbc:standalone-mongodb://<host>:<port>/<database>.<collection>?authSource=<user-credentials-database>.

Note: the <collection> attribute is optional.

SSL connection

To use SSL connection specify ssl=true as part of the connection string as a query parameter.

Driver class

It supports auto loading according to JDBC 4.0, but in case there is a need for register it manually the driver class is com.splunk.dbx.mongodb.standalone.StandaloneDriver.

Queries

This driver supports find and aggregate statements similar to MongoDB Shell.

Find Method

{ <attribute>: { $gt: <value> } }: it will execute a find method for the database and collection defined in the JDBC Connection String.

In case we don't specify the collection in the JDBC Connection String, or we want overwrite it, we do it as follows: <database>.<collection>.find({ <attribute>: { $gt: <value> } }).

Note: For more information, go to db.collection.find. Please, note that we don't support projection and options yet.

Aggregate Method

[{ $match: { <attribute>: { $gt: <value> } } }, { $sort: { <attribute>: 1} }]: it will execute an aggregate method for the database and collection defined in the JDBC Connection String.

In case we don't specify the collection in the JDBC Connection String, or we want overwrite it, we do it as follows: <database>.<collection>.aggregate([{ $match: { <attribute>: { $gt: <value> } } }, { $sort: { <attribute>: 1} }]).

Note: For more information, go to db.collection.aggregate. Please, note that we don't support options yet.

Last modified on 02 October, 2024
Configure a JDBC connection to MongoDB Atlas using Splunk JDBC Driver for MongoDB   Release notes for the JDBC Driver for MongoDB

This documentation applies to the following versions of Splunk® DB Connect: 3.17.0, 3.17.1, 3.17.2, 3.18.0


Was this topic useful?







You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters