web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM Integration with o...
Microsoft Dynamics CRM (Archived)

CRM Integration with other systems

(0) ShareShare
ReportReport
Posted on by Mohammed jamous 340

hello all,

i hope you doing fine ;)

i searched all over the internet for one small help about the below problem and i really need your help on how to start this:-

i need to know how can integrate crm with ( SAP, I-Scala for example) what i mean is :-

if i entered a product in SAP then it will be enterd in CRM database and vise versa.

so basically it is syncronization between two systems.

how can i start on that?

thank you.

*This post is locked for comments

I have the same question (0)
  • alf Profile Picture
    alf 17,915 on at
    Re: CRM Integration with other systems

    Hi Mohammed,

    You have a number of options.  A couple of the most common are:

    * Use sql server integration services to create an integration that connects to sap using sap's odbc driver and crm via the sdk web services.

    * Use a 3rd party tool such as scribe

    * If all you need is the product list and there are no plans for a bigger integration then something as simple as a nightly export of products from SAP and custom develop an import routine to read this data update/insert into crm via the crm sdk.

  • Nuckles Profile Picture
    Nuckles 250 on at
    Re: CRM Integration with other systems

    Hi Mohammed,

    I'm in the process of integrating Oracle and SQL based systems and also a few Excel spreadsheets/csvs into CRM 4.0 using Scribe.  At the moment this is going one way (into CRM) but will eventually feed the other way for certain activities.  Implementing Scribe was not such a challenge as understanding the joins and queries needed to get the right answer out of the source system.  So far I have been delighted with what Scribe can do in terms of integration.

     

    Nigel

  • Mohammed jamous Profile Picture
    Mohammed jamous 340 on at
    Re: Re: CRM Integration with other systems

    thank you for your response.

    I was playing in SSIS in the last couple days .

    i think it is the solution for my problem as i only needs a 4 of 5 tables to be synchronized.

    but how can i use CRM SDK with SSIS ?

  • MercureIntegration Profile Picture
    MercureIntegration 1,725 on at
    Re: Re: Re: CRM Integration with other systems

    Yes, you can use the CRM SDK within SSIS, it's a webservice, so you should build some code (ex, in c#) to call the webservice with data from SSIS.

    The only concern about this kind of integration, is that SSIS can't do parallelism of tasks, so if you have a lot of rows in the source, each row will be processed sequentially and, because webservices can be a little slow, your integration can take a while.

    Take a look at the CRM team's blog post http://blogs.msdn.com/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx

  • Mohammed jamous Profile Picture
    Mohammed jamous 340 on at
    Re: Re: Re: Re: CRM Integration with other systems

    Wow Thank you for this Link. I read it and it is very usefull. but one point can you tell me how to import the records from CRM to the Other Systems using this same method?

  • MercureIntegration Profile Picture
    MercureIntegration 1,725 on at
    Re: Re: Re: Re: Re: CRM Integration with other systems

    You don't have to use this method because it is supported to use CRM filtered views, you just have to query the views like you would do with other systems... you have to go thru the SDK only when you want to update CRM...

  • Mohammed jamous Profile Picture
    Mohammed jamous 340 on at
    Re: Re: Re: Re: Re: Re: CRM Integration with other systems

    Okay but i don't get it ... how to to update the other system?

    can i go directly using SSIS without using the SDK?

  • Verified answer
    MercureIntegration Profile Picture
    MercureIntegration 1,725 on at
    Re: Re: Re: Re: Re: Re: Re: CRM Integration with other systems

    Yes you can use SSIS. The only requirement is that you can only execute read-only operation on the CRM database. 

    An example of this kind of integration: Each night, transfert all modified or created information since 24h to the other system, from the CRM filtered views, using SSIS.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans