Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Salesforce

Python Connector for Salesforce is a connectivity solution for accessing Salesforce from Python applications to read and update data. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Standard SQL syntax

The connector fully supports the ANSI SQL standard and lets you execute SQL statements against your Salesforce data just like you would normally work with relational databases. Simple queries are directly converted to Salesforce API calls and executed on the Salesforce side. Complex queries are transformed into simpler queries, which are then converted to Salesforce API calls. The embedded SQL engine then processes the results in the local cache and applies advanced SQL features from the original complex query.

Using the connector

To retrieve data from a database:

Import the module.

import devart.salesforce

Connect to a database using the connect() module method and obtain a connection object: If you're using basic authentication:

my_connection = devart.salesforce.connect(
    Authentication="Basic",
    Host="your_org_url",
    UserId="your_username",
    UserPassword="your_password",
    SecurityToken="your_token"
)

If you're using OAuth 2.0 authentication and have a refresh token:

my_connection = devart.salesforce.connect(
    Authentication="OAuth",
    Host="your_org_url",
    RefreshToken="your_refresh_token"
)

If you're using OAuth 2.0 authentication and don't have a refresh token:

response = devart.salesforce.signin(Host="your_org_url")
my_connection = devart.salesforce.connect(
    Authentication="OAuth",
    Host="your_org_url",
    RefreshToken=response["Refresh Token"]
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/salesforce/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/salesforce/activate-a-license.htm

What's new

Python Connector for Salesforce 1.2

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_salesforce_connector-1.2.0-cp313-cp313-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_salesforce_connector-1.2.0-cp313-cp313-win32.whl (35.2 MB view details)

Uploaded CPython 3.13 Windows x86

devart_salesforce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.13 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp312-cp312-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_salesforce_connector-1.2.0-cp312-cp312-win32.whl (35.2 MB view details)

Uploaded CPython 3.12 Windows x86

devart_salesforce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp311-cp311-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_salesforce_connector-1.2.0-cp311-cp311-win32.whl (35.2 MB view details)

Uploaded CPython 3.11 Windows x86

devart_salesforce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp310-cp310-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_salesforce_connector-1.2.0-cp310-cp310-win32.whl (35.2 MB view details)

Uploaded CPython 3.10 Windows x86

devart_salesforce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp39-cp39-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_salesforce_connector-1.2.0-cp39-cp39-win32.whl (35.2 MB view details)

Uploaded CPython 3.9 Windows x86

devart_salesforce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp38-cp38-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_salesforce_connector-1.2.0-cp38-cp38-win32.whl (35.2 MB view details)

Uploaded CPython 3.8 Windows x86

devart_salesforce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (71.7 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_salesforce_connector-1.2.0-cp37-cp37m-win_amd64.whl (38.4 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_salesforce_connector-1.2.0-cp37-cp37m-win32.whl (35.2 MB view details)

Uploaded CPython 3.7m Windows x86

devart_salesforce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (37.2 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_salesforce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (70.0 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_salesforce_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 5debe6c8ccac462a68e9c388881c42a8b4d43d9a76aa3ae2ed196e0aa461909f
MD5 60010f918c4c35beefe4daba9f09a555
BLAKE2b-256 31c1e662023c444de0bd4d5b09cbce06705727ba50643b8f53d006747d70b139

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 2e29c83d603950dbf3591f3b1e8b88cfed157aa485e22e3eacd84e082a0e0c5e
MD5 5f74e0cc8de53013933f32a0269e722d
BLAKE2b-256 1af60cef773b6f887866753e3befd31115145812060050aa63880d2de4f2fa9f

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 19585c966739ef2240eb9c1d08daacbb566081361471cc5462ed63437c1d3895
MD5 2adc81564a5657563c1ca44a5dccbd6a
BLAKE2b-256 8958290b0a5486f766c6a6c78583fedfd899e338bc9cd75f17440a1845dc9dcc

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 5820fabc982ad78bed4199b3d7bec13ad7ade53e334911c82726694d5b8f4804
MD5 5c0764f57587eca8e8e9828ce78ee7e2
BLAKE2b-256 b51d61698f9a069b14fa91d10ea99ecb1d4113661110c06cfa5a4d1f33af62cd

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 a7b9d552218ef1cee8d3ce7caab415ab24302e75f5d318b6238970ec2e20cafb
MD5 00791de12897146865a4b2864495e484
BLAKE2b-256 f66e48212f4b5bad118bb83daa4f7ee633d92acb2bd10a30605b064521365e0b

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 90597328d1b2eb7eda2c3676a3cc6eac7db5a86a1f15eaf65736b1329841bdb9
MD5 597ece27d64600aeb417add22718f2cc
BLAKE2b-256 a6dc14dcbe795b66aa71d7227cc8b23f6135502c80974458f5e89f38561fecb2

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 ced22f4e86d66f3c1813886035417420b8ed44597f1e2df0a6f6e0b32c7d0370
MD5 ec3c026a46591417b8f63bc2cbee72dd
BLAKE2b-256 5c89b3388206f386c02b24dfa80eb3b4dea0fd4ffdedf3e35d27e1e4f2e31270

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 7415305b18954bf02cfa2a9bc5e49d095e99223806d34a1534bb3cc0fff1fc42
MD5 deda7eab4ef25b409c72f0f9020e5bd1
BLAKE2b-256 a68709f4e5eacc28da463b7f5644ae812a9c92c54b8512f78a95d499f2e5c760

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 b73f9daa1596b370bc21fd73e99ee7c5079b121eb0ba94c12321b02ad0681cf5
MD5 20c40cff896a3580e9a93ae021abb081
BLAKE2b-256 3272bb0df6de771016f401208e7c03ee635423682189b0d6442f6fca7593c5d3

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 6e9790c25d09383771ad48a0092a106148a55cb90a415c0235ac911a1e39b980
MD5 420408914eb7611486c10e42752237e9
BLAKE2b-256 ad151b9bcb2cd0b7fd098bf7b33148823ee3611f3e6216302f7444c8eb32c794

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 d0797818eb25ea95e7979bf44b2d0e1fab67d68e86c6f64a31dcd8efa737f85a
MD5 d32237bd0cf6486ff5df83c591859b5f
BLAKE2b-256 9e10f746ae5ad26d6cba7343d6567969d662f441dda6db6caead9c3360289add

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 6c3839afc9ccad76a4bd113881954edcc233c9144bc5e9cf588470f961f71dbd
MD5 fc235d7fa94f470327f217b0c7293ead
BLAKE2b-256 e5de67a126f8fc5aeb51ca91894ed9ae06e1514bd3897f4ed533b6abf5b9b67a

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 82719352648e6fa59b714f525b1e12f7afdcac52e0e707ff1dbe3a816decc241
MD5 d4361361f35c538e3e746d8361f5fecd
BLAKE2b-256 1e917c194818d6f1c4467e97d88ee49ffa89c022406a7187ed2a485b1fee7c47

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 0d0545ed56422b7a5b14cead60b0e663a77fc7cb9cb8ac90670a749712196017
MD5 f9d717646d32f1a116bb17fe820a716d
BLAKE2b-256 1ea6b40f7917b2bb07d3c3b5ee28c8a93e23c5e6e72e66403482e36e56ae94a2

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 da285ef047e57342b9e649f876ace91fbfc541ce9391eb1d45ff7c43591c0a38
MD5 19cebc84fadd080c7ab581db9bdc547e
BLAKE2b-256 fc41bba80b2c533056eabf6e0e55622023e8f02a6046cd126599bcf604cb4236

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 77815ecc93de836c57d406736ed76d1f2e7a9ee53b7dbdf54450d5ffc8012c20
MD5 820ed1d5225936893ab61414640af165
BLAKE2b-256 34f840397b31dbfb392a46edafabd23bd2ba150bb75c656a37a5453e165ca781

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 945c950140bc4b953e6e1ad5a117863d2e833729c30c531af260a4f86e5388ce
MD5 14db565736b7921c08a8b9aa7366d5ec
BLAKE2b-256 105dc28c2ed3a898fb4f04806c8151d0f25b4a1e4e1fb86485094dd2c7aeee43

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 b8c6ff37e7871dca904a6f0a9b1dedc18f6974d29cd366cadd6be238e99770e4
MD5 654ab4871e5b1a2c786084278eeade9c
BLAKE2b-256 f5093eca815a5e2497ea94d741940bf99bc9650274bd4a5f67107a50596fe74a

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 fa214a688ffe23d834d690c68a0c8b1213481c1fa18ea62601dda97f478bd035
MD5 420d3a10fd47cee6670bcdef3a5c0d1b
BLAKE2b-256 393fd1d5ff01fc44e1bf3b51ee6076b965ca2b915a4995dcc8f2d69933525294

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 c6bddfb8e9c25f621b10bee04bd3dcd54cfd5c95a1054dcbc53483dd4dcda066
MD5 bc5e906f34f30f20205bcfeb84dd379e
BLAKE2b-256 23b334a5834007124bd4e68d6157b288e80cb356114ab996a08302418d573bc6

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 46bde2c962134e8f07659a171213477c4648b5ee352417cfd556be8ef2b58e70
MD5 33e08bdaeba5ac30cd7a32c2940480fe
BLAKE2b-256 f020b5ef3333fea6467dc66a3ce5055eee6cfc5d1e2d9619e268020b63063710

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 86a9b448ac11e8ac9d85e43bc339e2c6d650426037e5b2b5a0281afd39fcf03a
MD5 52c0b517673d4e53d93e8531c89436ad
BLAKE2b-256 75ef12a30716728dd392bdd47377a388615dd0e9c487781a3256799cbe9d894a

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 2842582f58be89019439e40d092fc3d748e961b1dc173b0ec6c517570253f368
MD5 8498c2042118d2634387a6298db9aafe
BLAKE2b-256 46d00db6785c07fc8848a099457561de210a70698de84ef107fd07c17602ad34

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 5d69b0e6861b8c6029b633bda4b3ee599b8e127a07ee3fbaa91a9c6e5da98799
MD5 e8cf7a745d49871c1727ef0ec26f50cd
BLAKE2b-256 42e7ed079185842221f30bc7dce07d44b2b3d9d053dc904bc5272e47c35140c9

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 209ebfe834a1a184c25974e21c19670dc24c1ba629d6acbeced3d61609d14af9
MD5 28f4cabd695d8984ebe3a61a42f37d61
BLAKE2b-256 0197b3e68f6ea78d68ddbdc3b3fac2fbc8509468b7eac035a326cf5c86c91a2b

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 5731a98f1658f7a259e8aa3ea56f9613c7d626389e0fd1a53c8f70e42a295795
MD5 3a1cbd0a8f88d765af41527ca7cb33c9
BLAKE2b-256 29732abac64a82ae06e2ce31748f1deaa34d3836ffa2312155d42b155d1817ca

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 5e19d6e3ddbdfae45dd5d3fd61f6df32789ca4beeecbaeb4a8a1772a054bcadd
MD5 8d59b67682e9ce24cd16745e460eff49
BLAKE2b-256 571ef37e05f05f447eeceaf085da294c0489cdfef9f8acdef65f4f7ce91cfa80

See more details on using hashes here.

File details

Details for the file devart_salesforce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_salesforce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 94479cafc515dd31fb02bf730aa0cb00f6409fc269e14d7370d663f0bf556db5
MD5 ee7ff0c79de490a4a39fb5f87e90b029
BLAKE2b-256 b6f5324e53f96723b7ebc58b409038834f8f177260e36279439694c99b08b7f6

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page