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.
- 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.
- Run the metadata query
- Display objects covered by the query.
Click Execute
Query. The AR schema and elements of the schema are displayed
in the top pane.
- Expand the AR schema.
Expand Synonyms
- Nick Names
- 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:
- AR.IBM_R_CUST_PROFILES
- AR.IBM_R_CUST_ACCOUNTS
- AR.IBM_R_PARTIES
- AR.IBM_R_ACCT_SITES
- AR.IBM_R_SITE_USES
- AR.IBM_R_PARTY_SITES
- AR.IBM_R_LOCATIONS
- AR.IBM_R_CONTACTS_CUSTOMER
- 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)