Single Tool to connect to Oracle,Hive,Azure SQL DB

Question

Is their any single tool which can be used to connect and query tables from Hive,Azure SQL Database,Oracle

Answer 1

Hi @Abhishek Gaikwad , you can use Sql Server Management Studio(SSMS) to connect to Azure Sql Database, Oracle as well as Hive. Please refer to below links for steps on each:

Azure Sql Database:
https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-ssms

Hive ( Connection to Hive through SSMS Linked server):
https://www.cdata.com/kb/tech/hive-odbc-linked-server.rst

Oracle (Connection to Oracle through SSMS Linked server):
http://kb.mit.edu/confluence/display/istcontrib/Setting+Up+an+Oracle+Connection+From+Microsoft+SQL+Studio
http://sql-articles.com/articles/dba/creating-oracle-linked-server-in-sql-server/

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

Answer 2

Hi,

Connection to <XXX> through SSMS Linked server

Using linked server is not related to the client side tool but to the server side. It is an entitiy in the server side. Linked server can use most common connections and as such can be used to connect to all the databases you mentioned but again... this is not ability of the client side and not a direct connection to the database.

Can this connection can be made when your database is Azure SQL database.

Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. they are not supported in Azure SQL Database

Is their any single tool which can be used to connect and query tables from Hive,Azure SQL Database,Oracle

There are several application which provide what you asked for, but non of these is Microsoft product as much as I know. For example you can use a tool named "Database Browser" from https://www.etl-tools.com/database-browser/overview.html . I used this toll a lot in the past before the Azure Data Studio on several different types of databases, but I never tested it on Oracle (I do not use Oracle). According to the documentation, It "works directly with Oracle, MS SQL Server, ODBC, MySql, OleDB, BDE, PostgreSQL, SQLite, MS SQL Server Compact, Interbase and Firebird"

This is NOT a recommendation on using this tool! even so I used it in the past. I am NOT familiar with company and cannot guarantee what is done behind the scenes. There is a portable version which is what I use - it does not need any installation and can be execute from external disk-on-key for example.

You should NOT count on this tool to use on production!

Note! "Works" does not mean support all features! This is a basic management tool but if you use Microsoft Product and you can use SSMS or ADS then this is highly recommended - these should support most of the features.

Answer 3

Just use DBeaver and be happy: https://dbeaver.io/