This topic describes how to connect Hologres to Realtime Compute to build a real-time data warehouse and then connect Hologres to a Business Intelligence (BI) tool to display data analytics results.
Prerequisites
- A Hologres instance is purchased and a development tool is connected to the instance. For more information, see Quick start to HoloWeb.
- Realtime Compute is activated.
Note Make sure that you activate the Realtime Compute and Hologres services in the same region.
- DataV is activated. For more information, see Activate DataV.
Background information
Hologres is an interactive analytics service developed by Alibaba Cloud. Based on the built-in HoloHub API, Hologres connects to Realtime Compute to support real-time writes and queries in high concurrency. Hologres can respond to queries within seconds.
Hologres is compatible with PostgreSQL. You can connect Hologres to a BI tool to analyze queried data and display data analytics results in a visualized manner.
This topic uses an e-commerce store as an example to describe how to display operating metrics in real time. The metrics include the number of unique visitors (UVs) to the store, number of UVs to each product, sales amount in each city, and statistics of hot-selling products.

- Source data is collected and written to Realtime Compute in real time for cleansing and aggregation.
- Data processed by Realtime Compute is written to Hologres for interactive searches.
- Query results are displayed in DataV in real time, which is connected to Hologres.