Python on Linux data integration tutorials
Tutorials for querying live data from Python on Linux servers with pyodbc, unixODBC and CData ODBC drivers, including DSN setup and troubleshooting.
What this integration does
On Linux, Python reaches ODBC sources through unixODBC and the pyodbc module. Data sources are defined in odbc.ini files and drivers are registered in odbcinst.ini, so most connection failures come from configuration rather than from the Python code.
How CData fits in
CData ODBC drivers run on Red Hat based and Debian based systems, including Ubuntu, Debian, RHEL, CentOS and Fedora. The installer registers the driver and creates a data source, and pyodbc connects to it by name. The tutorials cover reading data into pandas, the DSN and INI details that matter, API limits and performance, and how to diagnose connection errors.
Python on Linux tutorials by data source
Active DirectoryActive Directory from Python on Linux: ODBC Settings and Snippets
A quick reference for querying Active Directory from Python on Linux with the CData ODBC driver: setup commands, odbc.ini keys, connection strings, SQL.
Microsoft DataverseDataverse from Python on Linux: Fewer API Calls, No 429 Errors
Tune Python on Linux reading Dataverse through the CData ODBC driver: measure API use, pull fewer columns and rows, and stay within Dataverse request limits.
SAPRunbook: Read SAP Tables from Python on a Linux Server
A checklist for reading SAP tables like MARA from Python on Linux with the CData ODBC driver and pyodbc, from SAP details to a smoke test and hand-off.
SharePointLoad a SharePoint List into pandas from a Linux Server
Query a SharePoint list from Python on Linux with the CData ODBC driver, unixODBC and pyodbc, then load the rows into a pandas DataFrame and save them as a CSV file.
Sybasepyodbc Can't Connect to Sybase on Linux? Check These Six Things
Fix pyodbc errors from Python on Linux to Sybase via the CData ODBC driver: missing DSN, wrong odbc.ini, UTF-16 setting, login properties, uncommitted writes.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.