What is SQL Dataset

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:

• Fetch the data from existing datasets like SQL Datasets, Jiffy Tables, Document Tables.
• Fetch the data from an external database (mandatory to have an active DB connection).
• Combine data from multiple datasets.
• Transform an existing dataset.

The Dataset can be used in Task or Presentation once it is published.

In the Product Inventory Management HyperApp,

• 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.

The two datasets must be combined, modified and the net Product Inventory updated based on the sales. This is done using SQL Dataset.