IntegrationPython/5 tutorials

SQLAlchemy data integration tutorials

Tutorials for querying MongoDB, Athena, DynamoDB, BigQuery, Snowflake and other sources from Python with SQLAlchemy and CData Python connectors.

What this integration does

SQLAlchemy is a Python toolkit for working with SQL databases. You create an engine from a connection string, then run queries or use the ORM from scripts and applications. Because the engine hides the database behind one interface, the same code can work with very different back ends.

How CData fits in

CData Python connectors let SQLAlchemy reach sources that are not relational databases. You can query, insert, update and delete live data from a script, and the connector pushes supported operations to the source while its embedded SQL engine handles the rest. The tutorials cover connection strings for each source, the query behavior that affects cost and speed, and the errors people run into most often.

SQLAlchemy 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.