Three challenges to overcome when integrating ERP with CRM
Many businesses today use ERP and CRM (Customer Relationship Management) software to help their organizations succeed. There are good reasons to integrate these systems. Both share names and addresses although one might call it a customer and the other a contact. A quote in one system will become an order in the other. Integration is such a good idea that many ERP providers now offer their own CRM completely integrated.
If you choose to integrate two separate systems, there are some challenges:
1. Standardizing data format across both systems
Your sales or marketing departments might consider they own your CRM. Accounting or operations think they have a claim on your ERP. In fact, all the data in either system is owned by the enterprise and the reason for integration ought to be saving manual steps or entering new orders faster – something that benefits the enterprise. Little differences can lead to big issues downstream. ERP might have a unique customer ID and ‘firstname’ and ‘lastname’ fields. CRM has its own unique ID and first, middle, and last name fields. Work out how you will operate in the future and agree that one or the other format will be used and that there will be no going back.
2. Agreeing on how you will integrate
You can hire a third-party integration specialist to link your systems. Often these businesses have software of their own to manage data reconfiguration and mapping. That software reads data from one side and transforms to a format readable by the other side copying new data into the proper tables. These transforms should be bidirectional as transactions and new records in either system need to be shared with the other.
You can also choose to extract flat files, perhaps in a .csv format. Those files are then imported to the other system as a series of transactions. These imports will use the same validation rules as a manually entered transaction so data in the systems is protected. There is a time delay with this process so a transaction in one side might not show in the other side until a few seconds or hours later.
Think about your needs and your budget and decide what integration process works best for you.
3. Cleaning up your data
Both your ERP and your CRM will have old data, like customers who haven’t placed an order since 1998 that you should clean up before integrating. Mistakes will likely have have happened in both systems - now is the time to clean those up before they confuse another system. If you choose to use the customer ID from ERP, changing the existing IDs in CRM is another part of data clean up.
ERP and CRM can integrate well with good results for all. Pay attention to the details and your integration will succeed.
How ERP can help you achieve GDPR compliance
How can we use ERP systems to achieve GDPR compliance?
PLM and ERP: what's the difference and do you need both?
We explain the crossover between PLM and ERP, and how this affects your software requirements
Quickbooks: integrate or abandon once you’ve selected ERP?
Should you integrate Quickbooks with your new ERP or move to your ERP's financial management tools?