haacredits.blogg.se - Dbvisualizer connect to sql server

Oracle Database 10g Release 2 (10.2.0.4) JDBC Drivers.

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

Transaction SXMB_IFR - Start Integration Builder.

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

To check this log onto your PI system (ABAP stack) and check System -> Status. Once the DBVisualizer tool is downloaded and installed, you next need to determine which database your PI system is using. The tool can be downloaded from the DBVisualizer page. Run an example SQL statement using the DBVisualizer tool.ĭownload and install the DBVisualizer tool.Connection the DBVisualizer tool to the PI database.Download and install relevant database driver to the DBvisualizer tool.For example you may need to run some SQL statements as explained in the following wiki: PI Adapter Engine Troubleshooting SQL Statements.This tool can then be used to run SQL statements against you PI ABAP / Java database schema.The objective of this wiki is to explain how to connect the DBVisualizer tool to your PI database.