Cuspy augmented the Alianz development team with 2 developers and 1 QA engineer — all experienced in enterprise software development and Salesforce. To tackle the challenge, our developers came up with a light-weight SaaS integration platform, ERP-Link. For this, we fulfilled a range of tasks:

• Elaborated an effective software architecture and chose the tech stack that allowed for (A) securely transferring a considerable amount of data between tools, and (B) tailoring the integration solution if needed. To achieve the desired level of security and data protection, we used Microsoft SQL Server with CLR integration on C#, and enabled data transfer via SFTP.
• Developed the solution that could aggregate data from one to multiple ERP systems and deliver the info to the target systems, be it a CRM or other.
• Enabled two-way communication between integrated systems. This means that ERP-Link can send data in both directions: from an ERP to a CRM or another system, and vice versa — from the CRM to the ERP so as to update ERP records when they change in the CRM. So, data is always consistent, and updates take no manual effort.
• Allowed access to the data aggregated in CRM and developed custom database objects, report type objects, and templates. This functionality helps the users of Alianz’s Salesforce solutions generate more insightful reports easier than with default options.
• Enabled automatic checks of data quality. This way ERP-Link can help users detect duplicates and invalid data.
• Tested the security and performance of the ERP-Link to ensure it is bug-free.