DataGrip read connections on Windows 64-bit ODBC Administrator for easier set up
Answered
Working with a large set of databases that are already managed by windows 64-bit ODBC Administrator. Programs like AQT auto pulls in these connections for easier set up. Anyway DataGrip can do the same?
Please sign in to leave a comment.
I'm looking for this setup and documentation as well.
Is ODBC even available in DataGrip? Seems only to support JDBC...
@O RObert, @Glenbot9
We do not support ODBC since JDBC-ODBC bridge was removed from Java8. There are some third-party solutions by https://www.easysoft.com/ and https://stackoverflow.com/questions/14229072/removal-of-jdbc-odbc-bridge-in-java-8
One can vote for a feature request https://youtrack.jetbrains.com/issue/DBE-3200
Okay - then provide some more native support for more databases. URG.....
I have several datagrip licenses through several companies i work with. There are several issues with datagrip that are not being addressed. Add all the new features you want but if date-time issues and connections are not setup, the product is hard to use and useless.
A long standing customer who is loosing his patience.....
I've already stopped using DataGrip and moved to NaviCat.
@DAnderson Could you provide more detailed feedback concerning problems you face?
This is crazy to me that this is still a thing looking back at this thread. There is no ODBC support.. ok... JDBC does not support ActiveDirectoryInteractive (not integrated) so I can't log in using MFA that's required... SO basically I can't use datagrip to connect to any Azure resources that require MFA...
I guess SSMS it is? Kinda crapy for a tool that's "One IDE for Many Databases"
It looks like Microsoft has added support to mssql-jdbc for ActiveDirectoryInteractive authentication.
https://github.com/microsoft/mssql-jdbc/pull/1464
I'm not super familiar with Java, would I need to build those it looks like?
Naw, the release page has the jdbc driver you can download. The latest release looks to add logic for ActiveDirectoryInteractive timeout.
You can get the current version here: https://github.com/microsoft/mssql-jdbc/releases/tag/v9.2.0
I don't know how to set it up, maybe the Microsoft website or github can help with that. I did see that on the pull request #1464 that there was a property that needed to be used: Add new type to authentication property. ie `authentication=ActiveDirectoryInteractive".
ActiveDirectoryInteractive auth along with MS SQL JDBC driver v9.2.0 is now supported in DataGrip 2021.1 EAP 1.