Python Connectors

Connect Python-based Data Access, Visualization, ORM, ETL, AI/ML, and Custom Apps with data from Anywhere!

  • Database API (DB-API) Modules for SaaS, Big Data, and NoSQL
  • Supports popular tools like pandas, SQLAlchemy, Dash, & petl.
  • Simple command-line based data exploration


Universal Python Data Connectivity

Easy-to-use Python Database API (DB-API) Modules for data connectivity. Straightforward access to live Application, Database, and Cloud API data through standard python database connectivity.

Python Data Connectivity

Seamless integration with popular data science tooling, like pandas, SQLAlchemy, Dash, & petl

Custom Applications

Developers can use our Python Connectors to rapidly connect Web, Desktop, and Mobile apps to data.

Enterprise-Class Design

Built with the same reliability, scalability, performance & security powering leading data integration solutions.

Data-Centric Architecture

A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more.

Python Connectors in Action!

Watch the video overview for a first hand-look at the powerful data integration capabilities included in the CData Python Connectors.

WATCH THE PYTHON CONNECTOR VIDEO OVERVIEW

Python Connectors

Python Database API (DB-API) Modules for NoSQL, Big Data, & SaaS Integration.



Contact Us
1010data
Contact Us
ADP
AWS Management
Access
Act CRM
Act-On
Active Directory
Acumatica
Adobe Analytics
Airtable
Alfresco
Amazon Athena
Amazon DynamoDB
Amazon Marketplace
Amazon S3
Asana
Authorize.Net
Avalara AvaTax
Azure Analysis Services
Azure Data Lake Storage
Azure Management
Azure Table
Basecamp
BigCommerce
BigQuery
Bing Ads
Bing Search
Blackbaud FE NXT
Box
Btrieve
Bugzilla
Bullhorn CRM
CSV
Cassandra
Cloudant
Confluence
Cosmos DB
Couchbase
Contact Us
DB2
DataRobot
DigitalOcean
DocuSign
Dropbox
Dynamics 365 Business Central
Dynamics 365 FinOp
Dynamics 365 Sales
Contact Us
Dynamics AX
Dynamics CRM
Dynamics GP
Dynamics NAV
EDGAR Online
Elasticsearch
Email
Epicor ERP
Evernote
Exact Online
Excel
Excel Online
Excel Services
FTP
FedEx
FinancialForce
FreshBooks
Freshdesk
GitHub
Gmail
Google Ad Manager
Google Ads
Google Analytics
Google Calendar
Google Campaign Manager
Google Contacts
Google Directory
Google Drive
Google Search
Google Sheets
Google Spanner
Greenplum
HBase
HDFS
HPCC Systems
Highrise
Hive
HubSpot
IBM Cloud Object Storage
IBM Cloud SQL Query
Impala
JSON
Jira
Kintone
LDAP
MYOB AccountRight
Magento
MailChimp
MariaDB
MarkLogic
Marketo
Microsoft CDS
Microsoft Exchange
Microsoft OneDrive
Microsoft Planner
Microsoft Project
Microsoft Teams
MongoDB
MySQL
NetSuite
OData
OFX
Odoo
Office 365
OneNote
Open Exchange Rates
Oracle
Oracle Eloqua
Oracle Sales Cloud
Parquet
PayPal
Phoenix
PostgreSQL
Presto
Quandl
QuickBase
QuickBooks
QuickBooks Online
QuickBooks POS
REST
RSS
Reckon
Redis
Redshift
SAP
SAP Business One
SAP Business One DI
SAP ByDesign
SAP Concur
SAP Fieldglass
SAP HANA
SAP Hybris C4C
SAP Netweaver Gateway
SAP SuccessFactors
SFTP
SQL Analysis Services
SQL Server
Sage 200
Sage 300
Sage 50 UK
Sage Cloud Accounting
Sage Intacct
Contact Us
Sage US
Salesforce
Salesforce Einstein
Salesforce Marketing
Salesforce Pardot
SendGrid
ServiceNow
SharePoint
Shopify
Smartsheet
Snowflake
Spark
Splunk
Square
Streak
Stripe
Sugar CRM
SuiteCRM
SurveyMonkey
Sybase
Sybase IQ
TSheets
Tally
Teradata
Trello
Twilio
UPS
USPS
Veeva
Veeva CRM
Wasabi
WooCommerce
WordPress
XML
Xero
Xero WorkflowMax
YouTube
YouTube Analytics
Zendesk
Zoho Books
Zoho CRM
eBay
xBase
… Dozens More
(API Driver)





Powerful Enterprise-class Data Connectivity Features

Full-featured and consistent SQL access to any supported data source from Python



  • Universal Python Data Connectivity

    Easily connect with SaaS, Big Data, and NoSQL data from common Python-based frameworks, including:


    • Data Analysis/Visualization: Jupyter Notebook, pandas, Matplotlib
    • ORM: SQLAlchemy, SQLObject, Storm
    • Web Applications: Dash, Django
    • ETL: Apache Airflow, Luigi, Bonobo, Bubbles, petl
  • Popular Tooling Integration

    All of our Python Connectors integrate seamlessly with popular data science and developer tooling like Anaconda, Visual Studio Python IDE, PyCharm, Real Python, and more.

  • Replication and Caching

    Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.

  • String, Date, Numeric SQL Functions

    The Python Connectors include a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Collaborative Query Processing

    Our Python Connectors enhance the data source's capabilities by additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Easily Customizable and Configurable

    The data model exposed by our Python Connectors can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.

  • Enterprise-class Secure Connectivity

    Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

Connecting Python with Data from Anywhere

Support DataOps With Easy-to-use Data-Centric Connectors





Organizations worldwide are using Python to harvest insights from data. Pythons vast ecosystem of tools, modules, and extensions support DataOps initiatives by dramatically simplifying data movement and processing.

The CData Python Connectors fill a critical gap in Python tooling by providing consistent connectivity with data-centric interfaces to hundreds of different SaaS/Cloud, NoSQL, and Big Data sources.