WebSphere Adapter for JDBC

Enterprise service discovery

You use the enterprise service discovery wizard in the WebSphere® Adapter for JDBC to discover objects in a database and to generate business objects from the selected objects. Enterprise service discovery support also generates the service artifacts that enable the adapter to run as a Service Component Architecture (SCA) component.

You can use the enterprise service discovery wizard to generate business objects from three types of objects in a database. The first type of object includes tables and views, while the second type includes stored procedures and synonyms/nicknames. The third type of object is the query business object, generated from a user-specified select statement.

For the first and second types of objects in the database, enterprise service discovery enables you to discover the objects by generating a list of all the schemas in the database. Within each schema are lists of tables, views, stored procedures, and synonyms/nicknames that you can select, and for which you request the enterprise service discovery wizard to generate the corresponding business objects. The wizard analyzes the metadata of the selected objects and generates attributes in the business objects. The attributes are generated based on the columns of the selected database objects.

Figure 1. Selecting business objects for importThis screen capture is described in the surrounding text.

For the third type of object, the query business object, you specify one select statement. You need to specify the business object name, and the types and dummy values of all the parameters in the where clause. Enterprise service discovery runs this user-specified select statement and analyzes the metadata of the returned result set to obtain the list of columns and their types. After obtaining this information, enterprise service discovery generates one query business object for this user-specified select statement.

Figure 2. Configuration Parameters for Select Statement windowThis screen capture is described in the surrounding text.
To summarize its functions, the enterprise service discovery wizard:
  • Generates a business object corresponding to a database object.
  • Generates attributes in the business object corresponding to the columns in the database object.
  • Sets application-specific information on the business object.
  • Provides service descriptions (outbound and inbound) that are used to generate the import, export, and Web Services Description Language (WSDL) files.
Figure 3. Enterprise Service Discovery functional overviewThis figure illustrates the interaction of the enterprise service discovery wizard, the JDBC enterprise service discovery, and the JDBC enterprise information system (EIS) to discover database objects, gather metadata, and generate business objects and service metadata.

Terms of use |

Last updated: Tue 12 Dec 2006 03:32:38

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