locked
importing data from a sql data source? RRS feed

  • Question

  • Is there a simple way of importing data from a sql data source, into a crm custom entity? All of the imports I have done in the past have been froma csv file data source. I know I could export the sql table to csv and then import into crm using the data migration tool, but I need to do this as a nightly batch job and going via a csv file seems a bit silly. Any ideas?

    Wednesday, June 18, 2008 1:07 PM

Answers

  • You can develop your own custom integration tool, or look into a 3rd-party integration app like Scribe or Pervasive, which both have connectors for CRM.

    Wednesday, June 18, 2008 3:32 PM
    Moderator

All replies

  • You can develop your own custom integration tool, or look into a 3rd-party integration app like Scribe or Pervasive, which both have connectors for CRM.

    Wednesday, June 18, 2008 3:32 PM
    Moderator
  • you need to write your program reading data from csv or sql data source and import it.

     

    You can use utility I had made for importUtility (it can be accessed from sql data source to ms crm _

     

    Regards,

    Imran

     

    msn :  mscrmexpert@gmail.com

     

     

    Wednesday, June 18, 2008 5:04 PM
    Moderator