1. Analytical Application Infrastructure User Guide
  2. Data Model Management
  3. Upload Business Model
  4. Model Upload Using DB Catalog

Model Upload Using DB Catalog

The Database Catalog (DB Catalog) feature is used to generate a business model out of the database catalog information.

You can use this when a database physically exists, and the business model has to be reverse-generated for OFSAA metadata references. The reverse model generation feature can also be extended to RDBMS based Infodoms. This Model Upload process populates:
  • OFSAA logical model abstraction layer, that is, the JSON files for the Infodom.
  • Object registration repository.

    Note:

    erwin is the primary and boot-strap mode to register the Data-Model with the OFSAA ecosystem. The DB Catalog option does not take care of the logical artifacts. Hence, do not consider DB Catalog as a replacement for erwin.
To perform Model Upload using the DB Catalog option:
  1. From the Business Model Upload window, select Upload Options as DB Catalog.

    Figure 7-6 Business Model Upload window for DB Catalog


    This image displays the Business Model Upload window for DB Catalog.

  2. Select the Upload Mode from the drop-down list. You can select New only for the first upload. For subsequent uploads, you can select Rebuild. For more information, see the Model Upload modes section.
    • If the table details are specified in the $OFSAA_HOME/conf/dmm/Input_DBCatalog_Objects.properties file, then the application selects the specified tables for DB Catalog. The Entity Filters are not available selection if the table details are specified in the properties file.
    • If the table are not specified, then the application will upload all the tables from the database.
  3. Specify the Entity Filters by entering details in the Starts With, Contains, and Ends With fields. The Filters are patterns for entity names in the Database and can restrict the Database Model generation to a specific set of entities. The Database Model is generated even if one of the specified filter conditions matches.
  4. You can also specify multiple conditions for a single filter type using comma-separated values. For example, tables starting with TB and TM can be specified as “TB, TM”.
  5. Click Upload Model.