Page 1 of 1

Datastage and Mongo DB

Posted: Tue Mar 20, 2018 2:19 pm
by nibumathewbabu
Hi,
I uses Datastage 11.5v and a requirement came to connect to Mongo DB to get data from an external source system.When I checked in Palette I could not find Mongo DB stage as well.

Could some one help me to understand how to connect to Mongo DB from datastage?

Posted: Tue Mar 20, 2018 2:23 pm
by ray.wurlod
A number of vendors offer ODBC drivers for Mongo DB. Make sure you get one that runs on your platform (that is, not one that only runs on Windows). Once you've installed the driver, you can use an ODBC Connector to connect to the database.

Posted: Thu Mar 22, 2018 3:16 pm
by ray.wurlod
I found on developerWorks a presentation from the 2013 conference that described a Connector for Mongo DB.

If that's not to your liking, there is some code on developerWorks that you can plug in to the Java stage, and access Mongo DB using Java.

https://www.ibm.com/developerworks/topics/mongo