Case study

Educational Data Exchange Platform

We helped an IT consulting company integrate their legacy product with an online MS Azure-based platform

Key features

  • Integrate third-party platforms

    Integrate third-party platforms

  • Manage cross-industry knowledge

    Manage cross-industry knowledge

  • Educate council workers efficiently

    Educate council workers efficiently

Industry:
eLearning
Headquarters:
Munich
Market:
Germany
Team size:
10 engineers
Cooperation:
October 2010 – present
Technologies:

MS SQL / .NET / Entity Framework / MVC Web API (RESTful services, OData) / Azure SQL Database (PaaS) / Azure AD / Azure WebJobs SDK

About our client

IFB is a leading German institute for council workers that cooperates with over 600 industry experts and has already provided an engaging learning experience for over 55,000 trainees. It offers a wide spectrum of seminars and online courses ranging from legal topics to economics and everything related to council operations. For more than 25 years, IFB has been equipping learners with the knowledge that makes them informed leaders in local government.

Educational Data Exchange Platform

IFB came with the challenge

Our client had experienced problems with their existing solution’s performance and support for multi-user access. The project was time-critical since it needed to be launched before council elections. During the months preceding those elections, seminars for council workers would be at their peak. IFB needed a highly responsive online educational platform with a precise user focus to strengthen their position as Germany’s leading educational institution for council workers and to improve and personalize the experience for their end users.

The main difficulty of this project lay not only in gradually moving from a data-driven to a domain-driven design – we also needed to migrate data so as not to interrupt ongoing business activities and affect the existing base of speakers and thousands of annual seminar attendees. Intellias’ expertise in platform development and experience with cloud-based solutions were decisive in IFB selecting our company as their software engineering partner for this project.

Intellias developed the solution

Together, we started designing and developing a data exchange platform for enterprise resource planning, customer relationship management, and third-party systems as well as migrating data step by step from Microsoft SQL to the new Azure cloud platform, which had to be available 24/7 via RESTful services.

User endpoints were the key features of this project. Previously, our client had used a complicated algorithm to transfer data, relying on integration services that obtain information from one database and store it in another.

After analyzing the data, we started creating a web API to serve the consumer endpoints provided via the IFB website and app. Our managed team joined our client’s ASP.NET Web API project, using C# for backend development. The platform-as-a-service solution that we jointly developed uses a SQL server based on the Entity Framework. The team also created OData controllers for more flexibility in terms of data querying and extending entities.

The newly developed system has successfully solved our client’s problems with performance and multi-user sessions, resulting in an easier-to-use application. The educational council portal provides a comprehensive seminar program, a great variety of last-minute offers, a kit of service tools, and a forum for discussions. The platform also enables easy data and event management, publication of courses, and custom script writing with incorporated accounting and robust reporting functionality.

We achieved great results together

We’re still growing our cooperation with IFB through new projects. And after the discovery phase, proof-of-concept, and implementation of deliverables, we’ve proceeded to the testing phase for the Azure-based platform solution. Intellias is taking care of IFB’s website and testing the user endpoints created previously, looking at performance issues related to the Azure setup.

The next phase of our partnership will revolve around the community side of the software. Ultimately, the platform will let users contribute their own materials and will empower developers to create new scripts based on a comprehensive SDK. Once end customers are registered on the portal, they can purchase seminars, acquire new council licenses, and participate in course development.

During my first projects with Intellias, they did a perfect job, supporting me with all architecture and design questions. We started with a three-person team and have grown up to ten. The current project shows that Intellias cares about us as their loyal client, doing as much as possible to satisfy us.

Mark Hunt, IT Lead at IFB

 

Thank you for your message.
We will get back to you shortly.