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.
Hi,
When I do research, i came across this thread, we need also something similar to this as well. Can we somehow connect to an MSSQL Server using Compass JDBC ?Or is it not possible, as was the case before?
Best regards,
Serkan
