Purpose

• The objective of this wiki is to explain how to connect the DBVisualizer tool to your PI database.
• This tool can then be used to run SQL statements against you PI ABAP / Java database schema.
• For example you may need to run some SQL statements as explained in the following wiki: PI Adapter Engine Troubleshooting SQL Statements

Overview

This document shows the steps needed to:

• Download the DBVisualizer tool.
• Download and install relevant database driver to the DBvisualizer tool.
• Connection the DBVisualizer tool to the PI database.
• Run an example SQL statement using the DBVisualizer tool.

Download and install the DBVisualizer tool.

The tool can be downloaded from the DBVisualizer page.

Download and relevant database driver.

Once the DBVisualizer tool is downloaded and installed, you next need to determine which database your PI system is using. To check this log onto your PI system (ABAP stack) and check System -> Status.

You can then see which database your PI system is using. In this example its Oracle 10.2.0.4.0.

The next item is to determine which JDK version your PI system is using. This can be determined using the following steps:

1. Transaction SXMB_IFR - Start Integration Builder
2. Administration

Now you know the database version and the JDK version, your ready to download the relevant driver from the database vendor. In this example the driver is downloaded from Oracle.

• JDBC Drivers
• Oracle Database 10g Release 2 (10.2.0.5), (10.2.0.4), (10.2.0.3), (10.2.0.2), (10.2.0.1.0) drivers
• Oracle Database 10g Release 2 (10.2.0.4) JDBC Drivers
• ojdbc14.jar (1,555,682 bytes) - classes for use with JDK 1.4 and 1.5

Install relevant database driver.

Start DBVisualzier tool using the shortcut on your desktop.

Once DBVisualzier is open, click on the create new database connection icon.

Enter in the name of the new connection.

Select the driver type (in this example Oracle) and load the driver you previously downloaded from the database vendor.

Enter in the PI database connection details.

The oracle listening port is found in the listener.ora file. for example:

D:\oracle\<SID>\102\NETWORK\ADMIN\listener.ora

(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = hostName)
(PORT = 1527) <<<< Here >>>>

The rest of the parameters (Database userid, Password,...) will be known by your Oracle database administrator.

Connect the DBVisualizer tool to the PI database and execute a sample SQL statement.

Related Content:

PI Adapter Engine Troubleshooting SQL Statements

Related Notes: