CRM Integration Max Effgen, June 11, 2012 One of the biggest challenges that CRM systems have is integration with back end systems. In the cloud with hosted CRM, this in some ways is actually a bigger challenge than it was in the past. From CRM to ERP Pipeline and Forecast data are the most common and most important data from CRM into an ERP system. Business process determines the complexity of the integration. Examples of complex integration requirements can be found with just in time manufacturers (e.g., Dell). These organizations will integrate forecast data into their supply chain for competitive advantage. More common CRM to ERP integration is less complex. Generally and regardless of complexity, this integration occurs on set schedules (e.g., Weekly) as part of the sales process. True real-time capabilities are not required or necessary. Real-time availability by a vendor (product, SaaS, or ISP) will be of more concern. Some Sales organizations have a culture of frequently adjusting pipeline and forecast requirements. This is often seen with changes in Sales and Executive management. Ideally, the change in business process would not impact the data integration; however, the technical configuration may need adjusting as well. From ERP to CRM Product and Price List data from ERP to CRM is always a complex integration. Technical configurations can be complex. The volume and frequency of updated data can also be complex. Most large contracts are negotiated with customer specific pricing, terms and conditions. For many organizations negotiated contracts are the norm and the lifeblood of the company. As a result there are typically no set of constants or rules across all negotiated customer specific prices lists. Individual negotiated contracts for all large customers would create a scenario of hundreds or thousands of unique price lists. This creates tremendous complexity for technical configuration as well as the volume and frequency of updated price list data. From CRM to Business Intelligence/Analytics While the two previous requirements focused on the sales force automation areas of CRM, integration with business intelligence and analytics tools could and often cover the spectrum of CRM applications: Sales, marketing, customer service, etc. Each department has their own tools and key performance indicators. Functional requirements arise from leveraging the right data to enhance the customer relationship. Three areas of concentration are data mining, decision support and analytical tools. These integrations often are “nightly data dumps” from the CRM system into the business intelligence tool. CRM CRMenterpreisethoughts