This topic describes the common development tools that you can connect to Hologres.
- 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.
| Tool | Description and scenario | Documentation |
|---|---|---|
| HoloWeb | Recommended. 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 |
| DataWorks | Hologres 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 |
| psql | An 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 |
| JDBC | A 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 |
| Navicat | A 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/J | A 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 |