Driver Setup

To set up the Simba MongoDB ODBC Driver to connect to your data store, do the following:

  • Install the driver on the machine that you use to access the data. For more information, see Installing the Driver.
  • Configure the driver by creating a Data Source Name (DSN) that specifies the necessary connection properties. For more information, see Configuring the Driver.

Installing the Driver

The Simba MongoDB ODBC Driver is available for download at http://www.simba.com/drivers/mongodb-odbc-jdbc.

On 64-bit Windows operating systems, you can execute 32- and 64-bit applications transparently. You must use the version of the driver matching the bitness of the client application accessing data in MongoDB:

  • SimbaMongoDBODBC32.msi for 32-bit applications
  • SimbaMongoDBODBC64.msi for 64-bit applications

You can install both versions of the driver on the same machine.

You install the Simba MongoDB ODBC Driver on client machines that access data stored in MongoDB databases. Each machine that you install the driver on must meet the following minimum system requirements:

  • One of the following operating systems:
    • Windows Vista, 7, 8, or 10
    • Windows Server 2008 or later
  • 600 MB of available disk space

Important:

To install the driver, you must have Administrator privileges on the machine.

The driver supports MongoDB versions 2.4, 2.6, 3.0, and 3.2.

To install the Simba MongoDB ODBC Driver:

  1. Depending on the bitness of your client application, double-click to run SimbaMongoDBODBC32.msi or SimbaMongoDBODBC64.msi.
  2. Click Next.
  3. Select the check box to accept the terms of the License Agreement if you agree, and then click Next.
  4. To change the installation location, click Change, then browse to the desired folder, and then click OK. To accept the installation location, click Next.
  5. Click Install.
  6. When the installation completes, click Finish.
  7. If you received a license file via e-mail, then copy the license file into the \lib subfolder in the installation folder you selected above.

    8. Note:

    To avoid security issues, you might need to save the license file on your local machine prior to copying the file into the \lib subfolder.

Configuring the Driver

To use the Simba MongoDB ODBC Driver in a client application, you need to configure a Data Source Name (DSN) to connect to your data store.

To create a Data Source Name:

  1. Open the ODBC Administrator:
    • If you are using Windows 7 or earlier, click Start Windows Start button, then click All Programs, then click the Simba MongoDB ODBC Driver program group corresponding to the bitness of the client application accessing data in MongoDB, and then click ODBC Administrator.
    • Or, if you are using Windows 8 or later, on the Start screen, type ODBC administrator, and then click the ODBC Administrator search result corresponding to the bitness of the client application accessing data in MongoDB.
  2. Click the System DSN tab.
  3. In the list of DSNs, select Simba MongoDB ODBC DSN, and then click Configure.
  4. In the Server field, type the IP address or host name of the MongoDB instance.

    5. Note:

    If you are running MongoDB on your local machine, then type localhost in the Server field.

  5. In the Port field, type the number of the TCP port that the MongoDB server uses to listen for client requests.

    6. Note:

    By default, MongoDB uses port 27017.

  6. In the Database field, type the name of the database that you want to access.
  7. If your MongoDB server is configured to use authentication, then select the appropriate authentication mechanism from the Mechanism drop-down list and provide the necessary credentials and authentication settings in the fields below the list.

    8. Note:

    For detailed information about configuring authentication, see the Simba MongoDB ODBC Driver Installation and Configuration Guide.

  8. To test the connection to your MongoDB data store, click Test in the Simba MongoDB ODBC Driver DSN Setup dialog box.

    9. The Test Results dialog box appears, displaying a message informing you whether the connection succeeded or failed.

  9. Click OK to close the Test Results dialog box, and then click OK to save your DSN and close the Simba MongoDB ODBC Driver DSN Setup dialog box.

Note:

For more information about configuring the Simba MongoDB ODBC Driver, including how to modify or update the schema definition used for the MongoDB data store, see the Simba MongoDB ODBC Driver with SQL Connector Installation and Configuration Guide.

Related topics