This topic describes how to use a connector to synchronize data from a DataHub topic to a Hologres table in real time.
Prerequisites
- A Hologres instance is purchased. A development tool is connected to the instance. For more information, see Use Hologres from the PostgreSQL client.
- DataHub is activated. For more information, see Get started with DataHub.
- The following table lists the mappings between concepts in DataHub and Hologres.
DataHub Hologres Project Database Topic Table
Background information
DataHub is a real-time data distribution platform designed to process streaming data. You can publish and subscribe to streaming data in DataHub and distribute the data to other platforms. This allows you to analyze streaming data and build applications based on the streaming data.
Hologres is a real-time interactive analytics service developed by Alibaba Cloud. It is fully compatible with PostgreSQL and integrates seamlessly with the big data ecosystem. You can use Hologres to analyze and process petabytes of data with high concurrency and low latency.
You can use a connector to synchronize data from a DataHub topic to a Hologres table in real time. Then, you can gain an analytical insight into the data from multiple dimensions and process the data in real time in Hologres.
Procedure
Mappings of data types
DataHub | Hologres |
---|---|
BIGINT | BIGINT |
STRING | TEXT |
BOOLEAN | BOOLEAN |
DOUBLE | DOUBLE PRECISION |
TIMESTAMP | TIMESTAMPTZ |
DECIMAL | DECIMAL |