Accessing mongoDB Atlas from iHub

Clement Wong
Clement Wong E mod
edited February 11, 2022 in Analytics #1
[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]<br />
<br />
[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]<br />
<br />
Steps to replace:
    <br />
  1. [color=rgb(0,0,0)]Exit out of Analytics Designer[/color]<br />
  2. [color=rgb(0,0,0)]Navigate to [/color]C:\OpenText\AnalyticsDesigner\plugins (default location).<br />
  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.<br />
  4. [color=rgb(0,0,0)]Copy the [/color]mongo-java-driver-3.5.0.jar into plugins.<br />
  5. [color=rgb(0,0,0)]Restart Analytics Designer[/color]<br />
<br />
Connecting to mongoDB Atlas:<br />
<br />
1. Get the mongoDB URI from mongoDB Altas web front end. It will look similar to:
<br />
<br />
mongodb://jrice80:password@cluster1-shard-00-00-test.mongodb.net: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<br />
<br />
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.<br />
<br />
3. Test Connection to make sure you can connect to your mongoDB Atlas instance<br />
<br />
4. Create a new Data Set and select your Collection.<br />
<br />
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.
Warning No formatter is installed for the format ipb