Show TOC

Using Open SQL Data BrowserLocate this document in the navigation structure

Use

The Open SQL Data Browser is a tool for viewing the content of database tables residing in the system database schema.

Using the Open SQL Data Browser, you can display all data from the table of interest. You can change the set of the columns that are displayed. To restrict the amount of data, you can define search conditions by specifying table and column predicates.

Prerequisites
  • You are in the Start of the navigation path Troubleshooting Next navigation step Database Next navigation step Open SQL Data Browser End of the navigation path function of SAP NetWeaver Administrator.

  • Your user account has permissions to read data from system DataSource tables.

    To be able to read system DataSource tables, you must have defined a User Management Engine (UME) action for the desired tables, and assigned the UME action to the role or group your user account belongs to.

    For more information, see:

    Creating UME Actions

    Assigning Principals to Roles or Groups

    In addition, the “Example” section below provides source code examples on how to define the UME action.

Procedure

Displaying Data Using Table and Column Predicates

  1. Select Specify a table and optional column predicates from the Data Access Method dropdown list.

  2. Enter a valid table name in the Show field, then choose the Go pushbutton.

    You can also search for a particular table:

    1. Choose the Search pushbutton.

    2. Using wildcards, enter a search string in the Table name field, then choose the Go pushbutton.

    3. In the result list, select the table of interest.

    The Open SQL Data Browser displays the content of the selected table.

  3. To display in details the content of a particular row, select the row.

  4. To include or exclude particular columns from the table view, choose Column List , then select or deselect the desired columns, and choose Go .

  5. To change the maximum number of the displayed entries, type a value in the Maximal Number of Hits field, then choose the Go pushbutton.

Specifying Search Conditions

You can restrict the table rows by defining predicates on the table columns.

  1. Choose the Search Condition pushbutton.

  2. Select the Create New Predicate radio button.

  3. Specify the predicate arguments using the Column , Predicate Type and Value fields.

  4. Choose the Add pushbutton.

    The new search condition predicate appears in the Predicates table.

  5. If necessary, add more predicates.

  6. To edit/remove a predicate:

    1. Select the predicate.

    2. Select the Update/Remove selected Predicate radio button.

    3. To edit the arguments of the predicate, specify the desired values, using the Value field, then choose the Update pushbutton.

    4. To remove the predicate, choose Remove .

  7. To see the number of entries that meet the search condition, choose Number of Entries .

  8. To display the filtered table content, choose Go .

Changing the Settings of the Open SQL Data Browser

  1. Choose the Settings pushbutton.

  2. You can change the following types of settings:

    • Data Truncation - specify how the read data should be handled

    • Result Display - customize the layout of the displayed result

    • Detailed Result Display - customize the layout of the displayed detailed result

    • Open SQL for Java related settings

Example

Defining UME Actions

When you implement an application that defines actions which describe which tables can be accessed by the Open SQL Data Browser, you can use the following code examples.

An action “MyAction” allows browsing three tables: “MyTable1” , “MyTable2” , and “MyTable3” . Note that such enumeration must be a comma separated list, without spaces.

Sample Code
                  <ACTION NAME="MyAction">
        <PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable1,MyTable2,MyTable3" />
</ACTION>
               

Another representation with the same effect would be the following:

Sample Code
                  <ACTION NAME="MyAction" >
        <PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable1" />
        <PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable2" />
        <PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable3" />
</ACTION>
               

To allow access to all tables with one and the same name prefix, you can use a wildcard. The prefix is a sequence of characters that contains at least an underscore.

Sample Code
                  <ACTION NAME="MyAction" >
        <PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTablePrefix_*" />
</ACTION>