How to download, install, and configure Devart ODBC Driver for MongoDB
Download the driver
Click Download in the upper-right corner of this page. Under Download for Windows, click Download next to the EXE or MSI file or—if you're not signed in—click Get Trial, sign up or sign in to your Devart account, and then click Download next to the needed file.
Install the driver
Run the downloaded installer. Click Next and follow the instructions.
Start the trial period or activate the driver
If you don't have an activation key yet, select Trial; if you've already purchased a license, select Activation Key and enter your key. Then, click Next. To complete the driver installation, click Finish.
Open ODBC Data Source Administrator
Click Start on the taskbar, type ODBC Data Sources, and select a matching result. The ODBC Data Source Administrator opens.
Add a data source (DSN)
Go to the User DSN or System DSN tab and click Add. Select the driver and click Finish.
Configure the data source (DSN)
On the General tab, enter a Data Source Name, Description, and other details required to connect to the data source.
Complete the configuration
Click Test Connection to make sure that all details are correct. Then, click OK to save the data source and complete the configuration.
Prepare for the installation
Install the iODBC driver manager. It's required for the driver to work properly.
Download the driver
Click Download in the upper-right corner of this page. Under Download for macOS, click Download next to the PKG file or-if you're not signed in-click Get Trial, sign up or sign in to your Devart account, and then click Download next to the file.Run the driver installer
Run the downloaded installer. In the warning that appears, click Done. Then, in Apple menu > System Settings > Privacy & Security > Security, click Open Anyway. In the next warning, click Open Anyway. If prompted, enter your password.
Start the installation
Click Allow to start the installation. In the Install Devart ODBC Driver window, click Continue on the first page and on the next one.
Agree to the software license agreement
On the License page, read the agreement, click Continue, and then click Agree.
Start the trial period or activate the driver
If you don't have an activation key yet, select Trial; if you've already purchased a license, select Activation Key and enter your key. Then, click Continue.
Complete the installation
Click Install. If prompted, enter your password to allow the installation and click Install Software. After the installation finishes, click Close.
Configure a data source (DSN)
Go to Finder > Applications > iODBC and open iODBC Administrator of the required bitness. On the System DSN tab, select the data source (it was created automatically) and click Configure.
Enter connection details
Specify the required connection details and click OK.
Complete the configuration
Click Test to make sure that all details are correct. Then, click OK twice to close the message and iODBC Data Source Administrator.
Prepare for the installation
Note: This is a flow for Ubuntu 24. For other distributions, the steps may vary.
Make sure you have an ODBC driver manager installed—we recommend using unixODBC. You can install it with sudo apt-get install libodbc2 libodbcinst2 odbcinst unixodbc.
Download the driver
Click Download in the upper-right corner of this page. Under Download for Linux, click Download next to the DEB package of the required bitness or—if you're not signed in—click Get Trial, sign up or sign in to your Devart account, and then click Download next to the package.Open the installer location
Go to the package location (by default, the package is downloaded to /home/user/Downloads). Right-click the package, select Open With > App Center, and click Open.
Install the driver
In the App Center window, click Install. In the warning that appears, click Install too. If prompted for authentication, enter the password and click Authenticate.
Configure a data source (DSN)
Open the odbc.ini file in a text editor. We're using nano, so the command is sudo nano /etc/odbc.ini. Locate the DEVART_<data_source> DSN (it was created automatically) and specify the required connection details.
Closing the file, save the changes.
Test the connection
Run isql -v <dsn_name> to test the connection using isql, the ODBC command-line tool. Once connected, you can run SQL queries to retrieve data from MongoDB.
