Wednesday, July 1, 2015

CONNECTING MONGODB to OBIEE 11g




MongoDB Installation Steps

  1. Double-click the appropriate installation setup
C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 1.PNG

  1. Click Next
C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 2.PNG
  1. Click next and choose Typical

C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 3.PNG

  1. Now click Install
C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 4.PNG


  1. Now setup will start Installing the db
C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 5.PNG

  1. Click Finish to complete the Installation.

C:\Users\SSS2015048\Desktop\Mogadb Intallation\Mogadb Intallation\step 6.PNG


  1. Now go to the Mongodb Installed path, located in your local drive

C:\Program Files\MongoDB\Server\3.0\bin

  1. Now create a folder and name is as --->data in (C:\) drive


  1. Now in that data folder create a another folder and name it as db

  1. now go to cmd ---->Run as Administrator



  1. Now type mongod.exe


  1. After running that command we can notice that port number, Which means Mongodb Server is working


  1. now go to cmd ---->Run as Administrator
cd  C:\Program Files\MongoDB\Server\3.0\bin

  1. Now type mongo.exe



  1. Now we need to install the simba odbc driver for mongodb



Installation Steps for Simba ODBC Driver


  1. Double-click the appropriate file. The Simba MongoDB ODBC Driver Setup window opens.  

  1. Click Next. The End-User License Agreement page is displayed.


  1. Select the "I accept the terms in the License Agreement" checkbox and then, click Next.

  1. Click Next. The Ready to install Simba MongoDB ODBC Driver page is displayed.
  2. Click Install.



  1. Click Finish.
The Simba MongoDB ODBC Driver installation is complete. The next step is to create a Data

Create a Data Source Name (DSN)


  1. Now go to Control panel --> Administrative Tool  --> Datasource (ODBC)
  2. In that go to System DSN tab


  1. Click Add. The Create New Data Source window opens.
  2. Click the Drivers tab and verify that the Simba MongoDB ODBC Driver is displayed in the list of ODBC drivers that are installed on your system.



  1. Select Simba MongoDB ODBC Driver and then click Finish. The Simba MongoDB ODBC Connector Setup window opens
  2. In the Data Source Name text box, type a name for your DSN.


Connecting Mongodb to OBIEE 11g

  1. Now go to obiee11g  --> In that select the database as ODBC
  1. Create a connection pool for that database
  1. Now you can Import that tables from Mongodb


3 comments: