About this article
Once a Data Source has been create you populate it with content consisting of Schemas and Items. This article will explain how to add schemas and items. Sections in this article:
- What is a Schema?
- What are the different Shema field types?
- How to create Schemas in Data Sources?
- Content (items) of a Data Source
What is a Schema?
A schema is a set of instructions that determine what information will be stored in a particular data source column and the type of data that the information will take the form of. Within a schema, you will have the ability to create the columns of a data source that hold different types of data such as normal text, numbers, images, languages, or a reference to another data source. Data sources are structured like relational databases meaning that one data source can be referenced by one or several other data sources.
What are the different Shema field types?
When you add a Schema to a Data Source you are presented with various types of fields, each explained below:
A Text Schema allows you to add items with text string.
A Number Schema allows you to add items with numbers.
An Image Schema field allows you to upload images to Data Sources. Please go to the article: How to upload images to Data sources? to read more about images in Data Sources.
Languages will need to be added to Resources, before they show up in the dropdown in the Schema field. To do so, please have a look at the article: How to add Languages for Data sources?
One type of data that can be specified in a schema is a
reference. Selecting reference allows the user to refer to another Data Source for the value in the current data source. The rule of thumb for using references is that, when building a data source, if you find yourself manually filling in the same fields with the same value, it is a good idea to build a new data source for that value and refer to it in other data sources.
When setting up a reference in a schema, once the
Type has been selected, you will be presented with another drop-down of the other data sources that exist in the tenant. Choose the data source to refer to, whether it is a required field and a default value for the column (not required). Below is an example the Office data source referring to the Country data source:
External reference field
The external reference field is similar to the existing reference field, however, it provides the connection between two tables; the external data and the internal/tenant data.
The external reference works as a "look up" field inside Dynamics Designer and can locate data in the related External Data source.
The external reference is not validated when uploading templates in Library management or internally in Resource management.
How to create Schemas in Data Sources?
- Select the Data Source
- Go in Schema tab
- Fill in the Schema field
- Name: Name of the column
- Type: Data type (text, number, image, language, reference)
- Required: Mandatory value when creating items
- Default value: Default value when creating items
Content (items) of a Data Source
Now that you have created your data source and its schema, you can add items to this data source.
- Select the Data Source
- Fill in the desired/required information