Physical models are created by selecting the tables and columns you want to include
from the data source.
- You can create more than one physical model from one data source
(connection). 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.
- You cannot use multiple data sources to create a physical model.
To create a physical model, perform these actions:
-
On the Discovery menu bar, click Model.
The Logical Model tab is displayed by default.
-
Click the Physical Model tab.
-
Click the Add Physical Model button .
You can also choose to create a new model by copying an existing model and
renaming it:
-
Select the check box next to the existing model and
click on the Copy Model button .
-
If necessary, rename the model on the Copy
Physical Model page.
-
Click the Save button.
-
In the Name field, enter a name for the model.
-
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 for the selected connection type. For example, if you select
Apache Cassandra in the Source connection type field,
the Source connection name field lists all the Apache
Cassandra data sources you have defined in the system.
In case you have not already defined a connection or want to create a new
connection for this physical model, you can do this using the Add
Data Sources page. Access this page through the
Data Sources tab or via Management
Console module.
-
Click Fetch Metadata.
-
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 based on 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 based on their type. However, you can
use only one of the filter criteria, either name or type.
-
Click Save.
The new model is created and listed on the Physical Models tab
of the Modeling page.