Data Stitches
A Data Stitch is the core concept behind Sheetloom.
A Stitch is essentially an object in Sheetloom configured by an Administrator containing an SQL query or script, source data connection details, and optional query parameters.
Each time Sheetloom runs, it picks up the definitions of these Stitches and executes them, fetching the latest data and injecting it into a defined Excel named range or tab that has been mapped to the Stitch.
When complete, a new Excel spreadsheet is created from the template supplied.
This ensures data is consistently and accurately returned, and eliminates the human error and time of copy-pasting data.
Stitches are the building blocks of data and queries can be as big or as small as required.
Each Stitch can contain only one query.
Sheetloom can run multiple queries, but does not join between data sources.