Sign in

Microsoft.com

Microsoft

Remove From My Forums

CRM Web Services?

Question
0

Sign in to vote

Hello,

I have a scenario where I have to push data into CRM from an application on a different SQL Server. Can I push the data into CRM using stored procedues or should I use the CRM web services to accomplish this task?

Any help appreciated!
Thanks in advance.

Mark

Wednesday, February 4, 2009 11:05 PM

Answers

0

Sign in to vote
You should use the MS CRM Webservice. When you bypass the webservice you bypass the security and any custom logic you have implemented OR you will implement in the future in the form of Plug-ins. Also the webservice takes care of a lot of things for you. Like generating new GUIDs ensuring you enter data in the correct format.

Hassan.
- Proposed as answer by Hassan Hussain Thursday, February 5, 2009 9:34 AM
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Thursday, February 5, 2009 12:16 AM
0

Sign in to vote
CRM web service would be ideal to use in this kind of scenario. Create a simple C# application and connect to CRM server using CRM SDK web service to push the data to CRM.

Download CRM SDK from http://www.microsoft.com/downloads/details.aspx?familyid=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en which will helpful tool in creating this sample application.
- Proposed as answer by Mayank PujaraEditor Thursday, February 5, 2009 9:06 AM
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Thursday, February 5, 2009 9:06 AM

Answerer
0

Sign in to vote
Hi Mark

Take a look at http://www.xrmlinq.com it's a LINQ library for CRM, it's not free though, however http://www.codeplex.com/linqtocrm/ is an opensource project.
http://www.xrmlinq.com
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Monday, February 9, 2009 10:21 AM

All replies

0

Sign in to vote
You should use the MS CRM Webservice. When you bypass the webservice you bypass the security and any custom logic you have implemented OR you will implement in the future in the form of Plug-ins. Also the webservice takes care of a lot of things for you. Like generating new GUIDs ensuring you enter data in the correct format.

Hassan.
- Proposed as answer by Hassan Hussain Thursday, February 5, 2009 9:34 AM
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Thursday, February 5, 2009 12:16 AM
0

Sign in to vote
CRM web service would be ideal to use in this kind of scenario. Create a simple C# application and connect to CRM server using CRM SDK web service to push the data to CRM.

Download CRM SDK from http://www.microsoft.com/downloads/details.aspx?familyid=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en which will helpful tool in creating this sample application.
- Proposed as answer by Mayank PujaraEditor Thursday, February 5, 2009 9:06 AM
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Thursday, February 5, 2009 9:06 AM

Answerer
0

Sign in to vote
Hi Mark

Take a look at http://www.xrmlinq.com it's a LINQ library for CRM, it's not free though, however http://www.codeplex.com/linqtocrm/ is an opensource project.
http://www.xrmlinq.com
- Marked as answer by Donna EdwardsMVP Wednesday, May 20, 2009 1:23 PM
Monday, February 9, 2009 10:21 AM