Usage Tracking with Different Database Schema

  To create a Usage Tracking table in a new database schema in a different location:

1. Install base tables for new schema using CreateUT.sql, CreateUTViews.sql, and populateUsageEventData.sql scripts from the installation package.

2. For base schema table, assign access rights for new user.

   Note:

   This is required for next step.

3. Provide additional data view required for usage tracking mechanism using the following example:

   Note:

   This example is one possible solution for providing data access for a source schema user. A database administrator may want to use their own solution for example, creating alias for tables.

   1. CREATE view V8_RESOURCE_BUNDLE AS SELECT * from source_schema.V8_RESOURCE_BUNDLE.

   2. CREATE view V8_PROP_TYPE AS SELECT * from source_schema.V8_PROP_TYPE

   3. CREATE view V8_PROP_VALIDATOR AS SELECT * from source_schema.V8_PROP_VALIDATOR

   4. CREATE view V8_PROP_ENUM_VALUE AS SELECT * from source_schema.V8_PROP_ENUM_VALUE

   5. CREATE view V8_PROP_DEFN AS SELECT * from source_schema.V8_PROP_DEFN

   6. CREATE view V8_PROP_DEFN_CHILD AS SELECT * from source_schema.V8_PROP_DEFN_CHILD

   7. CREATE view V8_PROP_DEFN_ATTR AS SELECT * from source_schema.V8_PROP_DEFN_ATTR

   8. CREATE view V8_PROP_INTERNAL AS SELECT * from source_schema. V8_PROP_INTERNAL

   9. CREATE view V8_PROP_VALUE AS SELECT * from source_schema.V8_PROP_VALUE

   10. CREATE view V8_AUTHEN_CONFIG AS SELECT * from source_schema.V8_AUTHEN_CONFIG

   11. CREATE view V8_CSS_USER AS SELECT * from source_schema.V8_CSS_USER

   where Source_schema is schema used by installed application.

   This script is only one example of many possible ways to provide access for a base schema table's data. Usage Tracking mechanism connects to V8_RESOURCE_BUNDLE table data using "V8_RESOURCE_BUNDLE" alias and new connection.

4. Select Navigate , then Administer , then Reporting and Analysis, and then Usage Tracking to setup new schema connection in Administration module.