Tutorials

Data integration tutorials

Step-by-step tutorials for connecting Excel, Spring Boot, Python, Power BI, Power Automate and other tools to live business data with CData connectors.

Browse by integration

  • ODBC

    Microsoft Excel

    Pull live data into Excel with SQL through Microsoft Query and a CData ODBC driver, then refresh it from the worksheet instead of exporting again.

    • Active Directory
    • Jira
    • SAP
    • SharePoint
    • Snowflake

    5 tutorials

  • JDBC

    Spring Boot

    Use a CData JDBC driver as the datasource behind a Spring Boot app and query BigQuery, Snowflake, SharePoint and other sources with ordinary SQL.

    • Active Directory
    • BigQuery
    • SharePoint
    • Snowflake
    • Sybase

    5 tutorials

  • Python

    SQLAlchemy

    Query and update live sources from Python with SQLAlchemy through CData Python connectors, with notes on cost, speed and troubleshooting.

    • Amazon Athena
    • Amazon DynamoDB
    • BigQuery
    • MongoDB
    • Snowflake

    5 tutorials

  • Power BI

    Power BI gateway

    Publish Power BI reports and keep them refreshed through the on-premises data gateway using CData Power BI connectors.

    • Active Directory
    • Databricks
    • Microsoft Dataverse
    • SAP
    • SharePoint

    5 tutorials

  • ODBC

    Python on Linux

    Connect Python on Linux to SAP, SharePoint, Dataverse and other sources with pyodbc, unixODBC and CData ODBC drivers.

    • Active Directory
    • Microsoft Dataverse
    • SAP
    • SharePoint
    • Sybase

    5 tutorials

  • Connect AI

    Power Automate

    Use CData Connect AI as a SQL Server style endpoint so Power Automate flows can read live data without copying it first.

    • BigQuery
    • Databricks
    • Jira
    • Workday
    • Xero

    5 tutorials

  • JDBC

    Azure Databricks

    Load live enterprise data into Databricks notebooks with the CData JDBC driver and process it with Spark, without copying it first.

    • Amazon Athena
    • Dynamics 365
    • Microsoft Dataverse
    • SAP
    • SharePoint

    5 tutorials

  • JDBC

    Apache Airflow

    Query live sources from Airflow DAGs with the CData JDBC driver, and handle scheduling, failures and connection setup.

    • Active Directory
    • LDAP
    • SAP
    • ServiceNow
    • SharePoint

    5 tutorials

  • ADO.NET

    PowerShell

    Script live data access in PowerShell with the CData ADO.NET provider: query into a DataTable, schedule runs and fix connection errors.

    • Jira
    • LDAP
    • MongoDB
    • ServiceNow
    • Snowflake

    5 tutorials

  • ADO.NET

    Entity Framework Code First

    Build code-first Entity Framework models over live DynamoDB, Snowflake, Databricks, BigQuery and Dataverse data with the CData ADO.NET provider.

    • Amazon DynamoDB
    • BigQuery
    • Databricks
    • Microsoft Dataverse
    • Snowflake

    5 tutorials

How these tutorials are organized

Each integration page groups the tutorials for one tool, with one tutorial for each data source we cover. Open an integration to see what the tool does with CData connectors, then pick the data source you work with. Every tutorial names its author, shows when it was last updated, and links to the driver you need to try it yourself.

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.