Has anyone successfully done setting up Compass JDBC driver in SQL Server Management Studio? Can you please share the steps to follow?
Thanks
Hi Venky,
I'm working on a new How To guide to set up the JDBC driver. Typically, SSMS setup would require an ODBC driver unless you leverage some sort of JDBC:ODBC bridge and register this as a System DSN.
I'd instead recommend looking at a universal SQL tool like https://dbeaver.io/ or http://squirrel-sql.sourceforge.net/ which would allow you to setup & configure a connection to the Data Lake.
I am interested in the same question, but I am interpreting your answer is no. Everything being returned to me in this forum suggests a universal SQL manager. Any updates on this?
Hi MaggieW,
Typically, you would need to add a non-MSSQL system as a linked server with ODBC connections. We don't yet offer Compass ODBC (planned for 2021) so your other options might be to use an ODBC:JDBC bridge but I can't confidently say whether other customers have been successful in this approach and trying to query Data Lake via Microsoft SQL Server Management Studio.
