WebSphere Adapter for Oracle E-Business Suite

Selecting the business objects and services

After configuring connection properties, run a query for database objects. You can browse the metadata tree structure to understand the structure of the objects in the enterprise information system (EIS), and select objects needed for the service description. For this sample, you run a query on the accounts receivable (AR) schema and select synonyms that represent the Oracle E-Business Suite interface tables.

How to perform this task

  1. Specify filter properties

    In the Find and Discover Enterprise Services window, click Edit Query. In the Query Filter Properties window, type AR in the Schema Name Filter property field to display the accounts receivable (AR) schema.

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

    Click OK when finished.

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

      Click Execute Query. The AR schema and elements of the schema are displayed in the top pane.

    2. Expand the AR schema.

      Expand Synonyms - Nick Names

    3. Select the synonyms

      Select each of the synonyms, and click Add to import list. When you are finished, click Next.

      The synonyms are as follows:
      1. AR.IBM_R_CUST_PROFILES
      2. AR.IBM_R_CUST_ACCOUNTS
      3. AR.IBM_R_PARTIES
      4. AR.IBM_R_ACCT_SITES
      5. AR.IBM_R_SITE_USES
      6. AR.IBM_R_PARTY_SITES
      7. AR.IBM_R_LOCATIONS
      8. AR.IBM_R_CONTACTS_CUSTOMER
      9. AR.IBM_R_CONTACTS_SITES

Terms of use |

Last updated: Mon 30 Oct 2006 03:46:27

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