Accessing mongoDB Atlas from iHub

edited September 2017 in DevShare Downloads
[color=rgb(0,0,0)]iHub 16.2 ships with mongoDB Java client 3.2.2, which is not compatible with mongoDB 3.4, the current version of mongoDB Atlas.[/color]



[color=rgb(0,0,0)]You can replace the library in (Eclipse) plugins, org.eclipse.orbit.mongodb_3.2.2.v20170222-2110.jar with a later one such as the 3.5 version (https://oss.sonatype.org/content/repositories/releases/org/mongodb/mongo-java-driver/3.5.0/) -- mongo-java-driver-3.5.0.jar.[/color]



Steps to replace:
  1. [color=rgb(0,0,0)]Exit out of Analytics Designer[/color]
  2. [color=rgb(0,0,0)]Navigate to [/color]C:\OpenText\AnalyticsDesigner\plugins (default location).
  3. [color=rgb(0,0,0)]Rename [/color]org.eclipse.orbit.mongodb_3.2.2.v20170222-2110.jar to another extension like .****, OR move out of directory completely.
  4. [color=rgb(0,0,0)]Copy the [/color]mongo-java-driver-3.5.0.jar into plugins.
  5. [color=rgb(0,0,0)]Restart Analytics Designer[/color]


Connecting to mongoDB Atlas:



1. Get the mongoDB URI from mongoDB Altas web front end. It will look similar to:



mongodb://jrice80:[email protected]:27017,cluster1-shard-00-01-test.mongodb.net:27017,cluster1-shard-00-02-test.mongodb.net:27017/guidebook?ssl=true&replicaSet=Cluster1-shard-0&authSource=admin



2. Create a new mongoDB Data Source, and paste in the URI from Step 1 into the Mongo Database URI text box. See Screenshot #1.



3. Test Connection to make sure you can connect to your mongoDB Atlas instance



4. Create a new Data Set and select your Collection.



5. Select the Available Fields and Preview Results to verify that you are able to get data from your collection. See Screenshots #2 and #3.

Clement Wong
Principal Analytics Architect

OpenText Corporation
http://www.actuate.com | http://www.opentext.com

Sign In or Register to comment.