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) / Data Integration betwe...
Microsoft Dynamics CRM (Archived)

Data Integration between MS Dynamics Online and on-premise Oracle

(0) ShareShare
ReportReport
Posted on by ljacob 12

Hi Team:

Currently we have SSIS jobs that download and upload data between salesforce and on-premise oracle using a WSDL based connector. Now we want to replace Salesforce with MS Dynamics 365 online. Please keep in mind that i need to download Dynamics entities as well as update Dynamics entities (bi-directional data sync). What is the best option in your experience to connect to Dynamics via SSIS. I am trying to avoid third party connectors like kingsoft etc. if possible .

Thanks,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    JandostKhoso Profile Picture
    JandostKhoso 266 on at

    Hi

    I think you will have the following options:

    1. You can use Power Platform and CDS to define a connector to do the sync.

    2. You will need to create a custom component. This will include development, test and analysis effort.

    May I know what is the reason you are avoiding 3rd party solutions? In my opinion using 3rd party solution is more reliable and cheaper, unless there is a solid reason to not use them.

  • Suggested answer
    Ragnar Hilmarsson Profile Picture
    Ragnar Hilmarsson 3,427 on at

    Kingsway is the best option  for Dynamics 365 and SSIS

    www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-365

  • Suggested answer
    Dharanidharan Profile Picture
    Dharanidharan 638 Super User 2025 Season 2 on at

    In SSIS job you can use the script component(C#) and SQL components to achieve this with out any third party connectors. In script components  you can establish the connection to Crm to create the records in dynami s 365. Even I feel third party solutions are best solution to use it.

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