Upload Business Model

You can upload a new model or update/re-build an existing model to the Database Schema. The option to upload a business model is available based on the existing model in the selected Information Domain.

Note the following:

• OFSAAI supports Erwin 9.8, 2018 R1, 2019 R1, 2020 R1, 2020 R2, 2021 R1 and 12.1 generated XMLs in Model Upload process.
• Time to time, Erwin Withdraws support for lower versions. However, one can open the prior version data models using the latest versions of Erwin modeler. You can save it 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 to be uploaded 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, the processing of these datatypes is not supported in OFSAAI.

To upload a Business Model:

1. From the Business Model Upload Summary window, click the Add icon. The Business Model Upload window is displayed.
2. (Mandatory) Enter a Name for the model being uploaded. Ensure that the name specified does not exceed more than 30 characters in length and does not have special characters such as #, %, &, ‘, and “.
3. Select the required Upload Option. The options are JSON / erwin XML, DB Catalog, and Data Model Descriptor. For more information on each option, see the corresponding sections:
   • Model Upload Using JSON / erwin XML
   • Model Upload Using DB Catalog
   • Model Upload Using OFSAA Data Model Descriptor

   Note:

   For subsequent model uploads, you must select the same Upload Option as used in the first model upload. That is, if you selected erwin as the Upload Option for the first-time model upload, then the subsequent model uploads must be done using the erwin option only.
4. Click Upload Model. The model upload execution is triggered and you are re-directed to the Model Upload Summary window 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 depending on the execution.

   Note:

   Index creations are not supported from Apache Hive 3.0 version and higher. To skip the Index creation, You can update APACHE_HIVE_VERSION in the Configuration table and restart FICServer.

   Note:

   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.

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

   Note:

   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.

   Note:

   The Model Upload process is stopped if any errors are encountered. It does not proceed until completion to capture all the errors.