The client is an international manufacturer and distributor of home appliance products.
Requirements
The client required access to their customer Contact Management System (CMS) for Business Intelligence (BI) reporting via Power BI.
The client also required the flexibility for their internal development team to amend and expand on the solution.
Solution
We created a new ASP.NET web service to run within the client’s infrastructure. The data was sent from their CMS in JSON format and stored in a Microsoft SQL Server database.
For the service, we utilised Entity Framework as the Object Relational Mapper (ORM) to simplify the mapping of objects between the service and database.
Results
By having access to the requested data, the client has improved customer experience and reporting, with the ability to make further amendments in-house.

