Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Import data from existing table on sql server(created manual) to custom entity RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    I have  a table on Sql Server  and I created it manual. How can import data from that table into custom entity which I created on Crm 2011

    Friday, December 28, 2012 1:45 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    If you don't want to import the data using a file - you would need to write some custom code using the SDK to read your table and create the records programmatically.

    Microsoft Dynamics CRM 2011 Software Development Kit (SDK)

    Another choice would be to use a third party tool to integrate the data:

    Integrate Microsoft Dynamics CRM

    If you can continue to maintain this data outside CRM - you can also reference the SDK and create a Silverlight application which can run inside CRM that interacts with the data in your other database.

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Friday, December 28, 2012 3:04 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    The only option you have to import data into crm is by the webservices - don't write directly to crm database. You can implement a console application which loads the data from the sql table and saves the loaded data in crm - this console application can be sheduled on server...

    Best regards,

    Andreas

    Andreas Buchinger
    Microsoft Dynamics Certified Technology Specialist
    MCPD: SharePoint Developer 2010

    Friday, December 28, 2012 3:06 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    How can I  import or pull  data  into custom entity from existing table (created manual )on sql server
    Friday, December 28, 2012 1:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Here you have a great guide to import data:

    http://garethtuckercrm.com/2010/11/04/crm-2011-new-features-data-import/

    You have to pass your table to excel or csv. If it is a repeated action you can use sdk to do that, see here:

    http://technet.microsoft.com/en-us/library/gg328321.aspx

    Hope this helps.

    If i answered your question, please mark the response as an answer and also vote as helpful.

    Pedro Azevedo Crm Specialist 4.0\2011

    • Proposed as answer by Azevedo PedroMVP Friday, December 28, 2012 2:01 PM
    • Unproposed as answer by dagurkuden Friday, December 28, 2012 2:33 PM
    Friday, December 28, 2012 2:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Actually it s not my questions answer:( I dont want to import data csv xml etc.

    Thats the problem.I have a  SQL Server  by using   a WEB application and CRM server  on the same time.

     I created a table that name is ABC  .Data are coming from web application. I m holding data on ABC table.

    And I want to see data  on CRM screen.I m trying to create custom entity  name is same with  table name(ABC) 



    Friday, December 28, 2012 2:16 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you don't want to import the data using a file - you would need to write some custom code using the SDK to read your table and create the records programmatically.

    Microsoft Dynamics CRM 2011 Software Development Kit (SDK)

    Another choice would be to use a third party tool to integrate the data:

    Integrate Microsoft Dynamics CRM

    If you can continue to maintain this data outside CRM - you can also reference the SDK and create a Silverlight application which can run inside CRM that interacts with the data in your other database.

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Friday, December 28, 2012 3:04 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    The only option you have to import data into crm is by the webservices - don't write directly to crm database. You can implement a console application which loads the data from the sql table and saves the loaded data in crm - this console application can be sheduled on server...

    Best regards,

    Andreas

    Andreas Buchinger
    Microsoft Dynamics Certified Technology Specialist
    MCPD: SharePoint Developer 2010

    Friday, December 28, 2012 3:06 PM