- Display objects covered by the query
Click Execute
Query. The AR schema and data elements of the schema are displayed
in the top pane.
- Select the object for import
Expand the AR schema.
Expand Synonyms - Nick Names
Highlight the synonym IBM_C_CUST_PROFILE,
and click Add to Import List to select this object
to be imported.
- Add business object application-specific information
Clink Add in
the Configuration Parameters for IBM_C_CUST_PROFILE window.
Select AfterCreateSP and
click OK in the Add window.
In the
AfterCreateSP area
of the Configuration Parameters for
IBM_C_CUST_PROFILE window,
set the following values:
Click OK.
After a delay, the selected
object is displayed in the bottom pane.
In this sample, you process
data using Oracle's built-in Interface and Base tables. Only the Create operation
is necessary to post both new customer data and updates to existing customer
data. As part of calling the Create operation of the object, the stored procedure
IBM_WEBSPHERE_CUSTOMER_IMP is run using the AfterCreateASI value for the object
to process. This stored procedure moves the data from the Interface to the
Base tables.
- Select remaining synonyms
Select each of the remaining
synonyms (see the following list) and click Add. When
the Configuration Parameters for (name of object) window
opens, just click OK. Do not add the AfterCreateSP
value.
When you are finished, click Next.
The
remaining synonyms are as follows:
- AR.IBM_C_CUST_INTERFACE
- AR.IBM_C_CUST_BANKS
- AR.IBM_C_CONTACTS
- AR.IBM_C_PAY_METHODS
- 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
For information on the object-level, verb, and attribute application-specific
information, refer to "Application-specific information" in IBM
WebSphere Adapters: Adapter for JDBC User Guide. To view that documentation,
see http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/topic/com.ibm.wsadapters602.jca_jdbc.doc/doc/stjdb_welcome.html.