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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chinmay PatelChief Technology NinjaCommented:
Hi apollo7,

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.

apollo7Author Commented:
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?
Pratik SomaiyaApplication Development AssociateCommented:

To export the current CRM data to Azure SQL Database you can use the CRM Data Export Service.

Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Chinmay PatelChief Technology NinjaCommented:
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.
apollo7Author Commented:
I have looked at this, I also need to export data from the non-CRM data generated by the SQL Proc to CRM
Chinmay PatelChief Technology NinjaCommented:
How your non-CRM data is generated? And what is the volume of such data?
apollo7Author Commented:
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.
Pratik SomaiyaApplication Development AssociateCommented:
To export non CRM to CRM you can use Azure Data Factory V2.
Chinmay PatelChief Technology NinjaCommented:
I think you should try and use Kingswaysoft for this requirement. You will have to think of the cost of running stuff entirely in cloud or from on premise. Also, if you need to insert related records or need better control over the process, using the Kingswaysoft adapter is a better choice.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
apollo7Author Commented:
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?

Chinmay PatelChief Technology NinjaCommented:
And for those single records, you should call CRM Apis and insert the records.
apollo7Author Commented:
Thanks, Chinmay.  I have been wanting to get involved with Kingswaysoft.
Chinmay PatelChief Technology NinjaCommented:
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.
Pratik SomaiyaApplication Development AssociateCommented:
ADF V2 has a connection to CRM. You just need to configure the link details.
apollo7Author Commented:
Thanks for the answers.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.