MaxCompute provides JDBC interfaces that are fully compatible with the PostgreSQL protocol. Users can connect SQL client tools to the MaxCompute Lightning service using JDBC interfaces.
MaxCompute Lightning can be accessed using JDBC drivers from the PostgreSQL official website or other drivers optimized for MaxCompute Lightning.
- JDBC drivers from the PostgreSQL official website.
Note Many client tools already have PostgreSQL database drivers built in, you can use the built-in drivers. If it is not integrated, you can download required drivers from the PostgreSQL official website. Take the SQL Workbench/J client as an example. You can choose the PostgreSQL official drivers when creating a connection.
- JDBC drivers optimized by Alibaba Cloud MaxCompute Lightning
The downloaded MaxCompute Lightning JDBC driver is saved as a MaxComputeLightningJDBC.jar file. Take the SQL Workbench/J client as an example. In the Driver Management menu, add the MaxCompute Lightning JDBC driver entry.When you create a connection, select the MaxCompute Lightning JDBC driver that you just added from the Driver list.