Specify the Connection to the RDBMS

Complete Installation and Upgrade Information for webMethods and IBO Products : Installing webMethods and Intelligent Business Operations Products : Creating and Dropping Database Components : Use the Database Component Configurator Graphical User Interface : Create Database Components, Database User, and Storage : Specify the Connection to the RDBMS

Specify the connection for the configurator to use to connect to the RDBMS.

1. In the RDBMS list, click the RDBMS in which to create the database components.

2. In the URL field, provide the URL for the RDBMS. Sample URL formats for the DataDirect Connect JDBC 5.1 driver are displayed. Below is additional information for completing this field.

For Oracle, if you are going to create storage and the Data Purge database component, you must specify the sysLoginRole connection option on the URL (for example, ;sysLoginRole=sysdba).

For DB2, if you are going to create database components in a schema other than the default schema for the specified database user, you must specify these connection options in the URL, where AlternateID is the name of the default schema used to qualify unqualified database objects in dynamically prepared SQL statements:

;AlternateId=schema;"InitializationString=(SET CURRENT
PATH=current_path,schema)"

Important:

If you are creating Optimize database components (that is, Analysis and ProcessTracker), you must specify schema using all uppercase letters. In addition, you must specify the options CreateDefaultPackage=true,ReplacePackage=true, and DynamicSections=3000. These settings will affect all database components in the same schema or database.

For information about options supported by the DataDirect Connect JDBC 5.1 driver used by your products, including options that support clustering, data encryption (SSL), and different authentication methods, see DataDirect Connect for JDBC User's Guide and Reference 5.1 in the Software AG_directory /_documentation directory or on the Software AG Documentation Web site.

3. In the User ID and Password fields, your entries depend on the task you are going to perform, as described below.

Note:

You can choose to specify this authentication information in the URL, using DataDirect options, rather than in these fields.

If you are...

Specify...

Creating a database user and storage in Oracle or SQL Server

The database user and password to create.

Note:

For SQL Server, the user will be created and a default schema named dbo will be assigned to that user.

Important:

For Oracle, do not use the SYSTEM user to create the database components in the SYSTEM schema.

Creating a database user and storage in DB2 for LUW

The OS user to which to grant permissions, and the password for that user.

Creating database components or performing the catalog action

An existing database user and password.

Performing the checkEncoding action

An existing database user that has create session and create table privileges, and that database user's password.

Contact Support | Community | Feedback