How to download, install, and configure Devart ODBC Driver for Salesforce
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 Devart ODBC Driver for Salesforce and click Finish.
Configure the DSN
On the General tab, enter a Data Source Name, Description, and Salesforce connection details. The default authentication method is OAuth 2.0. To use basic authentication, select User ID and Password from the Authentication menu.
Complete the configuration
Click Test Connection to make sure that all details are correct. Then, click OK to save the DSN 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 Settings > Privacy & Security. In Allow applications from under Security, select App Store & Known Developers.
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 downloaded installer. Click Allow to start the installation. In the Install Devart ODBC Driver for Salesforce 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 (recommended), select the DSN named DEVART_SALESFORCE (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 or RPM 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
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.
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.
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 DSN named DEVART_SALESFORCE (it was created automatically) and specify the connection details.
Data Source=<your Salesforce instance>
User ID=<your Salesforce username>
Password=<your Salesforce password>
Security Token=<your Salesforce account security token>
Closing the file, save the changes.
Test the connection
Run isql -v DEVART_SALESFORCE to test the connection using isql, the ODBC command-line tool. Once connected, you can run SQL queries to retrieve data from Salesforce.
