Last Updated: Mar 8, 2023
SQL Datasets are used for large scale data transformations or when you need to combine the data from different data sources, say an Oracle table, Jiffy Table, and CSV data. SQL Datasets are created by using SQL queries. SQL queries can:
The Dataset can be used in Task or Presentation once it is published.
In the Product Inventory Management HyperApp,
The two Datasets must be combined, modified, and the net Product Inventory updated based on the sales. This is done using SQL Dataset.
- The Product Inventory data extracted from the Inventory system has been populated in a Jiffy Table.
- The Product Sales data is received from an external Oracle database.