Adding a Physical Data Model

Physical models are created by selecting the tables and columns you want to include from the data source. You can create multiple physical models that use data from the same data source, but each physical model can only have one data source. For example, a model for a system administrator will include the system tables from the data source, while the model created for end users will have the required data tables from the same data source.

  1. If you have not already done so, use Management Console to connect Spectrum™ Technology Platform to the data sources you want to model. For more information, see Data Source connections.
    To navigate to the Add Data Source page in the Management Console, click Create a Connection link on the page.
  2. In a web browser, go to:

    http://server:port/metadata-insights

    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.

  3. Log in using your credentials.
  4. Click Modeling > Physical Model.
  5. Click the Add Physical Model button .
    Note: You can also choose to create a new model by copying an existing model and renaming it. To do this, on the Models tab, select the model and click on the Copy Model icon. Rename the model on the Copy Physical Model page as needed and click the Save button. For more information about modifying a physical model, see Modifying a Physical Model.
  6. In the Name field, enter a name for the model.
  7. In the Source connection type field, choose the type of data source that you want to model, then select the specific data source in the Source connection name field.

    The Source connection name field displays the data sources defined in Management Console for the connection type you select. For example, if you select Apache Cassandra in the Source connection type field, the Source connection name field will list all the Apache Cassandra data sources defined in Management Console. In case you want to create a new connection for this physical model, click the Create a connection link on the top right side of the page. The Add Data Source page is displayed where you can create the connection, save it, and then use on this page.

    Note: A physical model can have only one data source.
  8. Click Fetch Metadata.
  9. Select the data you want to include.

    To select a table or view, check the box in the Include column for the table or view you want to include. To select all the tables listed in the page, select the Include check-box in the header row. When you select a table, all its columns are included in the model.

    To select specific columns to include in the model, hover over the table containing the columns you want and click the Select columns button that appears.

    You can search for tables on the basis of their name or type using the Filter field above the list of tables. For example, if you want to view only those tables that have names containing the word "new", enter new in the filter field. Similarly, you can filter out tables on the basis of their type. However, you can use only one of the filter criteria, either name or type.

  10. Click Save.

The model is created and is listed on the Models tab of the Modeling page.