Data & Storage

Use cases

Feed business tables such as orders, tickets and customer master data into Jiau Insight as an analytics source, or let Jiau Flow write status updates back at a process step.

Capabilities

• Full initial load plus binlog-based incremental sync
• Detects primary keys and timestamp columns, then suggests an incremental strategy
• Resumable transfers: a restarted job continues from the last confirmed position without duplicates or gaps
• Field type mappings can be overridden manually, and invalid records go to a dead-letter queue

Prerequisites

A read-only account for syncing, or an account with write access to the target tables for write-back, plus the relevant ports opened. In production, create a dedicated account for sync jobs and restrict it to the tables that are actually needed.