Schedule - Import Data into CRM Online from On-premises SQL Server RRS feed

  • Question

  • Hi All,

    We are planning to subscribe to Microsoft CRM Online and want to import data from our SQL server which On-premises. I'm looking at automating this process so Microsoft CRM can refresh data from SQL at regular interviews.

    Could guide how this can be achieved.


    Sunday, May 17, 2015 2:59 AM

All replies

  • Hi,

        As you are trying to export from on-premise SQL to on-line CRM, you can use custom SSIS connector like CozyRoc / Kingsway soft for this. It would be possible to schedule SSIS on regular basis to export data from custom SQL database and refresh the data in CRM.

        You can also use Scribe connector for this.

    Hope this helps.
    Minal Dahiya
    blog : http://minaldahiya.blogspot.com.au/

    If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"


    Monday, May 18, 2015 12:56 AM
  • Thanks Minal. Is there any utility or connector from Microsoft?



    Thursday, May 28, 2015 1:31 AM