How to download, install, and configure Devart ODBC Driver for Oracle
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 file you need to download.
Install the driver
Run the installer you downloaded. Click Next and follow the instructions.
Open ODBC Data Source Administrator
Click Start on the taskbar and search for ODBC Data Sources.
Add a data source (DSN)
In the ODBC Data Source Administrator, go to the System DSN tab and click Add. Select Devart ODBC Driver for Oracle and click Finish.
Activate the driver
In the Devart ODBC Driver for Oracle Configuration window, navigate to the License tab and click Input Activation Key. Paste your activation key in the corresponding field or click Load Key... and specify the path to the file that contains your activation key.
Configure the DSN
On the General tab, enter a Data Source Name, Description, and Oracle connection details.
Complete the configuration
Click Test Connection to make sure that all details are correct. Then, click OK to save the DSN settings and complete the configuration.
Prepare for the installation
1. Install the iODBC driver manager. It's required for the driver to work properly.
2. Go to Apple menu > System Preferences > Security & Privacy. Select App Store and identified developers under Allows apps downloaded from.
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.Start the installation
Run the installer you downloaded. Click Continue and follow the instructions.
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. Enter your key or click Load Activation Key... and specify the path to the file that contains you activation key. Click Continue.
Complete the installation
On the Installation Type page, click Install. After the installation finishes, click Close.
Configure a data source (DSN)
Go to Finder > Applications > iODBC and open the iODBC Administrator. On the System DSN tab (recommended), click Add, select Devart ODBC Driver for Oracle, and click OK.
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 exit the 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 or RPM package for your system 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.Install the driver
With a DEB package, you can install the driver using the GUI. Go to the package location (by default, the package is downloaded to /home/user/Downloads). Right-click the package and select Open With > App Center. In the App Center window, click Install.
You can also use the command line to install the driver from either a DEB or RPM package and activate the installed driver. For more information, see the driver documentation.
Activate the driver
In your command-line interface, navigate to the folder where the driver is installed. Run the following command:sudo ./oracleodbcactivator -a <your_activation_key>.
Instead of the activation key, you can specify the path to the file that contains your activation key.
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 DSN named DEVART_ORACLE (it was created automatically) and specify the connection details:
[DEVART_ORACLE]
Driver=Devart ODBC Driver for Oracle
Direct=True
Host=your_oracle_server_name
Port=your_oracle_listener_port
Service Name=your_oracle_database_name
UserID=your_oracle_user_id
Password=your_oracle_password
Save the changes and close the file.
Test the connection
Run isql -v DEVART_ORACLE to test the connection using isql, the ODBC command-line tool. Once connected, you can run SQL queries to retrieve data from Oracle.
