How to connect to Oracle, MySQL or any database using Squirrel SQL client

Save

When using environments that use a relational database management system, or RDBMS, you may come across the need to connect to multiple databases -- such as Oracle or MySQL -- from multiple vendors at the same time. You may also need the interface to be simple so that people who aren't database specialists can also view the data. SQuirreL SQL client is an excellent tool to meet these needs. It is open-source software that free of cost and distributed for Windows, Linux and Mac OS X.

Things You'll Need

  • Java Virtual Machine (Java Runtime Environment) installed
  • Download the free tool from the SQuirreL website. Run this command to install the tool, replacing "version" with the actual version number and accepting all default installation options.

    java -jar squirrel-sql-version-install.jar.

  • If you have any JDBC driver that you need to specifically use, copy it to the following location:
    C:\Program Files\SQuirreL SQL Client\lib

    Run the tool. Select "Drivers" and then "New Driver." Provide the driver class name and example URL. The driver class must to exist in one of the jars

    Now select "Aliases" and then "New Alias." Enter the driver that you just created along with the username and password.

  • Connect to the database. A new window opens with a left and right pane. On the top left of the pane you will see two tabs,Objects and SQL. Use the Objects tab to view the different schemas, tables and stored procedures. Use the SQL tab to run explicit SQL queries.

  • Photo Credit Thinkstock Images/Comstock/Getty Images
Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Connect to Oracle From an SQL Server

    SQL Server and Oracle are two different database server applications that are used in medium to large businesses. These databases can also...

  • How to Learn SQL From Scratch

    The acronym “SQL” may look and sound like squirrel, but it stands for “Structured Query Language.” Coders and developers use SQL to...

  • How to Connect to DB2 With SQL Developer

    Oracle offers the SQL Developer as a free tool designed to help programmers work with Oracle databases. SQL Developer provides graphical representations...

  • How to Connect PHP to MySQL Using WAMP

    A common open-source Web environment consists of Apache as the server, MySQL for the database and PHP as the scripting language. Most...

  • MySQL Subqueries Tutorial

    Subqueries are queries nested within another query. Subqueries allow you to separate each part of the statement and provide a more readable...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!