Connect Database Squirrel Sql client windows

Connect Database Squirrel Sql client windows

This is another database administration tool purely written in Java which allows user to interact with database via JDBC driver as usual you do it through programming. Also this is desktop application created using Java with Swing UI component and you could run on any platform if it has JVM available. To start using this tool first download Squirrel client form here .

  • If you have downloaded the zip file then unzip it you will same as below:

2016-08-10 15_26_10-squirrelsql-3.7-optional

  • Double click squirrel-sql.jar to open it you will see below screen:

2016-08-10 15_36_22-SQuirreL SQL Client Version 3.7

  • To connect any database first you will have register it JDBC driver. Let’s say you want to register Sybase driver seach for Sybase Adaptive Server Enterprise –> right click –> Modify Driver:

2016-08-10 15_41_57-SQuirreL SQL Client Version 3.7

  • Pass all required information and please remember you will have to include drive jar also in classpath. JDBC driver jar for Sybase is jconn.xxx.jar so I included in the path once all entered click Ok to save it:

2016-08-10 15_43_08-Change Driver_ Sybase Adaptive Server Enterprise

  • Now you could connect the database. Go to Aliases tab –> Click create new Aliases:

2016-08-10 15_46_53-SQuirreL SQL Client Version 3.7

  • Choose driver for the drop down which you have configured in above step, give alias name then user/pass then click test to test the connection:

2016-08-10 15_49_42-Add Alias

  • If driver and all credentials supplied correctly then test should show success result:

2016-08-10 15_55_24-Change Alias_ UAT Database

  • Now you could start using this tool to explore the database. Now go to alias and connect to the database:

2016-08-10 16_23_48-SQuirreL SQL Client Version 3.7

  • One more last thing how you will see the tables: Choose catalog which is schema name then browse the table:

2016-08-10 16_28_10-SQuirreL SQL Client Version 3.7

Leave a Reply

Your email address will not be published. Required fields are marked *