JDE Integration Question

Question

Hello,

We're going to be using SSIS to bring data from JDE to CRM 2011. Is there a standard for connecting to CRM 2011 from SSIS? From what I understand I'd have to create a .net Web service that encapsulates the CRM web services to integrate the data into CRM 2011.

I'm just looking for more information for best practices for intergrations. Any help would be greatly appreciated!

Thanks again

---

Jason Cosman

Answer 1

You could do it with web service tasks in SSIS but the better way is to just create a .NET assembly that does what you want using the CRM web services, and then call that assembly in SSIS.

---

Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Answer 2

Did you ever figure out how to do this?

---

Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Answer 3

The standard SSIS doesn't include functionality to connect to Dynamics CRM. I would recommend you check COZYROC SSIS+ extension library. It includes Dynamics CRM adapters and many other useful integration components. The library simplifies working with Dynamics CRM tremendously and supports all deployment types: Premise, Hosted and Live.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/