The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

Accessing mongoDB Atlas from iHub

Clement WongClement Wong EM mod
edited September 20, 2017 in DevShare
[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:[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<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.

Clement Wong
Principal Analytics Architect

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

Sign In or Register to comment.