Starting with Wyn Enterprise 8.1, the Cached Dataset designer supports adding one result set from an ETL flow that is the result of applying transformations in the ETL Designer. ETL stands for Extract, Transform, Load which can be used to apply several different kinds of transformations before returning the result set as a table in the dataset This result set can then be joined with other result sets returned from other datasets, tables from data sources, or custom SQL tables.

To add an ETL flow to a Cached Dataset press the Add ETL button in the toolbar. 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 a source in the Cached Dataset.

The ETL Designer section describes the new ETL Designer and the transformations that you can apply in an ETL flow.