Andrew Karasev, Alba Spectrum, help@albaspectrum.com 1-866-528-0577 http://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: http://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, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America
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
- Related Videos
- Related Articles
- Ask / Related Q&A
- Oracle To Microsoft Crm Integration Highlights For Programmer
- Microsoft CRM Gets the Top Market
- Microsoft CRM for Corporate Business – Working Offline
- Microsoft Great Plains Integration Manager 10.0 Technical Notes
- The History of CRM
- Microsoft Navision ERP Selection for Sme – Things to be Consider
- Microsoft Dynamics ERP and CRM Software
- Microsoft Dynamics GP Support: What is Possible and What is not possible in Remote Support




Web Portal Development
By: Digisha Modi | 07/01/2010Web portals and Content Management Systems help improve on customer satisfaction and customer loyalty. By providing valuable information and services to customers on line, there is a much greater potential for increased sales and growth. Of course it is critical to maintain other forms of customer service, but in today's technology environment, more people are going to the internet as their first point of contact with businesses of all sizes.
Web Portal Development
By: Digisha Modi | 07/01/2010Web portals and Content Management Systems help improve on customer satisfaction and customer loyalty. By providing valuable information and services to customers on line, there is a much greater potential for increased sales and growth. Of course it is critical to maintain other forms of customer service, but in today's technology environment, more people are going to the internet as their first point of contact with businesses of all sizes.
XHTML Development
By: Digisha Modi | 07/01/2010XHTML is the W3C standard for developing cross browser compatible web sites. It fuses all of the display elements of HTML with some of the functionality of XML. By forcing a web designer to program more carefully and adhere to strict code standards, XHTML allows a larger percentage of browsers or code parsers to properly parse your documents. In less geeky terms, it means more people can see your site the way you meant for them to see it, and less people see your site with elements strewn all ov
Magento Custom Module Development
By: Digisha Modi | 07/01/2010Magento is a new and powerful eCommerce system offering rich customization possibilities by extensions and modules. Magento is built on a fully modular model that influences an unlimited scalability and flexibility for your store. Part of customizing Magento is, creating Magento custom Modules. These allow you to inject functionality anywhere, whether in a "static" block fashion that's more than static, or a shipping/payment module, or large module to do something as large as integrating a 3rd p
Winnovative HTML to PDF Converter - An Easy Way to Create and Maintain PDF Reports
By: Winnovative Software | 06/01/2010The HTML to PDF Converter for .NET from Winnovative Software combines the powerfull printing capabilities of the PDF format with the flexibility of the HTML to format to create a great tool for creating nicely formatted and easy to maintain PDF reports and documents.
ASP.NET Reports creation
By: Famous16 | 06/01/2010The ability to create reports is one skill that all must have had to develop. No matter the situation, school work or even in the home, a report could be necessary in almost any circumstance.
SilverlightRS - an upgrade to Silverlight
By: chaudhary fahim | 06/01/2010Windows Presentation Foundation was the initial name for Silverlight everywhere.
The “MySQL” Way of the World
By: Tyler Moon | 06/01/2010Each enhancement of the again and again points out to the fact as to why the newest version of MySQL is the perfect choice for IT professionals who want to profit from the flexibility and cost savings of open source software, but not forfeit anything relating to database reliability, performance, and ease-usability features.
Microsoft Dynamics GP 2010 Payroll Tax Update Notes
By: Andrew Karasev | 05/01/2010 | SoftwareIf your organization processes US Payroll internally in Microsoft Dynamics GP 10, 9.0 or earlier version: GP 8.0, 7.5, Great Plains 7.0, 6.0, 5.5, 5.0, in this small publication we would like to review annual Payroll Tax rates update methods.
Microsoft Dynamics GP: Recovering Failed Implementation Notes
By: Andrew Karasev | 04/01/2010 | SoftwareYour Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license...
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level