Event-Driven Automation

Task

The customer operates a centralized 2-tier database application based on Oracle and other proprietary technologies. The analysis of the business processes revealed that there were repeated delays in the workflow. The reason for this was the fact that successive work tasks were not aware of the completion of the previous task because these tasks were performed in different program parts of the client by different users in the “pull principle”.

Solution

After the identification of key events on the database - such as changes in the status fields of records - a microservice was developed to receive and forward these events to other microservices.

On this basis, notification of users via the “push principle” is possible, for example by implementing a microservice for sending e-mails when a time-critical task is completed. Even more effective, however, was to use additional specialized microservices to start the the next task, i.e., to create data records and fill them in with all the known known information - which otherwise had to be done laboriously by hand.

Profile

  • Industry: Pharmaceutical industry
  • Period: 2021
  • Architecture: Microservices
  • Technologies
    • Python
    • RabbitMQ
    • Nameko
    • Oracle CQN

By using microservices, a higher degree of automation could be achieved with the lead time massively reduced. The chosen architecture offers fail-safety and scales as needed. The use of Python allows fast and uncomplicated modification and testing of the business logic.

Want to create project like this?

I will gladly contribute my experience and help you with the implementation.

Contact Me