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:
docs.microsoft.com/.../dataverse-sql-query
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
I'm facing an issue to connect our CRM 365 to Power Bi. can you give me a tip to do that ?
Thanks
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
www.tenfold.com/.../microsoft-office-365
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
Also found this - www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm
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
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 Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
Christoph Pock 1
