locked
Use CRM Web Service to add data RRS feed

  • Question

  • Hello,

    I was wondering if anyone could tell me how to automatically insert data into CRM 4.0.

    I'm in cahrge of creating an interface and everytime new data arrives it shoul be inserted into CRM 4.0.

    What is the best way to achieve this?

     

    Thanks in advance,

    Jeppen

    • Edited by Jeppen Thursday, February 10, 2011 11:27 AM
    Wednesday, February 9, 2011 2:43 PM

Answers

All replies

  • Using Tools > Import Data or... adding it programmatically, on demand, using JavaScript: http://www.bizforward.cws-international.com/2011/01/26/creating-records-in-crm-2011-using-javascript/
    Cornel Croitoriu - Senior Software Developer - www.Biz-Forward.com
    Wednesday, February 9, 2011 2:46 PM
  • You can import data into crm using:-

    1. Biztalk

    2. Scribe

    3. SSIS

    4. Import functionality of CRM

    5. Data Migration Manager

    6. Using custom code.

    To find out the best way you have to evaluate:-

    1. frequecy of Import

    2. Size of Data

    3. Avaialable resources.

    4. Notification for success or failure

     

     

     


    Regards Faisal
    Wednesday, February 9, 2011 2:53 PM
  • My objective is to insert a new record into a database "on demand". This means a new record should be created when the user click "Yes" on a aspx page.

    So I gues it would be best to do it via Code. I use the webservice.

    Besides the example shown by Cornel does anyone has another example of how to proceed for inserting a new record into a custom entity.

     

    Thanks in advance,

    Jeppen

     

    Thursday, February 10, 2011 11:27 AM
  • On button click you can use this method to create a record in CRM http://msdn.microsoft.com/en-us/library/bb928994.aspx

     


    Regards Faisal
    • Proposed as answer by Amarsen Vangoor Thursday, February 10, 2011 12:40 PM
    • Marked as answer by Jeppen Thursday, February 10, 2011 1:27 PM
    Thursday, February 10, 2011 12:31 PM
  • Thank you very much for your help.

     

    This help me solving the issue.

     

    Best,

    Jeppen

    Thursday, February 10, 2011 1:27 PM
  • Hello

    As so far I know, for real time/ batch data upload with CRM system, ther are 4 tools available:

    1. BizTalk server (using adapters)

    2. SSIS packages(comsuming web services)

    3. Custom code (accessing the web services)

    4. Or mixing up two of above tools (like ASP.NET code and SSIS / SSIS and SQL procedures / ASP.NET code and SQL procedures etc.)

    Is there is any other tool aviablable for that.

    I am concerned about data coming from a different source system in the format of Excel, CSV, XML, SQL queries etc. and those data needs to be updated automatically into CRM system (not one time data upload).

    It would be helpful if I get more information on that.

    Regards

    Joon

    Monday, March 7, 2011 2:07 PM