Configure DBVisualizer

Prerequisites

Download and install the latest version of the DBVisualizer from http://www.dbvis.com.
Read the central configuration guide and download the necessary files.

Configure jdbc4sapnw as new jdbc driver

Start the DBVisualizer and open the Driver Manager. You will find a button "create a new driver" at the left top corner.

At first configure the user specified paths and set it to the required library files. Enter the name "JDBC4SAPNW" and URL Format as shown in the screenshot. If all files are correctly configured the jdbc driver class "de,joomp.jdbc.sap.SAPJdbcDriver" should be displayed at the listbox "Driver Class".

The driver is ready to use now.

Create a new connection

In the main window of the DBVisualizer a new connection can be created. Enter your description of the jdbc connection to your SAP system.

At the next step you will be asked for the jdbc driver you want to use. Select the "JDBC4SAPNW" here.

In the following window you can enter the jdbc url, username and password for the SAP system.

Enter "Finish" and use your new connection!

Test your connection

The new connection is available in the DBVisualizer connection overview. Open your SAP connection and check the browsing functions for example. You can enter SQL statements (readonly) to test the driver:

Example:

SELECT * FROM SFLIGHT 
        WHERE ( CARRID = 'AA' OR CARRID = 'AZ' ) 
        AND SEATSMAX BETWEEN 280 AND 380
        AND FLDATE = '20120309';

Troubleshooting

You will find additional information in the debug log. Open the menu "Tools - Debug Window...".