
Select "SAP Business One" from Available Data Sources.Įnter the necessary authentication properties to connect to SAP Business One.Login to Connect Cloud and click Databases.CData Connect Cloud looks exactly like a SQL Server database to Power Automate and uses optimized data processing out of the box to push all supported SQL operations (filters, JOINs, etc) directly to SAP Business One, leveraging server-side processing to quickly return SAP Business One data.Ĭreate a Virtual SQL Database for SAP Business One DataĬData Connect Cloud uses a straightforward, point-and-click interface to connect to data sources and generate APIs.

This article shows how to connect to Connect Cloud from Power Automate and integrate live SAP Business One data into your workflows and tasks.ĬData Connect Cloud provides a pure SQL, cloud-to-cloud interface for SAP Business One, allowing you to easily integrate with live SAP Business One data in Power Automate - without replicating the data. When paired with CData Connect Cloud, you get instant, cloud-to-cloud access to SAP Business One data for visualizations, dashboards, and more.

Power Automate (Microsoft Flow) is an online service that automates events (known as workflows) across the most common apps and services.
