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 365 | Integration, Dataverse... / nightly copying data f...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

nightly copying data from Oracle database on premise to Dynamics 365 on Azure cloud

(0) ShareShare
ReportReport
Posted on by SivaR 69

Hi
We have a core person data that exist on the Oracle database on-premise. Somehow we need to refresh (copy ) the core person data into Dynamics 365 on Azure cloud.

How i can achieve this?
Normally if we want to connect to the oracle database, we use port, host, SID information to connect to the Oracle database from other servers or systems and get the required data.
Can we use the Oracle connection information to configure it from dynamics 365 to retrieve data from the Oracle database on premise to the cloud?
Is there any connector available to refresh data from the Oracle database to D365 on  the Cloud by using just the Oracle connection string (Host, port and SID)?

I have the same question (0)
  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,321 on at

    Hi,

    It seems you need to copy data from Oracle Database (on-premise) to Dynamics 365 (cloud).

    For this purpose, I would suggest using Microsoft Flow.

    Microsoft Flow has connectors available for Oracle (on-premise) and Command Data Services (D365). One can easily configure these connectors and data starts flowing based on a trigger (or schedule).

    You can see Oracle connectors here:

    docs.microsoft.com/.../

    To connect the Microsoft Flow with Oracle on-premise, you have to configure an on-premise gateway in your network (so Flow can connect Oracle DB)

    If you need to load legacy data, a simpler approach would be to export data from Oracle in flat text file(s) or CSV and use Microsoft Dynamics 365 import:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/import-accounts-leads-other-data

    Let me know if you need more details.

    Best,

    Wahaj

  • Elijah Stownton Profile Picture
    Elijah Stownton 192 on at

    You can use the Skyvia cloud platform to connect Oracle and Dynamics 365. It is a freemium app with no code. Read more here

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 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 41 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 39

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans