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
BigQueryBigQuery in Power Automate: Three Ways to Read Your Tables
Compare calling the BigQuery REST API, using a catalog connector, and querying BigQuery as a SQL Server database through CData Connect AI, then set up the SQL route.
DatabricksRun a Power Automate Flow on Live Databricks Rows
Add a Databricks cluster to CData Connect AI, connect Power Automate through a SQL Server connection, and build a flow that reads filtered rows live.
JiraSchedule a Daily Jira Time Report in Power Automate
Build a Power Automate flow that queries Jira issues and logged time through CData Connect AI on a schedule, with a dedicated token and a plan for the day it fails.
WorkdayReading Workday from Power Automate Without Widening Access
A security-review guide to using Workday in Power Automate through CData Connect AI: API client scopes, user-level access, token handling and a sign-off table.
XeroXero Data in Power Automate: Setup Questions Answered
Answers to common questions about reading Xero data in Power Automate flows through CData Connect AI, from OAuth sign-in and tokens to tables and rate limits.
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.