Before you can use database services in your business process, you must configure a connection for the database endpoint. This allows the business process to interact with the database. Database endpoints identify a database.
Tip: Configure your database endpoint before you define a service for that database.
In Unwired Orchestrator, access to database endpoints is facilitated by JDBC. Unwired Orchestrator 4.0 supports ASA, ASE, DB2, Oracle, and SQL Server 2000 database endpoints. Sybase ASE and ASA are supported automatically. The JDBC Connection type provides support for any database that provides a JDBC 2.0-compliant JDBC driver. You must register the jdbc drivers for each non-Sybase database to be accessed. Then add at least one endpoint connection.
When configuring an endpoint connection for a database service, you provide the following information:
Display name
JDBC driver class name
Host - the database name
Port
User name
Password
Connection properties
Some of these will be required for one database connection but not for another. Use the documentation for your database to determine the requirements. All databases except the JDBC connection expect name, host, port, user name, password, and jdbc (connection) properties. JDBC connections expect name, JDBC driver class name, database URL, user name, password, and jdbc properties.
Note: If you have problems connecting to any of the databases, refer to the documentation provided by the database vendor. Make sure you have added the vendor-specific JDBC driver file path to the JDBC driver path list. To resolve problems with a JDBC connection, reference Sun Microsystems JDBC(TM) Data Access API FAQ at http://java.sun.com/products/jdbc/faq.html.
Editing, Removing, and Renaming an Endpoint in Endpoint Manager Administrative Tasks
Configuring Endpoints for Database Services