Querying for database objects

After configuring the connection properties, you can run a query for database objects. You can 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.

Steps for this task

  1. Specify Filter Properties

    In the window Find and Discover Enterprise Services, click Edit Query. In the pop-up window Query Filter Properties, enter text in the Schema Name Filter property field. The schemas that start with the specified string are displayed. Select the schemas that you want to use.

    The Types property field lists the entries: tables, views, stored procedures, and synonyms/nicknames. You can add or remove nodes from that list.

    In the Query Filter Properties window, you can check Add Business Object ASI. Then whenever you add an object when you run the metadata query in Step 2, a window called Configuration Parameters for (name of object) appears for entering application-specific information.

    The image is described in the surrounding text.

    Query Filter Properties window

  2. Run the metadata query
    1. Display objects discovered by query

      In the Find and Discover Enterprise Services window, which follows, click Run Query. The objects are displayed in the top pane.

      This image is described in the surrounding text.

      Find and Discover Enterprise Services window

    2. Filter objects

      You can filter objects similar to the way you filtered schemas. 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. Type in text, and only those database objects that start with the specified string are displayed.

    3. Select objects for import

      Highlight an object and click Add to select objects to be imported. The selected objects appear in the bottom pane. To remove a selected object, highlight it and click Remove.

      This image is described in the surrounding text.

      Customer object has been selected for import

    4. 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) appears for entering application-specific information. This window is shown here with verb application-specific information parameters for the CUSTOMER object.

      Select the verb that your stored procedure should be associated with; for example, if your stored procedure creates a record in a table, enter the details for the CreateSP configuration parameter. Enter the values for the Schema name, StoredProcedure name, and StoredProcedureParameters.

      Click OK when you are finished entering ASI.

      If you select more than one object to add, the window for the first object appears. After you enter the ASI and click OK, the window for the next object appears, and so on. For information on the object-level, verb, and attribute application-specific information, see "Application-specific information."

      Click Next.

      This image is described in the surrounding text.

      Configuration Parameters for CUSTOMER window

Related tasks
Deploying and configuring for Scenario 2
Related reference
Application-specific information

Terms of use |

Last updated: Thu Mar 23 13:24:32 2006

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