Part 1 of the series is about using OData to connect Lumira and MongoDB. This part shows another method to consume MongoDB Collections into SAP Lumira.
JDBC is Java Database Connection. Its open connection format is supported by Java to connect to Database and external sources of data. MongoDB provides JDBC drivers to use and connect to it from any external application like Lumira.
Downloading the Driver.
The JDBC driver for MongoDB can be downloaded from http://www.unityjdbc.com/. The driver comes with set of JAR files which can be used as driver.
Installing the driver in SAP Lumira
SAP Lumira has the source of JDBC Driver. The driver should be installed into SAP Lumira by going into File->Preferences->SQL Drivers
Choose Generic JDBC datasource and click on Install Drivers button and select both mongodb_unityjdbc.jar and mongo-java-driver-2.12.2
Restart Lumira for the driver to install. Now JDBC connection can be created to MongoDB by selecting the General JDBC datasource and providing connecting information to MongoDB
Username and Password is needed to access the data through JDBC, so a normal user with role to the particular db should be created in MongoDB. The JDBC URL should be the url to access the instance of MongoDB running.
JDBC URL: jdbc:mongo://<hostname>:<port>/<db>
JDBC Class: mongodb.jdbc.MongoDriver
The collection is listed and corresponding documents in the collection are displayed as fields. We can now consume this data and build storyboards.
JDBC is a good option to connect MongoDB with SAP Lumira. On the later release of Lumira, SAP promises to provide direct connectivity options with MongoDB as partners.
Orginally posted at Connecting SAP Lumira with MongoDB &#8211; Part 2 – Visual BI