Hello guys,
I have a problem, How to export CRM data in an entity to MySQL (through API) ? The example is if i want to export data at Case/Incident Entity to MySql database. What should i do?
Thank you.
*This post is locked for comments
Summarizing all that have been said, 2 options seem to be the most evident:
1. You can either use SSIS connectors. There are plenty of providers like Kingswaysoft or Devart, for example.
2. For simplicity you can try 3rd party ETL tools, like Skyvia or Scribe.
How about using Microsoft Flow? Use the button to set a flag on the Case (new_exporttosql = true) and then have the flow run on Update of record. Once you're on V9 you should be able to do away with the flag and instead run the flow directly from the Flow ribbon button.
Agree with Aric, why do not you use some 3rd-party tools?They can make your entire data life much easier.
If you don`t like Kingswaysoft (I agree, it can be difficult for some users), there are dozens of alternatives, for example, Skyvia.
Why not use SSIS with Kingswaysoft Dynamics CRM Connector.
You can have CRM as your source data and MySQL can be your target. For MySQL, you can probably use ODBC or one of the available connections.
Here are the links to both product options:
www.kingswaysoft.com/.../download
blogs.msdn.microsoft.com/.../connecting-to-mysql-from-ssis
This will probably be much easier than any custom development solution.
Hope this helps.
You Need to create Asp.net web api and call it from the CRM.
Take the help from the SDK examples , which contains all c# codes .
adjust that as per your requirement.
for any operation we need , credentials , connectivity to the environment.
code will do it's work.
Create the Connectivity to the custom c# code through your button
fetch data of case/incident and send to mysql.
or create the web api and connect via delegate user to crm and on button click on crm do your operation.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
