Help Center> Data Warehouse Service> FAQs> Database Connections> Does GaussDB(DWS) Support Third-Party Clients and JDBC and ODBC Drivers?
Does GaussDB(DWS) Support Third-Party Clients and JDBC and ODBC Drivers?
Yes, but GaussDB(DWS) clients and drivers are recommended. Unlike open-source PostgreSQL clients and drivers, GaussDB(DWS) clients and drivers have two key advantages:
- Security hardening: PostgreSQL drivers only support MD5 authentication, but GaussDB(DWS) drivers support SHA256 and MD5.
- Data type enhancement: GaussDB(DWS) drivers support new data types smalldatetime and tinyint.
GaussDB(DWS) supports open-source PostgreSQL clients and JDBC and ODBC drivers.
The compatible client and driver versions are:
- PostgreSQL psql 9.2.4 or later
- PostgreSQL JDBC Driver 9.3-1103 or later
- PSQL ODBC 09.01.0200 or later
For details about how to use JDBC/ODBC to connect to GaussDB(DWS), see Tutorial: Development Using JDBC or ODBC.
Parent topic: Database Connections
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.