Specifying Identical or Unique Schema Values With Corresponding User IDs and Passwords

This section describes the differences of specifying identical or unique schema values with corresponding user IDs and passwords for the iWay Data Profiler (iDP) application and the WebFOCUS repository.

Specifying Unique Schema Values for iDP and WebFOCUS (MYSQL and MSSQL)

During the iDP installation, the following scenario exists:

idp_data is the schema value specified for the iDP application.
idp_repo is the schema value specified for the WebFOCUS repository.
The user ID and password are identical for both schemas.

In this scenario, iDP tables will be created under the idp_data schema and WebFOCUS repository tables will be created under the idp_repo schema.

Specifying Identical Schema Values for iDP and WebFOCUS (MYSQL and MSSQL)

During the iDP installation, the following scenario exists:

idp_data is the schema value specified for the iDP application.
idp_data is the schema value specified for the WebFOCUS repository.
A user ID and password is configured for the idp_data schema.

In this scenario, iDP tables and WebFOCUS repository tables will be created under the idp_data schema.

Specifying Schema Values for iDP and WebFOCUS (Oracle)

In the case of an Oracle database (schema), all tables and related objects are owned by a user account. A user ID and a schema share the same name.

As a result, during an iDP installation, you cannot have different schemas for iDP tables and WebFOCUS repository tables.

The example as described in Specifying Unique Schema Values for iDP and WebFOCUS (MYSQL and MSSQL), would not be valid for Oracle databases.

During an iDP installation, if the selected database is Oracle then the iDP Schema, WebFOCUS Schema, and User Name values must be the same, as shown in the following image.