Metabase is an open source business intelligence (BI) tool that lets you query data, run analytics, and visualize results as charts and graphs. Because Hologres is compatible with PostgreSQL, you can connect Metabase directly to a Hologres instance and build dashboards on your data.
Before you begin
Collect the following information before opening Metabase. Having these details ready prevents interruptions during the connection steps.
| Information | Where to find it |
|---|---|
| Hologres public endpoint (Host) | Network Information section on the instance details page of the Hologres console |
| Hologres port | Same location as the endpoint above |
| Hologres database name | Instance details page of the Hologres console |
| Alibaba Cloud AccessKey ID | Create an AccessKey pair |
| Alibaba Cloud AccessKey secret | Same page as the AccessKey ID above |
You must also have Metabase installed. See the official Metabase documentation for installation instructions.
Connect Metabase to Hologres
Log on to Metabase. In the upper-right corner of the top navigation bar, click the
icon, and then click Administrator.
At the top of the Metabase Admin page, click Database. In the upper-right corner, click Add database.
Configure the connection parameters using the information you collected, and then click Save.
Parameter Description Database type Select PostgreSQL. Host The public endpoint of the Hologres instance. Port The port of the Hologres instance. Database name The name of the Hologres database. Username Your Alibaba Cloud AccessKey ID. Password Your Alibaba Cloud AccessKey secret. More parameters See the official Metabase documentation for additional options.
Analyze data in Hologres
After the connection is established, you can query and visualize Hologres data directly in Metabase. For guidance on building questions, dashboards, and reports, see the official Metabase documentation.