You will run a query to find the database objects, Address and
Customer. You will associate a stored procedure with the Address business
object. Finally, you will select these objects to import.
- In the Find and Discovery Enterprise Services window, click Edit
Query.
You can use Edit Query to add business object
application-specific information. You could use Edit Query to narrow the list
of schemas, nodes, or objects displayed in the tree structure. For this scenario,
you do not need to use filtering.
Figure 1. Find and
Discover Enterprise Services window
- In the Query Filter Properties window, check the Add
business object ASI check box and click OK.
Then whenever you add an object when you run the metadata query,
a window is displayed for entering application-specific information (ASI).
Figure 2. Query Filter Properties window
- In the Find and Discover Enterprise Services window, run the metadata
query by clicking 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.
- Search for objects in the list by expanding the ADDCUSER schema
name and expanding the Tables type.
- Click the Address and Customer tables,
and then click >>Add to select the objects for import.
Figure 3. Selecting the objects discovered by the
query
The next
window is displayed because you chose to add business object ASI in step 2.
- In the Configuration Parameters for ADDRESS window, click Add.
The Status Column Name is used only for logical
deletes, and Status Value specifies what values to
update in the column corresponding to the attribute chosen for Status Column
Name. Leave these two parameters as is, because logical deletes are not being
performed in this scenario.
Figure 4. Configuration
Parameters for ADDRESS window
A list of stored procedures is displayed.
- Select CreateSP and click OK. This associates the CreateSP stored procedure application-specific information
with the ADDRESS table. When a Create operation is called on the business
object, the stored procedure specified in CreateSP is called, and performs
the insert operation.
Figure 5. List of stored procedures
to add to the Verb ASI
- In the Configuration Parameters for ADDRESS window, under CreateSP,
type in values for the Schema and Stored
Procedure fields.
Use the following values:
- Schema: ADDCUSER
- Stored Procedure: CREATEADDRESS
- When you enter the Stored Procedure name,
the Stored Procedure Parameters fields are displayed.
Click OK.
Figure 6. Values
for CreateSP
The Configuration Parameters for CUSTOMER window is displayed.
When
you select more than one business object to add, the window to add business
object ASI for the first object is displayed. After you entered the application-specific
information, the same window for the second business object is displayed.
- No stored procedure will be associated with the Customer business
object, so no verb application-specific information needs to be added. Click OK.
- The Find and Discover Enterprise Services window shows ADDRESS and CUSTOMER in
the Objects to be imported pane. Click Next.