WebSphere Adapter for JDBC

Selecting business objects and services

After configuring the connection properties, run a query for database objects. Browse the metadata tree structure to understand the structure of objects in the enterprise information system (EIS), and make selections of objects needed for the service description.

Before you begin

Before running the query, you can specify Filter properties if you want to narrow the list of schemas, nodes, or objects displayed in the tree structure.

How to perform this task

  1. Specify Filter properties.
    1. In the Find and Discover Enterprise Services window, click Edit Query. In the Query Filter Properties window, type text in the Schema Name Filter property field. The schemas that start with the string you specify are displayed. Select the schemas that you want to use.
    2. The Types property field lists the entries: tables, views, stored procedures, and synonyms/nicknames. You can add or remove nodes from that list.
    3. In the Query Filter Properties window, you can check Add Business Object ASI and click OK.

      Then whenever you add an object when you run the metadata query in Step 2, the Configuration Parameters for (name of object) window is displayed for entering application-specific information.

      Figure 1. Query Filter Properties windowThis screen capture is described in the surrounding text.
  2. Run the metadata query. In the Find and Discover Enterprise Services window click Run Query.

    The objects discovered by the query are displayed in the top pane. The tables, views, stored procedures, and synonyms/nicknames are sorted by schema name.

  3. Filter objects.

    You can filter objects similar to the way you filtered schemas.

    1. Select a tables, views, stored procedures, or synonyms/nicknames node. Click Filter. The enterprise service discovery wizard queries for an Object Name Filter to filter the list of database objects to display for that node.
    2. Type in text, and only those database objects that start with the specified string are displayed.
  4. Select an object by highlighting an object and clicking Add. The selected objects appear in the bottom pane.
    Note: If you need to remove a selected object, highlight it and click Remove.
  5. Add business object ASI.

    If you checked Add Business Object ASI in the Query Filter Properties window, then whenever you add an object, a window called Configuration Parameters for (name of object) is displayed for entering application-specific information. This window is shown here with verb application-specific information parameters for the ADDRESS object.

    The Status Column Name field is used for logical deletes, and Status Value specifies what values to update in the column corresponding to the attribute chosen for Status Column Name.

    Figure 2. Configuration Parameters for ADDRESS windowThis screen capture is described in the surrounding text.
    1. Click Add.
    2. A list of stored procedures is displayed. Select a stored procedure to associate the stored procedure application-specific information with the ADDRESS object. Click OK.

      For example, if your stored procedure creates a record in a table, enter the details for the CreateSP configuration parameter.

    3. Type the values for the Schema name and StoredProcedure name. When you enter a stored procedure name, the StoredProcedureParameters fields are displayed. For each parameter, select a value from the list of business object attributes to associate with the parameter.
    4. Click OK when you are finished entering ASI.
    5. The Find and Discover Enterprise Services window shows the selected objects in the Objects to be imported pane. Click Next.

    If you select more than one object to add, the Configuration Parameters for (name of object) window for the first object is displayed. After you enter the ASI and click OK, the window for the next object is displayed, and so on. For information on the object-level, verb, and attribute application-specific information, see "Application-specific information."


Terms of use |

Last updated: Tue 12 Dec 2006 03:32:39

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)