Data sources
A data source defines where the data that will be processed in the survey, is loaded from. A data source can either load data objects from Omada Identity or SQL objects from a SQL data source.
Fields in the data source are mapped to relevant fields on the survey object.
Generally, you will want to apply filters to the returned data objects. This is done differently depending on what data source you use, and whether you want to use scope variables in the filters.
SQL data source
With a SQL data source, the survey object is loaded with data resulting from executing a SQL query. This can be relevant if, for example, you want to run a survey loaded with resource assignments from the Warehouse (ODW).
There are some considerations you want to acknowledge when writing the SQL query for a survey. Refer to the Data Sources chapter for details.
Filters for SQL data sources are written in the query. It is possible to use scope variables in the query.
A SQL survey supports multiple rows per object in order to allow multivalued fields.
Data object’s data source
A Data object’s data source loads data objects of one or more Omada Identity data object type in the survey.
Data source fields:
Values on the data object type are mapped to relevant fields on the survey object.
The value mapped to the survey object can either be the value of a property on the source object itself, the result of a reference path expression, or the value of a fixed field.
There are some rules on how properties can be mapped. See the Data Sources chapter for detailed information.
Data source filters:
You can define any number of filters to the data object’s data source . The filters are used to limit which data objects are loaded into the survey. Data source filters can only be applied to an Omada Identity data object source.
The right-side of a data source filter can be the name of a scope variable. By using this it is possible to limit which data objects are loaded into the survey based on the selections made by the user who launches the survey on the survey initiation screen.
You can use a reference path expression to define a filter on a referenced property.
Scope variables
Scope variables allow you to define variables that can be used to filter the data objects returned in the load from the data source when a survey is launched. These are the scoping options available to the user launching the survey.
The scoping options can be configured to allow, for example, limiting the scope on a resource assignment survey for identities that belong to a certain org. unit.
Scope variables can also be used in a SQL query data source.
Child object reference property
This property allows you to define which property will be used for parent/child surveys. When not set, a standard survey will be generated.
Data sources Markup language
A survey template is authored in the SurveyTemplateML xml language. The schema definition file, SurveyTemplateML.xsd.
Attributes
The table below lists the available attributes for dataSource:
| Attribute | Description |
|---|---|
| Type | Indicates if data should be loaded from Omada Identity (dataObjects) or from SQL (sqlObjects). |
| Name | The name attribute can be used to add a descriptive name to the data source. |
| DataObjectType (dataObjects only) | The system name of a data object type in Omada Identity. |
| ConnString(sqlObjects only) | The Name of a data connection object. Data connection objects contain a connection string to a database. |
| Threshold | Controls the number of objects loaded into the survey.It can be used during testing of a survey template to prevent that more than a certain number of objects are loaded.The threshold setting should only be used for testing purposes. |
| childObjectRefProperty | This property is optional. It is a system name of a reference property on the data object type of the data source. If provided, survey questions will be generated for the values of this reference property on the data objects retrieved from the data source. |
The table below lists the available attributes for dataSourceFields:
| Attribute | Description |
|---|---|
| KeyField | Denotes the key field in a SQL query. |
| Field | DataObject survey. Denotes the field in the data source. Field should be either: The system name of a property, the name of a fixed field only these are allowed: Id, CreatedBy, DisplayName, or a reference path.SqlObject survey: Denotes a column name in the query |
| mapTo | The objectType property the field is to be mapped to. |
| datatype | It is possible to specify the dataType of the field. This is however not a requirement. |
| mapFrom | This is an optional property. Only applicable if the childObjectProperty is set for a data object type data source. The attribute is used to determine if the data source field should be mapped from the parent or the child object. |
dataSource filters
A dataObjects data source can have a number of data source filters. The right-side of a data source filter can be the name of a scope variable. For more information, see the Data source filters section.
The table below list the available attributes for dataSourceFilter:
| Attribute | Description |
|---|---|
| Path | The reference path to a data object type. |
| Left | The system name of the field (property) the filter will apply to. |
| Operator | The match requirements for the right side Possible values:
|
| Right | The right side of the filter. Can be a scope variable. |
Scope variables Markup language
The scopeVariables controls the scoping options that are available to the user in the initiate activity of the survey process. The scoping options can be configured to allow, for example, limiting the scope on a resource assignment survey to resource assignments belonging to a specific system.
Attributes
The table below list the available attributes for scopeVariable:
| Attribute | Description |
|---|---|
| Name | The name of the scope variable. |
| Title | The text that is displayed in the user interface. |
| Property | Specify the objectType property the scope variable relates to. |
| DataType | The dataType of the property. Possible values: Reference String DateTime Boolean* Integer |
| Requires Value | True/False. If set to True the scope variable must be set when launching the survey. |
| DerivedValues | A reference path that is evaluated using the scope variable's referenced data object(s) as starting point. |
| DeriveLevels | The number of recursions to make if using derivedValues. |
| ShowInUI | Whether or not the scope variable should be displayed in the survey initiation activity. |
<scopeVariables>
<scopeVariable name="@system_var" title="Include assignments for resources belonging to this system" property="SYSTEMREF" dataType="reference" requiresValue="true" />
<scopeVariable name="@changedlaterthan_var" title="Only resource assignments that have been changed since this date" property="DEADLINE" dataType="dateTime" />
</scopeVariables>
Scope variables in Filters
Scope variables can be used in data source filters (if the data source type is dataObjects) and in a SQL query (if the data source type is sqlObjects).
DerivedValues
On a scope variable it is possible to state a derived values expression. The purpose is to be able to make a survey of (for example) all identities belonging to a certain org. unit as well as all identities belonging to all descendant org. units.
<scopeVariables>
<scopeVariable name="@orgunit_var" title="Include assignments for identities belonging to this org. unit (and all below)" property="OUREF" dataType="reference" requiresValue="true" derivedValues="\PARTENOU" deriveLevels="3"/>
</scopeVariables>
In the attribute derivedValues it is possible to specify a reference path that is evaluated using the scope variable's referenced data object(s) as starting point. In the attribute deriveLevels it is possible to state the number of recursions to make. In the example we only want to go 3 levels down the org. tree.
The example above is based on org. units, but the feature supports all reference properties.