Oracle to Microsoft CRM Integration Highlights for Programmer

Feb 24
13:42

2009

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Oracle and Microsoft Dynamics CRM integration is what you could expect in large corporation, acquiring smaller business, where IT infrastructure is built on Microsoft SQL Server and Windows platforms.

mediaimage

Microsoft CRM does Leads generation and Marketing campaigns, Sales Quotes and Orders,Oracle to Microsoft CRM Integration Highlights for Programmer  Articles Products and Pricing, Service and Technician Scheduling job, Contract and Service Case time logging and management, Knowledge Base support and lifecycle and other important business processes.  You could expect several business scenarios, where Oracle needs to be integrated with Microsoft Dynamics CRM.  Let’s review some of them:

 

1.       Microsoft CRM as Sales Orders front end.  If you have your sales people in regional locations in USA or internationally, this is very good approach, as Microsoft Dynamics CRM is web application and could be launched from anywhere in the World, where you have internet connection.  Plus, if you deploy Microsoft CRM Outlook client, you can work with Local replica of your Microsoft CRM objects and transactions: leads, contacts, cases, contract lines, quote, orders, items, prices, etc.  Microsoft CRM Security architecture is very robust and flexible, no doubt it fits to large organization IT requirements and policies

 

2.       Oracle eBusiness Suite as Corporate Accounting, ERP and MRP, also known as Oracle Financials or Oracle Applications.  In large corporation Oracle EBS is popular as Corporate ERP.  Assuming that your organization acquires smaller firm with Microsoft CRM – it is natural next step to move your new subsidiary accounting to Oracle Applications.  Accounting business processes are typically straight forward and there is no challenge (or normal little efforts required) to redeploy it in Oracle Financials.  However, expecting revolution in overnight moving business processes from Microsoft CRM to Oracle is probably utopia.  We recommend you to do one step in the time and stick to evolution instead.  Evolution means slowly move your new branch to Oracle Ebusiness Suite, and keep Microsoft Dynamics CRM for several years by deploying custom gateway between Oracle and Microsoft CRM

 

3.       Microsoft CRM integration technologies.  In large corporation you typically see robust IT departments, and if you are UNIX or high end Linux environment, we expect you also to be strong in Oracle PL/SQL programming.  Your Oracle programmers are likely to be comfortable to provide ODBC connection for Microsoft CRM to integrate its object with Oracle Financials.  You may consider outsourcing Microsoft CRM SDK programming to Microsoft CRM Partner and Reseller

 

4.       Current Microsoft CRM version.  As we are writing these lines in February 2009, current version is 4.0.  Microsoft CRM upgrade typically happens more frequently in comparison to Oracle DB version upgrade, but in any case both Microsoft Dynamics CRM and Oracle are matured applications with certain commitment to programming and integration tools