CRM2016 on Premises
This is probably not the right way to go about things, but I have limited experience. We have a legacy SQL system that is receiving 1000 + records per day. I need to get those records into CRM in real-time and automated. I have been looking / trying to generate a SQL CLR route using Visual Studios 2017 Database project. I have been steered to looking at creating a WCF service, but with limited experience I'm at a loss.
Looking at the code samples in the SDK .. they all appear to use an app.config file, which I can just about follow, however in the Database projects, I cannot see how to add an app.config file.
The way I though it 'should' work is that when a record is added to the legacy SQL, a trigger would call the SQLCLR function . This ( if I can connect to the CRM server) could use the normal methods to create records in the CRM entities. I am not looking to use methods that are not supported.
The only other way I can see to proceed is to create a business intelligence solution, unless anyone can spare a little time to get me started on a different method.
*This post is locked for comments
I have the same question (0)
