MongoDB is a big data architecture based on the NoSQL model that is neither relational nor SQL-based. We provide connectors that allow reports to use a MongoDB data source or a MongoDB JDBC data source. As of version 6.2.1, JasperReports Server also supports Kerberos, SSL, and x509 authentication for MongoDB data sources.

As with all big data stores, MongoDB data sources have the following limitations and usage guidelines within JasperReports Server:

Creating a MongoDB Data Source with the Native MongoDB Driver

To create a MongoDB data source with the native driver:

Follow these steps to create a MongoDB data source with the native MongoDB driver.

You have the option to use attributes in the values of data source parameters. See Attributes in Data Source Definitions.

The MongoDB URI has the form: mongodb://<hostname>:27017/<database>

To enable SSL include the argument ssl=true in the URI. For example:

mongodb://<hostname>:27017/<database>?ssl=true

To enable x509 authentication for the data source include it as well in the URI. For example:

mongodb://<hostname>:27017/<database>?ssl=true&authMechanism=MONGODB-X509

To enable Kerberos authentication for the data source include the data source and Kerberos user name in the URI. For example:

mongodb://<hostname>:27017/<database>?authMechanism=GSSAPI

The Jaspersoft MongoDB Query Language

MongoDB is designed to be accessed through API calls in an application or a command shell. As a consequence, it does not have a defined query language. In order to write queries for MongoDB data sources, we have developed a query language based on the JSON-like objects upon which MongoDB operates. JSON is the JavaScript Object Notation, a textual representation of data structures that is both human- and machine-readable.

The Jaspersoft MongoDB Query Language is a declarative language for specifying what data to retrieve from MongoDB. The connector converts this query into the appropriate API calls and uses the MongoDB Java connector to query the MongoDB instance. The following examples give an overview of the Jaspersoft MongoDB Query Language, with the equivalent SQL terms in parentheses:

The Jaspersoft MongoDB Query Language also supports advanced features of MongoDB such as map-reduce functions and aggregation that are beyond the scope of this document. For more information, see the language reference on the Community website.

Creating a MongoDB JDBC Data Source

If you want to use your MongoDB data source with an SQL query, create a MongoDB JDBC data source. The MongoDB JDBC driver can create a default normalized schema for your data or, if you prefer, you can load a schema from the repository or your server file system.

To create a MongoDB JDBC data source:

You have the option to use attributes in the values of data source parameters. See Attributes in Data Source Definitions.

EncryptionMethod=SSL;ValidateServerCertificate=false

To enable both SSL encryption and self-signed CA, enter the TrustStore and KeyStore paths and the KeyStore password. For example:

EncryptionMethod=SSL;TrustStore=<path>;KeyStore=<path>;KeyStorePassword=<password>;

The Auto Generate Schema Definition check box is checked by default. With this option selected, When you first connect to a MongoDB server, the driver automatically creates a normalized schema of the data and generates a SchemaDefinition for housing and sharing the normalized schema.

Using Kerberos Authentication with MongoDB Data Sources

The native MongoDB driver can connect to MongoDB Enterprise using Kerberos Authentication. Kerberos is a network authentication protocol that allows clients and servers on a non-secure network to use "tickets" to identify themselves.

To use Kerberos authentication, you need to set up the following:

java.security.krb5.realm=<Kerberos_realm>java.security.krb5.kdc=<KDC_server_hostname>javax.security.auth.useSubjectCredsOnly=falsejava.security.auth.login.config=<path>/jaas.conf[/code]                    

com.sun.security.jgss.krb5.initiate {   com.sun.security.auth.module.Krb5LoginModule   required     useTicketCache=true   doNotPrompt=true;};[/code]                    

Creating a Schema with the Schema Tool

To create a schema with the schema tool:

https://documentation.progress.com/output/DataDirect/jdbcmongohelp/index.html#page/mongohelp/starting-the-schema-tool.html

Uploading a Schema to the Repository

To upload a schema to the repository: