Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Customer Service updates!Learn about the key capabilities and features of Dynamics 365 Customer Service and experience some of the new features.
Download overview guide | Watch Customer Service video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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 data2. 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 RegardsVenkatesh G
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.
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.
I recommend to generate some Flat file from the CRM. Then push data periodically to your oracle DB.
Business Applications communities