IntegrationODBC/5 tutorials

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

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.