You can add entities to a Cached Data Model from a Data Source or a Dataset. With Wyn 8.1, you can now get data into a Cached Data Model from an ETL flow which fetches data from data sources as before, but you can also apply a series of transformations to the extracted data before it is loaded into the data model.

ETL stands for Extract, Transform, Load, which can be used to apply different kinds of transformations before returning the result set as an entity in the data model. This result set can then be joined to other result sets as usual.

To add an ETL to a Cached Data Model, select from ETL from the Get Data drop-down. You are then presented with the ETL Designer where you can add one or more Input Sources and connect them to ETL commands to transform the input data and finally output the result to an Output Target command. The result of the ETL is the result set from the Output Target which gets added as an entity in the Cached Data Model.