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 version 9.8 generated XMLs in Model Upload process in addition to ERwin 9.7, ERwin 9.6, ERwin 9.5, ERwin 9.2, ERwin 4.1, ERwin 7.1, and ERwin 7.3 generated XML files.

·       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 OFS AAAI Application Pack Installation & Configuration Guide available in the OHC Documentation Library.

·       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 are not supported in OFSAAI.

To upload a Business Model:

1.      From the Business Model Upload Summary window, click   Add button The Business Model Upload window is displayed.

2.     Enter a Name for the model being uploaded (mandatory). 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 Erwin, DB Catalog, and Data Model Descriptor. For more information on each model upload option, see the corresponding sections:

a.     Model Upload Using Erwin

b.    Model Upload Using DB Catalog

c.     Model Upload Using OFSAA Data Model Descriptor

 

NOTE

For subsequent model uploads, you should select the same “Model Upload Option” as used in the first model upload. That is, if you did “New” model upload using Erwin, then the subsequent model uploads should be done using 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 once the process completes, the status is updated as either Success or Failed depending on the execution.

 

NOTE

To display the current upload status, you need to have a connection pool established to access data from the database. For more information on connection pooling, see OFS AAAI Application Pack Installation & Configuration Guide available in the OHC Documentation Library.

 

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

 

NOTE

Model upload will be successful even if object registration fails. In such case, you should 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

During model upload if any error occurs, model upload process will be stopped. It will not proceed till end to capture all the errors.