Creating a Model Store - discovery - 23.1

Spectrum Discovery Guide

Product type
Product family
Spectrum > Discovery
Product name
Spectrum Discovery
Spectrum Discovery Guide
Topic type
How Do I
First publish date
To create a new model store, you need to perform these tasks on the Model Store tab of the Modeling page.
Note: While building a model store on a flat file connection, periods (.) if any, in the column name automatically gets converted to underscores (_).
  1. In a web browser, go to:


    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. Log in with your credentials.
  3. Click Modeling > Model Store.
  4. Click Create Model Store icon .
    The Create Model Store page is displayed, listing the Name, Selected Mapping (of the logical model), and Type (physical or logical) of all the available models.
  5. In the Name text box, enter a name for the Model Store.
  6. Select the check box corresponding to the models you want to include in the model store. To select all the listed models, select the Include check box in the header row.
    To remove any selected model, uncheck the corresponding row.
    Note: You can use the Filter type ahead text box to customize the grid display. For example, if the models you want to select begin with the text "Cust", you can type Cust in the filter box, and it will display all the models having "Cust" in their name.
    The selected models get included in the model store. For logical models having multiple mappings, the default selection is displayed when you click for that logical model.
    Note: If you click the Save button without including any model, and error message asks you to include at least one model from the table.
  7. To change the selected mapping of a logical model before including it in the model store, select the option button corresponding to that mapping or union in the Mapping Name column.
  8. To define the cache configuration of the logical models included in the model store, click the respective Cache configuration button.
    Note: The Cache configuration button is displayed after you select the Include check box for the logical model.
    The Cache configuration for model <name of the model> pop-up window is displayed. For details on configuring the cache, see Configuring Cache.
    Note: You can configure the cache of only one logical model at a time.
  9. To save as well as deploy the model store, click Save & Deploy. If you selected a logical model, but did not select all the mapped physical models, a message prompts you to add the dependent physical model as well. Click Yes and proceed.
    For successful deployment of a model store, ensure you avoid these two scenarios.
    • A constituent logical model is not mapped to any physical model.
    • For a logical model, any of its mapped physical model has not been selected for addition.
    The model store gets saved and deployed for use in the client application.
    Note: In case you did not fulfill any of the criteria mentioned above, your model store still gets saved and an error message is displayed indicating that the model store has not been deployed. For more information, see .Deploying a Model Store.
  10. To save the model store and deploy it later, click Save.
A model store needs to be deployed to be accessed from Spectrum Technology Platform as well as other client applications.
  • To deploy a model store, see Deploying a Model Store.
  • To access a model store from within Spectrum Technology Platform, you need to create a connection to it using the Add Data Sources page. For more information, see Connecting to a Model Storein the Administration Guide.
  • To access a model store from a client application other than Spectrum Technology Platform, you need to download the JDBC driver and install it manually. For more information about downloading and installing the JDBC driver, see Installing JDBC Driver.