SQL databse to Dataverse tables?

[Oskarkuus]

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?

[bipinshan]

Hi @Oskarkuus ,

Virtual connector for SQL can also be used for your scenario

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-virtual-tables-using-connect...

[Oskarkuus]

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?