You can connect to Hologres for data development by using various tools, including HoloWeb, DataWorks, third-party database clients, and programmatic interfaces such as JDBC and Python.
Overview
Hologres is compatible with PostgreSQL and provides Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) drivers.
-
Download the JDBC driver. Use version 42.2.18 or later.
-
Download the ODBC driver. Use version psqlodbc_11_01_0000 or later.
The following table lists the supported development tools.
|
Tool |
Description |
References |
|
|
HoloWeb |
Recommended. A Hologres-native development platform. Supports both visual and SQL-based development for all skill levels. |
||
|
DataWorks |
A big data development platform deeply integrated with Hologres. Best suited for workflows that rely on DataWorks for job scheduling. |
||
|
Third-party clients |
Navicat |
A multi-database development tool. Supports visual and SQL-based development. Best suited for teams already using Navicat. |
|
|
DataGrip |
A multi-database development tool for creating, managing, and maintaining databases. |
||
|
Apache NiFi |
A data processing and distribution platform for automating data flows across systems. Provides an interactive web UI for managing data streams. |
||
|
SQL Workbench/J |
A free, cross-platform SQL query tool. SQL-only interface. Suited for developers comfortable with SQL. |
||
|
PSQL |
A PostgreSQL interactive command-line client. SQL-only interface. Suited for developers comfortable with SQL. |
||
|
Code-based connections |
JDBC |
A standard Java API for executing SQL statements against relational databases. Suited for developers with Java and JDBC experience. |
|
|
Python |
A widely used language for data analysis, with a rich ecosystem of third-party libraries. |
||
|
Holo Client |
A Hologres-specific JDBC-based interface optimized for high-throughput writes and high-QPS point queries. Ideal for dimension table lookups and batch or real-time data synchronization. |
||