1. Analytical Application Infrastructure User Guide
  2. Data Model Management
  3. OFSAA Data Model Extensions through the SQL Data Modeler

OFSAA Data Model Extensions through the SQL Data Modeler

OFSAA out-of-the-box Data Models are released as erwin Data Models. However, it supports Oracle SQL Modeler for the Data Model Extensions.

The proposed Data Model Extensions are:
  • Modifying a column of an existing table. Note that only data length modifications are allowed.
  • Adding one or more columns to an existing table.
  • Adding one or more tables.

    A SQL Modeler template is released by Oracle Financial Services Data Foundation Pack (Enh 29467329 - SUPPORT FOR DATA MODEL EXTENSION USING ORACLE SQL MODELER) that must be used for all customizations. Refer to the Patch Readme and guidelines for more information on the process.