Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hi,Can I bring data from Oracle database to Microsoft CRM? We have certain data which we want to bring from Oracle. One question (maybe) is that data is in binary type (BLOB) and we are wondering that can we make oracle ODBC connection to CRM and have that data to CRM that way.
Or does Microsoft have somekind of documents of this? Maybe some solutions already for this?
CRM must use sql server as database so you ned to integrate or migrate over.
You can use SSIS as well with the kingswaysoft to connect to crm but you can also get the data from oracle using ssis connection driver attunity for better performance.
There are many way to migrate data from Orcale to MS CRM. Some of the most commonly used third party tools to migrate data from oracle to crm
1.Scribe software -- http://www.scribesoft.com/
2.Kingwaysoft SSIS -- http://www.kingswaysoft.com/
3. Cozy Roc SSIS http://www.cozyroc.com/
If you are familiar with sql server SSIS it's very easy to write some simple code to move data from oracle to CRM uisng crm API.
You can do it in completely three different ways with different level of complexity:1. To make your own ETL service, by using CRM API. For gurus2. To use SSIS-based service like Devart SSIS. SQL Server Integration Services knowledge is required.3. To do it with help of cloud-based services like Scribe (expensive one) or Skyvia (more affordable). No-coding at all
Business Applications communities