This topic describes the common development tools that you can connect to Hologres.

Hologres is compatible with PostgreSQL and provides a Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC) driver. You can connect your familiar development tools to Hologres for data development.
Note
  • You can download a JDBC driver from PostgreSQL JDBC Driver. Make sure that the JDBC driver that you use to connect to Hologres is JDBC version 42.2.18 or later.
  • You can download an ODBC driver from File Browser. Make sure that the ODBC driver that you use to connect to Hologres is ODBC version psqlodbc_11_01_0000 or later.
The following table describes common development tools.
ToolDescription and scenarioDocumentation
HoloWebRecommended.

An all-in-one big data development platform that is developed based on Hologres.

The tool supports data development in a visualized manner and by using SQL statements. This way, this tool meets the requirements of developers with different development experiences and is applicable to various development operations in Hologres.

HoloWeb
DataWorksHologres is deeply integrated with DataWorks. You can associate a Hologres instance with a DataWorks workspace. Then, you can use various DataWorks services such as Data Integration, DataStudio, Data Quality, and DataService Studio to perform end-to-end real-time data warehouse development. This can meet data development and management requirements of a variety of different business scenarios.Overview
psqlAn interactive command-line client based on PostgreSQL.

Based on an SQL statement execution page, this tool is more suitable for developers with basic SQL development ability.

Use the PostgreSQL client to connect to Hologres
JDBCA Java API that is used to execute SQL statements, which allows you to access multiple relational databases in a unified manner. The Java API consists of a set of classes and API operations that are written in Java.

Based on an SQL statement execution page, this tool is more suitable for developers with JDBC development experiences.

Use JDBC to connect to Hologres
NavicatA development tool that connects multiple databases.

The tool supports data development in a visualized manner and by using SQL statements. This way, this tool is more applicable to scenarios in which services are highly dependent on Navicat.

Navicat
SQL Workbench/JA free, cross-platform SQL query tool.

Based on an SQL statement execution page, this tool is more suitable for developers with basic SQL development ability.

SQL Workbench/J