Double-click TableauDrivers.dmg in the Downloads folder.
Control-click to install the downloaded dmg.
Double-click the AmazonHiveODBC.pkg file and accept the defaults.Double-click the AmazonHiveODBC.dmg file.Double-click the downloaded file, and then navigate to and open the MacOSX folder.Go to the Use Business Intelligence Tools with Amazon EMR page on the AWS website and select the AmazonHiveODBC_.zip link to download the file.Verify that you have ODBC Administrator installed.It is very responsive to commands and runs on low CPU and memory, so it does not hamper system performance.Īlthough it is not particularly rich in its skill set, SQL Client offers a simple solution to connecting to multiple databases, and it can be used by anyone.Follow these steps to install the Amazon EMR Hive drivers on your Mac computer: There were no type of issues in our tests, since SQL Client did not hang, crash or pop up error messages. Reconnecting to one of them is also possible. What's more, SQL Client lets you export data and import it at a later time, as well as compare databases. It is possible to add as many connections as needed, open them with one click, duplicate entries, edit properties at any time, delete the connections, as well as move them up and down in the list.
The UI is made from a normal frame with a neatly organized layout, where you can add a new connection to the list by specifying its name, built-in JDBC driver, class and Jar file, connect string, user name, password, extra properties, start schema and catalog (meta), transaction isolation mode, along with the background and foreground color. Intuitive interface and options for new connections Plus, it does not modify Windows registry settings or create additional files on the disk, so no traces are left behind after its removal.
You can save the JNLP file in any part of the hard disk and just click it to launch the app, provided that you have Java installed on the machine.Īnother possibility is to copy SQL Client to a pen drive or other removable storage unit to run it on any PC with minimum effort. There is no setup pack involved, which makes SQL Client portable. It offers support for MySQL, DB2, Oracle, MS SQL Server and PostgreSQL. Developed in Java, SQL Client is an approachable and intuitive Windows program that gives you the possibility to connect to multiple databases and manage them easily.