1. Analytical Application Infrastructure User Guide
  2. Data Model Management
  3. Upload Business Model

Upload Business Model

Upload a new model or update/re-build an existing model to the Database Schema.

This option is available based on the existing model in the selected Information Domain.

Note:

  • OFSAAI supports erwin 9.8, 2018 R1, 2019 R1, 2020 R1, 2020 R2, 2021 R1 and 12.1 generated XMLs in Model Upload process.
  • Periodically, erwin withdraws support for lower versions of data models. However, latest versions of erwin modeler allows opening the un-supported versions of the data models. You can save the data model <input required> as a repository file with the OFSAA supported versions.
  • By default, OFSAAI supports Data Model up to 2 GB. To configure the permissible size specific to requirements, see the Frequently Asked Questions section in OFSA AAI Installation Guide.
  • Ensure that the XML file you want to upload is saved in All Fusion Repository Format.
  • Datatypes of TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE are supported for Model Upload. However, OFSAAI does not support processing of these datatypes.
To upload a Business Model:
  1. From the Business Model Upload, click the Add, to view the Business Model Upload window.
  2. Enter the model Name .
    This is a mandatory step. Ensure that the name does not exceed 30 characters and does not have special characters such as #, %, &, ‘, and “.
  3. Select the required Upload Option (JSON / erwin XML, DB Catalog, and Data Model Descriptor.

  5. Click Upload Model. .
    The model upload execution is triggered and you are re-directed to Model Upload Summary with the upload details in the summary grid. The Status of current upload is indicated as Running and after the process is completed, the status is updated as either Success or Failed based on the execution.

    Note:

    • Index creations are not supported from Apache Hive 3.0 version and higher. To skip the Index creation, update APACHE_HIVE_VERSION in the Configuration table and restart FIC Server.
    • To display the current upload status, you must have a connection pool established to access data from the database. For more information on connection pooling, see OFSA AAI Installation Guide

      Click View Log to view the model upload details and also Download Log File to a location for reference.

    • Even if the object registration fails, the Model Upload process will be successful. In such cases, you must manually do the object registration by running the Command line utility for Object Registration, since object registration is mandatory for subsequent model upload to be successful.
    • The Model Upload process is stops if there are any errors. It does not proceed until completion to capture all the errors.