DataGrip connecting to SAP Hana via JDBC?
Hi
Has anyone here already successfully connected SAP Hana via JDBC driver in DataGrip?
I have created a new "user driver" in DataGrip. The driver files is the ngdbc.jar driver, the URL templates are as follows:
By Port:
jdbc:sap://{host::host}:{port::30015}[;failover1:{Failover Port 1:identifier}][;failover2:{Failover Port 2:identifier}][/{database::database}]?[currentschema={Current Schema:identifier}]
By Instance:
jdbc:sap://{host::host}:3{Instance Number:identifier:00}15[;failover1:{Failover Port 1:identifier}][;failover2:{Failover Port 2:identifier}][/{database::database}]?[currentschema={Current Schema:identifier}]
Unfortunately, I get the following error when connecting:
Connection to SAP Hana - *********** failed: Exception in thread "main" java.lang.InstantiationException at java.base/jdk.internal.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(InstantiationExceptionConstructorAccessorImpl.java:48) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at java.base/java.lang.Class.newInstance(Class.java:584) at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14) . Exception in thread "main" java.lang.InstantiationException at java.base/jdk.internal.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(InstantiationExceptionConstructorAccessorImpl.java:48) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at java.base/java.lang.Class.newInstance(Class.java:584) at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14)
Could anyone help me out?
Thank you so much

请先登录再写评论。
hi, we have added basic support of SAP HANA, so please update to the most recent version 2021.1.1 and create data source via (+) -> Other -> SAP Hana and check if it works with bundled driver or not.
Thank you very much. Connection is working.
here is feature request for the SAP HANA support.