Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
CData Python FAQs, Community Resources, & Troubleshooting
Frequently Asked Questions
What operating systems do CData Python Connectors support?
CData Python Connectors work on Windows, Mac, and Linux operating systems.
What versions of Python do CData Python Connectors support?
All environments: Python 3.8, 3.9, 3.10, 3.11, and 3.12
What framework or interface are the CData Python Connectors based on (if any)?
CData Python Connectors are built using the DB-API specification.
What versions of SQL Alchemy do CData Python Connectors support?
SQLAlchemy 1.3, 1.4, and 2.0
What are the distribution or licensing options with CData Python Connectors?
The Community License allows you to install the Connector on one (1) desktop or workstation for personal use, development, or testing.
A Per-Developer license allows you to install and internally use the Connector on any number of desktops or workstations with options for royalty-free distribution within your organization.
Community resources
Visit the CData Community to browse Python articles and Python questions.
Common errors & troubleshooting
-
Where is the license activator?
If you are unable to find the license activator after installation, you can execute the following command, which prints the folder path of the site-packages folder:
import os import cdata.csv path = os.path.abspath(cdata.csv.__file__) print(path)Navigate to the location and run the install-license tool with your license key to activate your license.
Windows: ./install-license.exe
Linux / Mac: ./install-license.sh
-
It looks like the Connectors leverage JNI (Java Native Interface) on Mac and Linux, can I configure JNI logging?
There are two options for configuring JNI logging on Mac/Linux environments:
Set an environment variable for the current terminal session:
export CDATA_LOGFILE=FILE:///tmp/cdatajnilog.txt|DEBUGCreate or edit a config.ini file and append the following content. Note that corresponds to the data source you're working with and can be found in the Help documentation; 312 corresponds to Python 3.12, so you will need to adjust accordingly for other Python versions:
[.cpython-312-x86_64-linux-gnu.so] LOGFILE=FILE:///tmp/jnilog.txt|DEBUG
Free Community License for data developers
CData Python Connectors further enhance the capabilities of the Python DB-API & petl by offering consistent, SQL-based connectivity to more than 270 data sources beyond traditional databases, including SaaS, NoSQL, and big data systems. With the CData Python Community License, you get free-forever libraries to access your data in personal Python projects, all through familiar SQL. Request a license and start creating better-connected projects today!
