Log på
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Importing data and assign it every x minutes

Answered Importing data and assign it every x minutes

  • 13. februar 2009 10:47
     
     
    Log på for at bedømme
    0

    Hello
    I want to import data from an ERP-System. I can export the data from the
    ERP-System in XML,TXT or CVS Files.
    How can I make a continal import to the CRM 4.0 System.
    Are there any example available ?
    What is the right solution. Plugin, Windows Service with CRM-Sdk, SQL Server SSIS.

    Thanks for any information
    stony

     

Alle besvarelser

  • 13. februar 2009 17:37
     
     
    Log på for at bedømme
    0
    You can use SSIS, custom app with CRM SDK, but not plugin.
    Ronald
     
  • 13. februar 2009 20:21
     
     
    Log på for at bedømme
    0
    Hi Stony,

    No right answer, but I typically go with a windows service. No doubt you'll have some inserts that fail for whatever reason and easiest way to debug and re-submit is using .NET code.

    You'll want an interface and notification system to handle any failed submits.

    HiH,

    Karlo
    Karlo Swart - http://www.ver206.com
     
  • 14. februar 2009 12:53
     
     Svar
    Log på for at bedømme
    0
     If you are in a real hurry you can cut development time by utilizing the windows tasks scheduler. The scheduler allows you to run a task (exe) every few minutes. I suggest creating a console application and focus your development effort on the import and logging process.
     
  • 15. februar 2009 17:57
     
     
    Log på for at bedømme
    0
    Windows service sounds good, or if buying a product is an option check out Import Manager 2008 which is a finished product for syncing data to CRM.