Hologres is compatible with PostgreSQL, so you can connect Dataiku to a Hologres instance using the built-in PostgreSQL connector and run visual analytics on your data.
Prerequisites
Before you begin, make sure you have:
-
A running Hologres instance
-
The endpoint and port of your Hologres instance (available in the Network Information section of the Hologres Management Console)
-
An AccessKey ID and AccessKey secret for your Alibaba Cloud account. To create one, see Create an AccessKey pair
-
Dataiku installed on your machine. To install Dataiku, see the Dataiku official documentation
Connect to Hologres
-
Log in to Dataiku and click Blank project. For this example, name the project Hologres.
-
On the project details page, click +IMPORT YOUR FIRST DATASET to open the data source page.
-
On the data source page, under SQL, select PostgreSQL, then click Create a new connection.
-
At the top of the page, click +NEW CONNECTION and select PostgreSQL from the dropdown list.
-
In the BASIC PARAMS section, fill in the connection parameters. You can also specify a schema if required.
Parameter Description New connection name A name for your connection. Host The public endpoint of your Hologres instance. Find it in the Network Information section of the Hologres Management Console. Port The port of your Hologres instance. Find it in the Network Information section of the Hologres Management Console. Database The name of the Hologres database. User Your Alibaba Cloud AccessKey ID. For more information, see Create an AccessKey pair. Password Your Alibaba Cloud AccessKey secret. For more information, see Create an AccessKey pair. More parameters See the Dataiku official documentation for additional parameters. -
Click TEST at the bottom of the page. If the test passes, click CREATE to save the connection.
Import data and analyze
After the connection is established, click Import tables to datasets at the bottom of the page to import table schemas from Hologres into Dataiku datasets. Once the import is complete, use Dataiku's visual analytics tools to explore and analyze your data.
