Question: Do you know of a system that can automatically update data mapping logic when schema changes occur?

If you're looking for a system that can automatically update data mapping logic when schema changes occur, Lume is a great option. Lume is an AI-powered data mapping automation tool that plugs directly into systems, removing manual data manipulation. It can handle new schema changes and generate correct mapping logic in seconds. The tool includes features for reviewing and editing mapping logic, and includes the Lume API for direct integration and the Lume Platform for a no-code interface, so it's a good fit for industries like financial services and e-commerce where consistency and accuracy are paramount.

Another option is Airbyte. It's an open-source data integration platform that supports automated schema evolution, which means it can handle change data capture efficiently. Airbyte can move data from more than 300 data sources to many destinations, with tools like a Connector Builder and Integrations with common platforms. It can be deployed in a variety of ways and has strong security, making it good for small-scale or large-scale data integration.

Estuary is another good option, particularly if you need a platform that's geared for real-time data integration with low latency. It has automated pipelines with schema evolution, which makes it a good fit for agile DataOps. Estuary has features like 100+ no-code connectors, stream-store-replay for data storage and replay, and flexible materializations, which means you can capture and process data reliably and efficiently.