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 continue to be released as erwin Data Models. However, it supports Oracle SQL modeler for Data Model extensions.
The proposed Data Model Extensions are:
  1. Modifying a column of an existing table. Note that only data length modifications are allowed.
  2. Adding one or more columns to an existing table.
  3. 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.