In the Integration world, we integrate with heterogeneous databases. Usually we have dependencies on DBA to know the test results and sometimes, it’s a struggle to get the right tool for Database.
SQuirreL is a solution for any platform since it’s written in Java and it supports almost every RDBMS in existence.
It will be useful for SAP PI consultants and also any other developers who are working on any JDBC based application.
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License
How to Install
You can download the SQL Squirrel client from following URL.
How to Set Up
Below are the steps to setup SQL SQuirreL. I am using DB2 Database as an example.
- Install the software for SQL SQuirreL from the link provided above.
- Find the JDBC driver over the internet for your database. For this blog, I have used DB2 Driver
- Launch SQL SQuirreL and you will get the following screen:
- Locate the driver you want to modify (click on pencil icon) or add a new driver (click on plus icon). Provide the following parameters to add a new driver:
- Provide a name to the driver
- Change the Example URL to jdbc:db2://hostname:port/dbname to your JDBC connection string.
- Change the website URL to http://www-306.ibm.com/software/data/db2
- Select Extra Class Path and click on Add button to select the JDBC driver from your system.
- Provide the appropriate class name (JDBC driver) as shown below:
- Next step is to create Alias for your Database. Click on Aliases from left tab and click plus icon to add a new Alias.
- Choose the driver in the drop down list, which was added in the previous step (ex. DB2) and provide the connection URL and credentials
- New connection (TEST_DB2) is added under alias, Double click on the same.
- Click on connect button to connect to the database.
- We are now connected to database as below:
How to Use
Below are the steps to use SQL SQuirreL. I am using DB2 Database as an example.
- Once you are connected to database, two tabs (SQL, and Objects will appear)
- Under the Objects tab, you can find the different Schemas, Tables, views and stored procedure
- Select any Table name and you can find the details (Row Count, Columns, Content, Primary key etc.) of that table
- Under the SQL Tab, you can build and execute your own query. E.g. Write a select/update query and click on run SQL
- Results will appear in the below pane as shown:
By default the result rows is limited to 100, But you can change the same by changing the value in below box or uncheck the flag (Limit rows) in the right top corner of SQuirreL tool