apollo7
asked on
Connecting a Azure SQL database with Dynamics 365 Online
Dynamics 365 Online, CRM 2013 on prem, SQL Azure
We are upgrading a CRM 2013 system to D365 Online. The 2013 system has several SQL Procs that currently write information to the CRM 2013 system. I stood up an Azure environment and imported one SQL proc (and associated database) into Azure.
I can now query the database associated with the SQL proc, run the sp commands, query the database. It now functions like the SQL Proc and database that writes to CRM 2013
I am now not sure how to use the SQL Proc/database on Azure with Dynamics 365 Online.
How do I replicate the process where the SQL proc writes data to CRM 2013 and then use this in D365?
Is this a job for Scribe or KingswaySoft?
Please advise.
We are upgrading a CRM 2013 system to D365 Online. The 2013 system has several SQL Procs that currently write information to the CRM 2013 system. I stood up an Azure environment and imported one SQL proc (and associated database) into Azure.
I can now query the database associated with the SQL proc, run the sp commands, query the database. It now functions like the SQL Proc and database that writes to CRM 2013
I am now not sure how to use the SQL Proc/database on Azure with Dynamics 365 Online.
How do I replicate the process where the SQL proc writes data to CRM 2013 and then use this in D365?
Is this a job for Scribe or KingswaySoft?
Please advise.
ASKER
Is there another way to proceed? Would converting the SQL Procs to plugins or something that would be compatible with D365 be a better way to go?
Hello,
To export the current CRM data to Azure SQL Database you can use the CRM Data Export Service.
Regards,
Pratik
To export the current CRM data to Azure SQL Database you can use the CRM Data Export Service.
Regards,
Pratik
When people write SQL apps they tend to forget D365 constraints hence I am not sure if those queries can be translated to Plugins. You will have to go case by case i.e. take a query check it's feasibility to be converted to a Plugin.
PS: Data Export Service is used to - as the name suggests export data out of CRM, it cannot be used to write data to Dynamics 365 Online.
PS: Data Export Service is used to - as the name suggests export data out of CRM, it cannot be used to write data to Dynamics 365 Online.
ASKER
I have looked at this, I also need to export data from the non-CRM data generated by the SQL Proc to CRM
How your non-CRM data is generated? And what is the volume of such data?
ASKER
Depends on the stored proc, it generally gathers data from an external source (Like an aspx app), processes it and then writes it to CRM. Some of the stored procs generate a great deal of data and run at a scheduled time.
To export non CRM to CRM you can use Azure Data Factory V2.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can Azure Data Factory V2 do bi-directional like Scribe? Would connectors to CRM need to be custom-developed? What do you think Azure Data Factory V2 does better than Scribe or similar tools?
Thanks
Thanks
And for those single records, you should call CRM Apis and insert the records.
ASKER
Thanks, Chinmay. I have been wanting to get involved with Kingswaysoft.
That's the right call. I think Scribe is a good solution in general, but if I have to do something that involves data migration I would go with Kingswaysoft.
ADF V2 has a connection to CRM. You just need to configure the link details.
ASKER
Thanks for the answers.
Yes. What you want to achieve is totally unsupported On Premise and there is no direct way to do this for D365 Online.
You will have to either go with Scribe and Kingswaysoft. Or a custom developed tool.
Regards,
Chinmay.