How to configure Squirrel to use it with SAP ASE

Hi ASE community,

This time, I am going to write about how to configure the Squirrel database manager for using it with an SAP ASE database.

First of all, let’s see what is squirrel for the ones that doesn’t know.

Acccording to wikipedia,

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application’s behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.^[1]

SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.

In a few words, Squirrel is a single, simple front end application that you can use to interact with a big variety of databases.

Now, let’s go to the configuration.

First, start Squirrel:

Now, once started, let’s select the drivers tab.

There, we have to navigate to the Sybase Adaptive Server Enterprise, and press the copy button.

We have to configure the proper parameters for this driver to work.

Once finished with the driver configuration, we have to move to the ALIAS tab.

There, you have to press the “+” button.

We have to configure the following parameters:

You should configure the following parameters:

Once done, you have to select the new Alias created and double click on it:

Finally, if everything is ok, you should see the following table with your database information:

Hopes this is useful.

Regards,

Emanuel