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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Best tool to Integrate...
Microsoft Dynamics CRM (Archived)

Best tool to Integrate DB2 to CRM 2013

(0) ShareShare
ReportReport
Posted on by Wani 80

I was given a task to find out the best tool for integrating DB2 (has about 5 Millions records) to SQL 2012 (CRM 2013).

DB2 sends through customer names and contact details to SQL and every time a customer details has changed ,it will then update SQL. This could be 10,000 records max a day. It's one way communication because CRM will not send back anything to DB2. However I need to make sure that the GUID will be generate correctly to CRM.

I have done a research and found:

- 1. Via Web service  

- 2. SSIS and use SDK to call a function to generate GUID

- 3. CRM Import Manager

- 4. Scribe (but prefer not to as it 3rd party product)

Could anyone point to the best one that will definitely give GUID without affecting CRM performance please?

Help please

Wani

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rugved Gokhale Profile Picture
    Rugved Gokhale on at

    Hi,

    If you are trying to migrate data, its not just about creating & attaching a GUID. When you create records using crm organization services you will anyways get a GUID attached to your newly created data as a primary key.

    To effectively migrate data, check first what & where this will be mapped in CRM, how referenced data (like a foreign key reference or reference to different entity) will be migrated, any special logic or manipulations are required before pushing it to CRM etc,

    Once all these is finalized, you can take decision based on these calculated requirements. Generally, if there are many manipulations are required to suite it to CRM, before pushing data, handling these with custom developed utility in scheduled intervals & pushing data via OrganizationService is effective. Just that in case of custom utility, try to use "ExecuteMultipleRequest" to make your life simpler.

    Regards,

    Rugved Gokhale

  • Wani Profile Picture
    Wani 80 on at

    Thanks Rugved.

  • Community Member Profile Picture
    Community Member on at

    Hi Wani,

    What did you end up going with, if you don't mind me asking?

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans