You’re offline. This is a read only version of the page.
Hi,
Our CRM Dynamics systems is on Microsoft Online System.
It is CRM 365.
How do I connect to the SQL Database of the Online CRM?
Thanks,
*This post is locked for comments
This feature is in preview, however it has worked find for me, check the following link:
Skyvia is a good option when you need to connect cloud with on-premise data sources and keep data updated on a regular basis. I like its friendly interface and mapping options. We used Skyvia to sync Dynamics CRM with MySQL database, but I think it will also work well with SQL Server. Read here.
To connect your SQL Database with Online CRM you can use different SSIS or Cloud-Based No-coding solutions.
I prefer cloud-based services `cause they usually don't require coding knowledge and manual installations. I am personally using Skyvia - a powerful tool with flexible scheduling and broad mapping features and with intuitive design
Hello
Tenfold just recently added MS office to their integrations list. Tenfold offers features such as click to dial, automatic call logging, easy note taking and task creation, screen pops on inbound and outbound calls, new lead/contact creation when no matching records, support for cases/opportunities and advanced analytics on the backend. They also support MS Dynamics integration
Hi RCP,
This is a tool used for SSIS usage.
You need to identify first what you really need to do, update with processes;export/import data; etc so as to be able to help you better.
Thank's,
Alexandros
I tried to connect using Power BI and it worked.
I can see the data, though I can't modify.
Thanks to everyone for your help
For reporting you cannot access the SQL server editor, however you can do reports using fetch XML. Additionally since you are using power BI, you can design your queries there.
www.microsoft.com/.../dynamics-365-online-vs-on-premises-features-faq.aspx
Alexandros is correct however you could also consider using the Data Export Services
msdn.microsoft.com/.../mt788315.aspx
Joe
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (