Customer experience | Sales, Customer Insights,...

CRM Online & Oracle On premise Integration

(0) Share

Report

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)

All responses (5)

Answers (0)

Bobby 123 Smith 5 on at

Like (0)

Report

RE: CRM Online & Oracle On premise Integration

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.

Was this reply helpful? Yes No
VenkataSambasivaRao K 905 on at

Like (0)

Report

RE: CRM Online & Oracle On premise Integration

Dear Johny,

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

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: CRM Online & Oracle On premise Integration

For Real time integration, You can create web hooks.

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

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

Was this reply helpful? Yes No
VenkataSambasivaRao K 905 on at

Like (0)

Report

RE: CRM Online & Oracle On premise Integration

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.

Was this reply helpful? Yes No
Suggested answer

Johnny Gong 6,482 Moderator on at

Like (0)

Report

RE: CRM Online & Oracle On premise Integration

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

Was this reply helpful? Yes No

Community site session details

CRM Online & Oracle On premise Integration

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

CRM Online & Oracle On premise Integration

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates