IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Configure the module for deployment > Configure the module for inbound processing
Discovering database objects
After configuring the connection properties, run a query to search for database objects. Browse through the discovered objects navigation tree to understand the structure of objects in the Oracle database and use filters to display only the database objects you want to see.
You must know the data requirement of the program that requires to access the database.
For example, you need the following information about your database:
- Which schemas your module requires to access
- What type of database objects you require to access in those schemas
This task starts in the Find Objects in the Enterprise System window of the external service wizard.
Procedure
- In the Find Objects in the Enterprise System window, click Edit Query. The Specify the Query Properties window is displayed.
The Create a query business object to build user-defined select statements is available only for outbound processing.
Use the Specify the Query Properties window to perform the following tasks:
- Reduce the search time by searching a subset of database schemas
- Omit one or more types of database objects from the search
- Make the wizard prompt you for application-specific information that cannot be automatically determined based on information in the database
- Map the Oracle data types Date and Timestamp to date and dateTime
- To limit the number of database schemas that are retrieved, type the name of the schema or a name pattern in Schema name or pattern. Use the question mark or underscore (? or _) character to match a single character and the asterisk or percentage sign (* or %) to match multiple characters. Only schemas that start with that string or match that pattern are displayed when you run the query. If you do not specify a schema name pattern, all schemas in the database are displayed. Using a filter can speed up the discovery process if your database contains many schemas.
- To omit one or more types of objects from the search, select the types of objects that you want to omit (tables, views, and synonyms or nicknames) in Supported database object types, and then click Remove. If you change your mind, click Add to add the object type back. If your database contains object types that you do not need to access, omitting them can speed up the discovery process.
- Select the Prompt for additional configuration settings when adding
business object check box. Then, when you add a database object to the list of business objects to create, the wizard automatically prompts you for all user-configurable
application-specific information for the object.
For example, if you select this option, the wizard guides you through the process of building a simple parent-child hierarchy of business objects. If you need a hierarchy, that a table business object has two attributes referring to attributes in two different tables (that is, it has two parent business objects), complete the configuration in the IBM Integration Designer assembly editor.
If you do not select this option, the wizard prompts only for required information. You must complete the configuration of the business objects using the assembly editor.
- Click OK to save your changes to the query.
- In the Find Objects in the Enterprise System window, click Run Query to use the query to discover database objects. The result of running a typical query is shown
in the following figure.
The Discovered objects pane lists the objects that were discovered. The tables, views, and synonyms/nicknames are sorted by schema name.
- In the Discovered objects list, click + (the plus sign) to expand a schema node and the Tables, Views, and Synonyms - Nicknames nodes to see the database objects discovered by the wizard.
Results
The wizard has discovered the database objects you can access using the adapter.
What to do next
Continue working in the external service wizard. The next step is to select the objects you want to use in your module, configure each business object, and create hierarchies of business objects.
Configure the module for inbound processing
Next topic: Selecting and configuring business objects
Related concepts: