Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA
Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA

Cloud based multi-tenant data transformation services with Microservices

A leading auto parts supplier transitioned from a monolithic system to cloud-based, multi-tenant data transformation with microservices. This fosters scalability, simplifies maintenance, and empowers real-time data insights.
Reading time: 2 min(s)

The client is leading supplier of automotive and heavy duty replacement parts. The client was using a monolithic custom service that would process incoming request and extract data from SAP and send it to the vendor system. Our service includes the creation of single API gateway endpoint to manage requests from multiple client applications, Orchestration service to manage the schema validation & Transformation. Created Microservices to handle all the business data integration between Logic Apps and the on premise SAP data source using RFC BAPIs.

Business challenge

  • Due to the several simultaneous calls to the SAP database, the SAP server goes down.
  • The request and response are not managed properly resulting in poor response time and no response due to request timed out.
  • Also, there is no single place to control and streamline all incoming requests and process them efficiently to the SAP system.
  • The existing architecture doesn’t have a mechanism to reuse existing messages, hence all the messages are treated and handled as new messages and separate methods are created which increase the code redundancy.
  • There is no way to track the reason and place of failure as the requests, responses and intermediate validations are not properly logged.

How Avasoft helped?

  • Setting up of the cloud based multi-tenant data transformation services that would handle the request more efficiently.
  • Setting up of API Gateway endpoints that would seamlessly handle request from multiple channels and multiple clients.
  • Created an Orchestration process that would perform schema validations for incoming messages and outgoing messages based on the client and message types.
  • Created several Microservice that would handle individual business scenarios, which can be independent and can be reused for similar request.
  • Created a common utility Microservice that would monitor and log the activities across different stages between request and response.
  • These utility service act as monitoring agent which would alert admin in case of any failures.

Technology stack

  • Azure LogicApps
  • SAP
  • Azure Microservices
  • API Management

Value additions to customer

  • The Customer was able to quickly onboard new vendors without any hassle as some of the generic microservices are reused and also the time involved in deploying the services and testing are reduced to a great extent.
  • Configuring the client specific request and response message can be done faster and safer since the microservices are isolated and don’t impact other services.
  • Proactive monitoring of the Orchestration process and microservices involves immediate alerts to the admin in case of any failure.

Share this Article