Back to the index

06

Core Enterprise Services

where
Sysco LABS
when
2022 to 2023
live
shop.sysco.com
  • Java 17
  • Spring Boot
  • Confluent Kafka
  • AWS Kinesis
  • ECS Fargate
  • Aurora PostgreSQL

The problem

Active data still lived on a legacy AS400 database, and the streaming layer ran on Amazon Kinesis — which tied it to one cloud.

What I did

Moved active data onto PostgreSQL using change data capture, so the legacy system stayed authoritative until it did not need to be.

Migrated the streaming layer from Amazon Kinesis to Confluent Kafka.

What changed

Active data served from PostgreSQL, and a streaming layer that is no longer bound to a single cloud.