A Data Model is a structure that tells WireBootstrap about the objects in your data source so it can create more efficient queries and provide a better user experience when using the data source with WireBootstrap.


To create a data model, begin by clicking on the Data button on the toolbar.



Next, click on the Data Model tab.




Object Tree


The object tree on the left side of the data model panel displays all tables and views in the data source.  These objects are also referred to as data entities.  When drilling-down on an entity tree node, the list of entity fields that are contained within that entity are displayed.



Attributes








To begin setting up entity or field attributes within a data model, select either one from the object tree on the left.  Attributes can then be set up on the model using the panel to the right.




A label is a friendly name for the object that will be used throughout WireBootstrap except for in the object tree on this Data Model tab.  This includes the dataset builder and any presentation components or pages.  If this value is not set, the object name from the data source will be used.



Objects can also be hidden from any other area of WireBootstrap by checking the Hidden checkbox.




The Aggregation drop-down is used to specify how numeric fields should be aggregated inside queries.  For example, a field containing sales numbers would most likely aggregate its data using the Sum aggregation so numbers are totaled when looking at groupings of sales data.  However, a field containing price data may use an Avg aggregation as totaling price data does not make sense in most cases.


This field is disabled for entities.




Field Relationships


Relationships tell WireBootstrap how to join entities together when constructing queries to execute against the data source.  



Relationships are created between fields in two different entities.  To create a relationship while editing a field, locate the second field inside its entity from the object tree on the left.  This field can be located inside any other entity in the tree.  Next, drag the second field into the Relationships table on the right seen in the picture below.



Here a relationship has been created between the [Region].[RegionID] field currently being edited and the second field [Territories].[RegionID].


To delete a relationship, click the trash can icon next to the field in the Relationships table.