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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Data Integration betwe...
Service | Customer Service, Contact Center, Fie...
Unanswered

Data Integration between D365 CE and Oracle for large data

(1) ShareShare
ReportReport
Posted on by Venkatesh Gopalaiah 190

Hi,

We have need of two way data flow between D365CE and Oracle and doing a feasible study about implementation approach. The following are the candidates that we have come across 

1. CDS Data Integrator (We think, this cannot be used since we have large set of data
2. Azure Data Factory Mapping Data Flows (No much idea)
3. Use third party SSIS toolkit (Ex: KingswaySoft)

I would like to know other approaches which can be considered and also suggestion on the best approach.

Thanks and Regards
Venkatesh G

I have the same question (0)
  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Data Integration between D365 CE and Oracle for large data

    Hi Vankatesh, with all three options you have listed, only the 2nd and 3rd options are worth looking into. CDS data integrator is not designed for complex integration, it is primarily designed around pre-defined templates, so there is little to no customization if you want the integration to happen in a specific way.

    I am not too familiar with the 2nd option, but Oracle connection is never a simple thing to achieve. In addition, Azure Data Factory is still primitive in terms of working with complex integration scenarios.

    The 3rd option gives you the ultimate flexibility (full disclosure - I work for KingswaySoft) and scalability. You do however need our SSIS Productivity Pack product in addition to our Dynamics 365 toolkit to achieve your purpose, as you will need our Premium ADO.NET components to facilitate the easy reading and writing of Oracle data. The out-of-box ADO.NET components have a lot of issues when connecting to Oracle data sources, and we offer many advanced options (such as Upsert, FullSync actions) that can be used to facilitate bidirectional writing.

    You may get in touch with our team by reaching out to us at our online contact form, so someone from the team will get back to you. We are happy to address any further concerns that you may have.

  • Venkatesh Gopalaiah Profile Picture
    Venkatesh Gopalaiah 190 on at
    RE: Data Integration between D365 CE and Oracle for large data

    Hi Daniel Cai,

    Thank you for your response and providing the a very brief explanation about data integration between D365 CE and Oracle and it is appreciated.  

    Regards

    Venkatesh G

  • meelamri Profile Picture
    meelamri 13,216 User Group Leader on at
    RE: Data Integration between D365 CE and Oracle for large data

    Hello,

    I recommend to generate some Flat file from the CRM. Then push data periodically to your oracle DB.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 48

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 44 Super User 2025 Season 2

#3
mk1329 Profile Picture

mk1329 16

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans