'Is it possible to connect to ODBC data source from Jetbrains DataGrip?
I need to connect to a legacy ODBC data source our client has provided. I need to analyze the same using Datagrip if possible. Is there any way to do this? Figure shows the screenshot of the ODBC configuration.
Solution 1:[1]
ODBC driver is not supported by Java, please use suggestions from this thread as a workaround (example for pervasive):
- Download jdbc driver for Pervasive database
- In Database tool window open Datasource Properties dialog (Ctrl/Cmd+I shortcut)
- Select + sign and choose to add a Driver and Data Source option
- In that dialog go to driver settings and choose the jar you downloaded. According to documentation jdbc driver class name should be
com.pervasive.jdbc.v2.Driver, so select it in Driver Settings- Then in Datasource properties settings enter connection settings (connection url, user, password in the JDBC URL Format like
jdbc:pervasive://<host>:<port>/<database>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Konstantin Annikov |