I am new to the Power Platform. I have a business requirement to flow data in CDS to a SQL Sever database. I need to know the possible options and which is the best way to flow bulk data from CDS to SQL Server. It would be great if the data flow could be scheduled as well.
In addition, I think the Data Integration project in PowerApps could also help achieve your needs. On your side, you could consider create a Data Integration project within your PowerApps Admin Center, to sync data from your CDS Entity to your SQL Table.
More details about creating a Data Integration project in PowerApps, please check the following article:
Yeah, you are right. Currently, the "CDS To SQL Server" template is not supported within Data Integration Project in PowerApps currently.
I afraid there is no way to sync data from CDS Entity to SQL Table directly using Data Integration Project in PowerApps.
As an alternative solution, I think Microsoft Flow could achieve your needs. Please consider take a try with above flow configuration I provided, then check if the solution is helpful in your scenario.
Community Support Team _ Kris Dai If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.