If your primary goal is to stream and process real-time updates from both databases to maintain a consolidated view, RisingWave could be valuable:

• Ingest changes from both databases using CDC connectors.
• Use RisingWave to detect and reconcile changes (e.g., rows added, updated, or deleted).
• Write the processed updates back to the target databases using custom logic.

RisingWave is best suited for real-time data streaming and transformation rather than bi-directional database synchronization though. For your use case, a specialized database synchronization (e.g. AWS DMS) or replication tool would likely be a better fit unless you also need to perform complex real-time transformations or analyses on the synchronized data.