Python Connector for Salesforce
Python Connector for Salesforce icon

Python Connector for Salesforce

by Devart
$74.95
Python Connector for Salesforce boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server, macOS 64-bit and ARM (Apple silicon), Linux 64-bit
System Requirements
Python 3.10 to 3.15. Windows 32/64-bit, Windows Server, macOS 64-bit and Apple silicon, Linux 64-bit. A Salesforce org with API access
File Size
77.99 MB
Release Date
10/22/2026
Last Updated
11/18/2026
3 views 0 downloads
DB API 2.0 Python connector that queries and updates Salesforce with ANSI SQL

Devart Python Connector for Salesforce: Query Salesforce from Python with Plain SQL

Devart Python Connector for Salesforce is a paid Python module, $74.95 a year for one developer, that lets Python 3.10-3.15 code on Windows, macOS and Linux read and update Salesforce data with ordinary ANSI SQL, including joins and grouping, through the Python DB API 2.0 interface. It signs in with a password and security token, OAuth 2.0, or server-to-server client credentials.

Salesforce's own query language, SOQL, has no free-form joins and limited aggregation, and the popular free library simple-salesforce speaks SOQL and returns JSON-like records. Devart's connector instead treats Salesforce objects as SQL tables: simple queries become Salesforce API calls, and more complex ones are split up and finished by a SQL engine built into the connector.

Quick facts

  • Version: 1.4.0, released October 22, 2026; first released December 1, 2023
  • Developer: Devart
  • Package: pip install devart-salesforce-connector, or wheel files from Devart's download page (77.99 MB for Windows)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
  • Sign-in: user name, password and security token; OAuth 2.0; server-to-server client credentials (added in 1.4)
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription, and PyPI and Devart's download page both showed version 1.4.0 with Windows, macOS and Linux wheels, on November 18, 2026. We didn't connect it to a Salesforce org

Download Free Trial Buy Now

Overview

You import devart.salesforce and call connect(). Basic sign-in takes the Host (login.salesforce.com), UserId, UserPassword and SecurityToken; OAuth uses salesforce.signin() to get a refresh token; and Authentication="ServerToServer" takes a consumer key and secret for unattended jobs. From there it's a cursor, execute() with ? parameters, and fetchall().

Because objects behave like tables, a query such as SELECT a.Name, COUNT(o.Id) FROM Account a JOIN Opportunity o ON o.AccountId = a.Id GROUP BY a.Name works even though SOQL can't express it directly. The connector also supports INSERT, UPDATE and DELETE, so you can write changes back.

Features

ANSI SQL on top of the Salesforce API

Python Connector for Salesforce turns simple SELECT statements straight into Salesforce API calls that run on Salesforce's side. Complex statements are broken into simpler queries, and the connector's embedded SQL engine applies the joins, grouping and other SQL features to the results in a local cache.

Unattended sign-in for scheduled jobs

Python Connector for Salesforce 1.4 added server-to-server authorization with a consumer key and secret, and 1.3.1 (March 2026) added OAuth 2.0 with your own connected app's ConsumerKey and ConsumerSecret. Basic sign-in with a security token still works.

Metadata cache, pooling and batches

Python Connector for Salesforce caches object metadata so repeated queries start faster, pools connections, and submits several update statements to Salesforce as one batch. Version 1.3 fixed reading some custom fields and columns of the Calendar, Folder and Group tables.

Runs on all three desktop platforms

Python Connector for Salesforce ships wheels for Windows (32-bit and 64-bit), macOS on Intel and Apple silicon, and 64-bit Linux, so the same script runs on a developer's Mac and a Linux server.

Benefits

  • Use SQL you already know. Analysts write joins and GROUP BY instead of learning SOQL's limits.
  • Fewer API round trips to code by hand. The connector decides what goes to Salesforce and what it computes locally.
  • Writes, not just reads. INSERT, UPDATE and DELETE run against Salesforce objects.

