This topic describes common development tools that you can use to connect to and perform operations on Hologres. It also explains the use scenarios of these development tools. You can connect to Hologres for data development by using a development tool that you are familiar with.
Tool introduction
Hologres is compatible with the PostgreSQL protocol and provides JDBC/ODBC drivers:
You can download JDBC from the JDBC official website. When you use JDBC to connect to Hologres, ensure that your JDBC version is 42.2.18 or later.
You can download ODBC from the ODBC official website. When you use ODBC to connect to Hologres, ensure that your ODBC version is psqlodbc_11_01_0000 or later.
The following table describes common development tools.
Name | Tool description and use scenarios | Document link | |
HoloWeb | Recommended An all-in-one big data development platform that is developed based on Hologres. This tool allows you to perform data development in a visualized manner or 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. | ||
DataWorks | An all-in-one big data development platform with which Hologres is deeply integrated. DataWorks is suitable for big data development scenarios in which development is highly dependent on DataWorks, such as scenarios in which DataWorks is used for job scheduling. | ||
Third-party client | Navicat | A development tool that connects to multiple databases. This tool allows you to perform data development in a visualized manner or by using SQL statements. This tool is more suitable for scenarios in which services are highly dependent on Navicat. | |
DataGrip | A development tool that allows you to connect an application to multiple databases. DataGrip facilitates the creation, management, and maintenance of databases. | ||
Apache Nifi | An easy-to-use and reliable data processing and distribution platform. It is designed to facilitate the automatic management of data streams across systems. Apache NiFi provides a web user interface (UI) that is highly interactive and user-friendly. You can use Apache Nifi to manage and process data streams in a system or across systems. | ||
SQL Workbench/J | A free, cross-platform SQL query tool. This tool allows you to perform data development only by using SQL statements and is more suitable for developers with a basic SQL development ability. | ||
PSQL client | An interactive command-line client based on PostgreSQL. This tool allows you to perform data development only by using SQL statements and is more suitable for developers with a basic SQL development ability. | ||
Code-based connection | JDBC | A Java API that is used to execute SQL statements, which allows you to access multiple types of relational databases in a unified manner. The Java API consists of a set of classes and API operations that are written in Java. This tool allows you to perform data development only by using SQL statements and is more suitable for developers with JDBC development experiences. | |
Python | An advanced programming language. Python is widely used in the data analysis field due to its concise and easy-to-read syntax and comprehensive ecosystem of third-party libraries. | ||
Holo Client | A development interface that is developed for Hologres based on JDBC. Holo Client is applicable to writes of a large amount of data and point queries with high queries per second (QPS). For example, you can use Holo Client if you want to associate with dimension tables for queries or synchronize data to Hologres at a time or in real time. | ||