https://docs.mongodb.com/bi-connector/master/
The MongoDB Connector for Business Intelligence (BI) allows users to create queries with SQL and visualize, graph, and report on their MongoDB Enterprise data. The Connector makes MongoDB appear as a MySQL data source.
TIBCO Jaspersoft® Studio and JasperReports® Server can use the BI Connector to do SQL queries from reports. JasperReports Server domains (metadata layer supporting ad hoc) will also work with the BI Connector.
To connect to the BI Connector via JDBC in JasperReports Server and Jaspersoft Studio, we will need to create a JDBC data source/data adapter with the mongosql-auth and mysql-connector-java 5.1.X JARs outlined here:
https://docs.mongodb.com/bi-connector/master/reference/auth-plugin-jdbc/
And use this form of the JDBC URL:
jdbc:mysql://<BI Connector server>:<port>?useSSL=false&authenticationPlugins=org.mongodb.mongosql.auth.plugin.MongoSqlAuthenticationPlugin
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now