Notifications
Announcements
No record found.
Dear all,
I am searching for the best practise to integration sql database and 365 on premise(two ways integration) and it should be synchronous. i was thinking about SSIS or sql triggers by calling D365 api. no need for paid solutions.
any suggestion please.
with regards.
Dear Partner,
Multiple ways like SSIS, Kinfsway soft or Muelsoft can be used its completly depend on your requirement.
Regrads,
Mohamed Sanuj Basheer
Dear,
if i want to go with ssis solution, how to run the deployment synchronously(once create or update a record)?
as i know, i need to schedule the packages (asynchronous).
regards,
Hey Ibrahim,
One of the options that I can think of would be the SQL server replication feature.https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver15
Sharing Data across Microsoft Dynamics CRM Deployments ::https://cloudblogs.microsoft.com/dynamics365/no-audience/2010/03/23/sharing-data-across-microsoft-dynamics-crm-deployments/
Here is an example of doing this with Azure SQL DB ::https://community.dynamics.com/crm/b/nishantranaweblog/posts/using-sql-server-transactional-replication-to-move-data-from-sql-server-on-prem-to-azure-sql
A related community thread where some other options were being talked about ::https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/110758/sync-framework-to-update-external-database?pifragment-97030=1
Please mark my comments as answered if this helps. Thanks,
Saurabh
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 96 Super User 2025 Season 2
Jimmy Passeti 50 Most Valuable Professional
Gerardo RenterÃa Ga... 49 Most Valuable Professional
