connection Oracle to Mongo DB

[Roshan]

Hello Erman,

I am making a DB connection from Oracle to Mongo DB

SOURCE SERVER DETAILS
==========================

ORACLE DB SERVER :10.210.228.8



TARGET SERVER DETAILS
====================

MongoDB     10.210.227.37  PORT : 27018    

Have you used Mongo database?

I am referring to doc below
http://www.easysoft.com/products/data_access/odbc-mongodb-driver/getting-started.html#oracle

I am having an issue specifying HS_FDS_CONNECT_INFO =<odbc>

Can you please help me in creating the odbc?
mongo1.PNG

The SID_NAME should I put anything by default?

Thanks,
Roshan

[Roshan]

Should I install the ODBC driver on Oracle server?
mongodb-1.pdf

[ErmanArslansOracleBlog]

The instructions are very clear.
Follow the document named http://www.easysoft.com/products/data_access/odbc-mongodb-driver/getting-started.html, it seems okay.
You will provide a SID for your mongodb, as documented in steps 4 and 5.
That sid will be for your listener.ora.
It can be any sid. You wll decide.
You are doing a DG4ODBC(DAtabaes Gateway For ODBC) based connecction there.
DG4ODBC is a new program that replaces hsodbc, which was used in earlier Oracle Database releases.

You may take a look at my previous blog post. It is about Oracle to Sqlserver , but you will get the idea and you will understand what is being done.

[ErmanArslansOracleBlog]

As for your second question.
Yes, you will need a driver for this to work.

DG4ODBC is not the only thing required for this operation, you need the driver as well.
Anwyays, the documentation that you follow is okay, keep going.