How we provided data access for a manufacturer and distributor

Table of Contents

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.