Apache Airflow data integration tutorials
Tutorials for querying SharePoint, SAP, LDAP, Active Directory and ServiceNow from Apache Airflow DAGs with the CData JDBC driver.
What this integration does
Apache Airflow supports creating, scheduling and monitoring data engineering workflows. A task in a DAG can query a database through a JDBC connection and write the result somewhere else, such as a file or a table.
How CData fits in
The CData JDBC driver lets a task query sources that have no native Airflow integration, using the same JDBC connection mechanism as any other database. The tutorials cover DAG patterns, pre-flight checks for SAP, debugging tasks that fail, and how JDBC compares with calling a REST API or replicating the data with CData Sync.
Apache Airflow tutorials by data source
Active DirectoryAirflow Task Won't Query Active Directory? Start Here
Diagnose an Airflow task that fails or silently produces nothing when reading Active Directory through the CData JDBC driver, from test errors to slow runs.
LDAPLDAP in Apache Airflow: JDBC Connection Cheat Sheet
A quick reference for reading LDAP directory entries in Airflow with the CData JDBC driver: URL, class name, connection form fields, BaseDN scoping and DAG snippets.
SAPQuerying SAP from Apache Airflow: A Pre-Flight Checklist
Before scheduling SAP queries in Airflow with the CData JDBC driver, line up the JCo files, SAP logon values and DAG settings. Includes a smoke-test query on MARA.
ServiceNowServiceNow Data in Airflow: JDBC Hook, REST Calls, or Sync?
Compare three ways to pull ServiceNow tables into Airflow, then set up the CData JDBC driver with OAuth and query incidents in a DAG.
SharePointSchedule a Daily SharePoint List Export to CSV with Airflow
Run a SQL query against a SharePoint list from an Airflow DAG each morning with the CData JDBC driver, including SharePoint Online auth and failure handling.
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.