Connecting Software
32 Case Studies
A Connecting Software Case Study
Iperal Supermercati, an Italian supermarket chain, faced the challenge of manually inputting vast amounts of customer data from their Microsoft SQL Server database into their Microsoft Dynamics 365 CRM. This process was extremely time-consuming and inefficient, preventing real-time data updates crucial for effective customer support. They sought an automated solution and turned to vendor Connecting Software and their product, Connect Bridge with the Dynamics 365 connector.
Connecting Software implemented Connect Bridge, a middleware that acts as a linked server to transparently translate T-SQL queries for the Dynamics 365 webservice. This allowed Iperal to use a database trigger to update or insert new data in real-time. The solution was implemented in just one week, successfully automating the integration and achieving the customer's dual goals of development efficiency and real-time performance for their several hundred thousand rows of data.