crm intgertaion with external system using ssis RRS feed

  • Question

  • Dear all;

    is it possible that i can integrate the mscrm system to external system using ssis package real time like if i create record in mscrm it goes to the external system using ssis package


    Tuesday, September 29, 2015 7:25 AM

All replies

  • Yes, it is possible to achieve this and either you could write everything from scratch (API call in SSIS Package) or use some external tools to help with you with this. so some of options for this are mentioned below...

    1.        Bespoke
    2.        Kingswaysoft
    3.        Scribe

    My Blog
    Follow Me on Twitter

    Tuesday, September 29, 2015 9:34 AM
  • Real time copying to another system is possible but it will potentially impact performance.

    Since the data is in a sql server database, you can use standard sql mechanisms including triggers.

    You could start up an ssis job from such a trigger, or write away lists of changed table/record ids using triggers then run a batch job every so often to pick the data up.

    Another way would be to use log shipping, which is near real time rather than absolutely real time.

    That's the way I'd consider first.

    Every update to an entity goes through a pipeline.

    You can register a piece of code to run and specify which entities to run it for.

    I wrote a plug-in some time ago which was used to produce a changes audit trail for all entities.

    You could use that approach to write all changes away to another database.

    Tuesday, September 29, 2015 3:38 PM