mongodbdatabase-connectionssl-certificateibm-cloudcompose-db

How can we access Bluemix hosted "Compose for MongoDB" service from "outside"?

Situation:
Have created today a new Compose for MongoDB Service instance in Bluemix
Need:
I have to access this MongoDB DIRECTLY with tools (eg. Mongo Managemant Studio Pro, mongo.exe, etc.) for bulkloading, testing, ad-hoc data fix, etc.
Problem:
I have not found any docs, samples nor a CLEAR statement that
a) gives me some confirmation that THIS is possible
b) gives me COMPLETE information (not just some technical fragments that might have worked year ago) how to do it.
Maybe I am looking to the wrong places or do not know the right people. However I am stuck on this, and before quitting Bluemix MongoDB maybe somebody has a copy/past solution or handson step by step manual. Any help welcome. Thanks!

Solution

  • Connecting to MongoDB service in Bluemix from an application is possible. For this answer I have used the application "Robo3T" and here are the steps:

    1. Access your MongoDB Service on you Bluemix account. Usually under "Cloud Foundry Services"
    2. Open section "Manage", from "Connection Settings" copy from "HTTPS" the connection address and port. In this example "sl-eu-lon-2-portal.5.dblayer.com" and "20651" enter image description here
    3. In Robo3T create a new connection with the connection address from previous step enter image description here
    4. In tab Authentication configure database name, username and password enter image description here. The credentials are found as in step 1 enter image description here
    5. From "Connection Settings" copy the SSL Certificate into a text file and save locally. enter image description here
    6. In Robo3T Add the certificate to the connection in the "SSL" tab enter image description here
    7. Test the connection and save the settings