cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Super User
Super User

SQL databse to Dataverse tables?

I have a databse in SQL.

I have several tables i want to sync to dataverse.

I want the data in the sql tables to be mirrored in the dataverse tables.

 

What is the best approach?

I have setup a flow to do this, every hour import all data to dataverse and update each row.

 

But i am wondering if there is a better way than using power automate?

Can i utilize dataflows?

 

2 REPLIES 2
bipinshan
Solution Sage
Solution Sage

Oskarkuus
Super User
Super User

Bit late but i havent explored this topic much since i posted.

I am still a bit unsure about this.

 

Atm i have setup a few flows in power automate that fetch all data from sql, creates or updates it in dataverse. this sync is run every day.

 

I could use virtual tables

 

But id like to get answers to these questions first:

1. Is it a two way sync - if value is updated in virtual table in dataverse will it update in sql and vice versa?

2. If i create more columns in the virtual table, will those sync to sql table?

3. If a new column is created in sql table, will that be synced automatically to dataverse virtual table?

4. If a row is deleted in either sql table or dataverse table, will that sync both ways?

 

Another option i think  can use is Dataflows

 

But how does dataflows compare to virtual tables and having flows running?

 

 

 

Oskarkuus_1-1674394079747.png

Oskarkuus_0-1674393947904.png

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,460)