IntegrationConnect AI/5 tutorials

Power Automate data integration tutorials

Tutorials for using live Databricks, Jira, Workday, BigQuery and Xero data in Power Automate flows through CData Connect AI and the SQL Server connector.

What this integration does

Microsoft Power Automate runs workflows across apps and services. Its SQL Server connector lets a flow query a database, which is useful when the data you need to act on lives in a system that has no connector of its own, or only a limited one.

How CData fits in

CData Connect AI exposes a source such as Workday or BigQuery as a SQL Server style endpoint in the cloud. A flow uses the ordinary SQL Server actions against it and reads live data without replicating it first. The tutorials cover setting up the connection, scheduling flows, controlling access, and choosing between connection options.

Power Automate 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.