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 / Customer experience | Sales, Customer Insights,... / CRM Online & Oracl...
Customer experience | Sales, Customer Insights,...
Suggested Answer

CRM Online & Oracle On premise Integration

(0) ShareShare
ReportReport
Posted on by VenkataSambasivaRao K 905

Dear Team,

I need suggestion on the below integration.

We are implementing Dynamics 365 CRM Online and client is having Oracle On premise and wants to integrate with CRM online in real time.

And the data is basically flowing from CRM to Oracle and Oracle to CRM.

So can i have what are the best possibilities for CRM Online and Oracle On premise real time integration.

I have the same question (0)
  • Suggested answer
    Johnny Gong Profile Picture
    Johnny Gong 6,482 Moderator on at

    Hi VenkataSambasivaRao，

    There are several tools or media could help do data migration between D365 Online and Oracle OP. I would recommend SSIS and Azure Data Factory.

    1. SSIS: You can set Source Data as Oracle and D365 Destination for data migration

    Download link: www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm

    Recommend Thread could be for your reference:

    community.dynamics.com/.../crm-2016-online-integration-with-oracle

    community.dynamics.com/.../769279

    www.itaintboring.com/.../

    Video Guide: www.youtube.com/watch

    Azure Data Factory

    Integrate with D365: docs.microsoft.com/.../connector-dynamics-crm-office-365

    Integrate with Oracle: docs.microsoft.com/.../connector-oracle

    Hope above would help.

    Regards

    Johnny

  • VenkataSambasivaRao K Profile Picture
    VenkataSambasivaRao K 905 on at

    Dear Johny,

    Thanks for the information.

    These SSIS and Azure Data Factory will work for real time or in a batch process. Can you also please share the information.

    And also can you please let me know if we want to use REST Web API what will be the alternatives or suggestions for real time data.

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    For Real time integration, You can create web hooks.

    Web hooks trigger on an event like create, update etc.

    docs.microsoft.com/.../use-webhooks

  • VenkataSambasivaRao K Profile Picture
    VenkataSambasivaRao K 905 on at

    Dear Johny,

    I can create Webhooks for CRM but from Oracle side if they dont expose any thing then what will be the alternative.

  • Bobby 123 Smith Profile Picture
    Bobby 123 Smith 5 on at

    Hello! You can use Skyvia — it allows you to integrate Dynamics 365 and Oracle with ease: skyvia.com/.../integrate-dynamics-crm-oracle. You can set the frequency of data updates — for example, once a minute. A free plan with 10000 loaded records per month is available. But in a free plan, you can have updates only once a day.

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 > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans