This topic describes how to connect Dataiku to Hologres. After Dataiku is connected to Hologres, you can analyze data in Hologres in a visualized manner.

Limits

Dataiku allows you to directly use SQL Notebook rather than import tables to datasets to query foreign tables.

Procedure

  1. Install Dataiku.
    Install Dataiku. For more information, see Dataiku official documentation.
  2. Connect to Hologres.
    1. Log on to Dataiku. Click Blank project and create a project. In this example, the project is named Hologres.Create a project
    2. On the project details page, click IMPORT YOUR FIRST DATASET to go to the Datasets tab.Import data
    3. On the Datasets tab, select PostgreSQL from the SQL dataset types. On the Connection tab, click create a new connection.Create a connection
    4. Click NEW CONNECTION in the upper part of the Connections tab, select PostgreSQL from the drop-down list, and then create a connection. Create a connection
    5. Set the parameters in the BASIC PARAMS section as required. You can also set the schema-related parameters if necessary.Set parameters
      The following table describes the parameters.
      Parameter Description
      New connection name The name of the connection to be created.
      Host The public endpoint of the Hologres instance. You can view the public endpoint of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.
      Port The port number of the Hologres instance. You can view the port number of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.
      Database The name of the Hologres database to be connected to.
      User The AccessKey ID of your Alibaba Cloud account. For more information about how to obtain the AccessKey pair, see Create an Alibaba Cloud account.
      Password The AccessKey secret of your Alibaba Cloud account. For more information about how to obtain the AccessKey pair, see Create an Alibaba Cloud account.
      Other parameters For more information about other parameters, see Dataiku official documentation.
    6. After you set the required parameters, click TEST in the lower part of the page. After a success message appears, click CREATE to create the connection.Connection established
  3. Analyze data.
    After settings are complete, click Import tables to datasets in the lower part of the page to import table schemas from the database to the dataset at a time. Then, you can analyze data. For more information about the operations of data analytics, see Dataiku official documentation. Data analysis