locked
Integration to MS SQL RRS feed

  • Question

  • Hi,

    at the moment i'm trying to develop a interface from MS CRM 4.0 to a MS SQL database. But I'm quite inexperienced. I mean, I have already worked with the .Net and the CRM System. However I asked myself if it ist possible for me to to such a interface.
    Are there any provided interfaces? Or should I use the web services like crmServices a.s.o.? I have already read some books about MS CRM 4.0, but they don't focus on integration. Is there any special guide for integration to SQL database of Microsoft.

    Thank you for you answers!
    Thursday, February 11, 2010 1:24 PM

Answers

  • Hi Martin,

    If I understand correctly, you would like to integrate CRM with information from a separate SQL database.

    1. There are tools available (a bit pricey) from companies like Scribe (Scribesoft) or Nolan Software that can perform regular integrations.
    2. If the goal is just to provide a window to that information in the other database, but not to interact with it inside of CRM, you can create a custom "view" - make an ASPX webpage that can be displayed on a form through an ISV.CONFIG customization, which then retrieves and displays the relevant information from your other database.
    3. You can also write your own integration using the CRM SDK, if you want to actually move the information from the other database to the CRM database, and from the CRM database to the other database. When touching the CRM database, the only supported way to do so is through the APIs.

    Hope this helps!
    Web: http://invoc.net Blog: http://invoc.net/CRM_BPOS_Blog
    Thursday, February 11, 2010 1:32 PM

All replies

  • Hi Martin,

    If I understand correctly, you would like to integrate CRM with information from a separate SQL database.

    1. There are tools available (a bit pricey) from companies like Scribe (Scribesoft) or Nolan Software that can perform regular integrations.
    2. If the goal is just to provide a window to that information in the other database, but not to interact with it inside of CRM, you can create a custom "view" - make an ASPX webpage that can be displayed on a form through an ISV.CONFIG customization, which then retrieves and displays the relevant information from your other database.
    3. You can also write your own integration using the CRM SDK, if you want to actually move the information from the other database to the CRM database, and from the CRM database to the other database. When touching the CRM database, the only supported way to do so is through the APIs.

    Hope this helps!
    Web: http://invoc.net Blog: http://invoc.net/CRM_BPOS_Blog
    Thursday, February 11, 2010 1:32 PM
  • Hi Andy,

    at first glance, I'd like to thank you for the answer.

    Actually I will develop the interface from CRM to Database and from Database to CRM. Is there any chance to expose some code examples for developing a interface?


    Thursday, February 11, 2010 2:41 PM