Real-World Uses

  • Pipeline report. A nightly script joins Accounts, Opportunities and Owners and writes a summary to a database.
  • Data clean-up. A script finds duplicate Contacts with SQL and updates them in batches.
  • Sync to a warehouse. A Linux cron job uses server-to-server sign-in to copy changed records into PostgreSQL.
  • Ad-hoc questions. An analyst in a Jupyter notebook answers a sales question with one SQL query.

Who It's For, and Who Should Skip It

The connector suits analysts and developers who think in SQL and need joins and aggregates across Salesforce objects from Python, without writing SOQL plus pandas glue for every question.

Skip it if you're comfortable with SOQL or only need simple record reads and updates: simple-salesforce is free and widely used. Very large extractions are better served by the Salesforce Bulk API or a dedicated ETL tool than by row-by-row SQL.

Usage Guide

  1. Install with pip install devart-salesforce-connector, or download the wheel for your Python version and platform.
  2. After buying, run devart.salesforce.license.activate("<key>") with the key from the order email or customer portal.
  3. Connect with basic sign-in (UserId, UserPassword, SecurityToken), OAuth (refresh token from signin()) or ServerToServer (ConsumerKey, ConsumerSecret).
  4. Query: cur.execute("SELECT Id, Name FROM Contact WHERE Email = ?", ["a@example.com"]) and cur.fetchall().
  5. Write changes back with UPDATE or INSERT statements, batching them for larger jobs.

Before you buy

Complex SQL is partly processed on your machine after the data is fetched, so a broad join over large objects can pull many records and use Salesforce API calls from your org's daily allowance. Test your heaviest queries in the trial. The download is large, about 78 MB per Python version on Windows.

Where it falls short

  • API limits still apply. Every query consumes Salesforce API calls.
  • Free alternatives exist. simple-salesforce covers SOQL reads and writes at no cost.
  • No asyncio API. It's a synchronous DB API 2.0 driver.
  • Closed licensing. No public packages built on it; redistribution needs an OEM license.

Comparisons

Devart vs. simple-salesforce

simple-salesforce is free and open source, wraps the REST API and uses SOQL. Devart Python Connector for Salesforce costs $74.95 a year and adds full SQL with joins and grouping, a DB API 2.0 interface, metadata caching, pooling and vendor support. Choose Devart when SQL is the point.

Python connector vs. Devart's ODBC driver for Salesforce

Devart's ODBC driver for Salesforce also feeds Excel, Power BI and other ODBC tools, as well as Python through pyodbc. If Python is the only consumer, the Python connector is cheaper; if reports need Salesforce too, the ODBC driver covers both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
Team$189.95On the order pageUp to 4 developers at one company site
Site$339.95On the order pageUnlimited developers at one company site

Buy Now opens the order for Python Connector for Salesforce with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.

FAQs

Can Python Connector for Salesforce join Salesforce objects in one query?

Yes. Python Connector for Salesforce accepts ANSI SQL joins; queries Salesforce can't run itself are split up and finished by the connector's embedded SQL engine.

Does Python Connector for Salesforce support OAuth with my own connected app?

Yes. Since version 1.3.1 (March 2026), Python Connector for Salesforce supports OAuth 2.0 with your own ConsumerKey and ConsumerSecret, and 1.4 added server-to-server authorization.

Does it run on Linux servers?

Yes. Python Connector for Salesforce ships a 64-bit Linux wheel, plus Windows and macOS (Intel and Apple silicon) wheels.

Can it update Salesforce records?

Yes. Python Connector for Salesforce supports INSERT, UPDATE and DELETE and can send several update statements to Salesforce as one batch.

Which Python versions does Python Connector for Salesforce support?

Python Connector for Salesforce 1.4 supports Python 3.10 to 3.15.

Can I get a refund on Python Connector for Salesforce?

Possibly. Python Connector for Salesforce's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

System Requirements

  • Python 3.10 to 3.15 with pip
  • Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
  • A Salesforce org with API access
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for Salesforce is worth $74.95 a year if you want to ask Salesforce questions in real SQL from Python, with joins and grouping that SOQL makes awkward, on any desktop platform. If SOQL suits you, simple-salesforce does the job for free, and very large exports belong in the Bulk API. Try your heaviest queries in the 30-day trial and watch your API usage.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.