Hi
I have custom table in Dataverse . I want to synchronised/replicate my custom table with external sql server table . How I can achieve that ?
So basically if something gets changed or add to my external sql server , my custom table in Dataverse should update as well .
Thanks
Hemisha
Hi,
You can configure virtual connector data source. Please see below link
learn.microsoft.com/.../create-virtual-tables-using-connectors
Hi Bipin,
I have tried to create virtual connection but I am getting bellow error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) clientRequestId: xxxxxxxxxxxxx
Do I need to change anything in my firewall to allow CRM to connect ?
You can use Skyvia platform to replicate the SQL server to Dataverse. it is a no-code freemium platform.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 117 Super User 2025 Season 2
MVP-Daniyal Khaleel 115
Erin Lubben 66
