Oracle To Microsoft Crm Integration Highlights For Programmer

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. Microsoft CRM does Leads generation and Marketing campaigns, Sales Quotes and Orders, 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

By: Andrew A Karasev

Article Directory: http://www.articledashboard.com

Andrew Karasev, Alba Spectrum, help@albaspectrum.com 1-866-528-0577 www.albaspectrum.com Serving ERP and MRP: Microsoft CRM, Great Plains and SAP Business One, Oracle community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: www.pegasplanet.com We also specialize in Oracle custom programming. We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey