This workflow automates the process of exporting data from a SQL database table into a CSV file. When triggered manually, it retrieves data from a specified database table, converts it into CSV format, and saves it as a downloadable file. This is useful for database reporting, data analysis, or sharing information externally.
The workflow begins with a manual trigger, allowing the user to initiate the process at will. It then sets the target table name (in this case, ‘SalesLT.ProductCategory’) using a Set node. The next node connects to a Microsoft SQL Server database, executing a SELECT query to load all data from the specified table. Finally, the data is passed to a spreadsheet file node, which converts it into a CSV format and saves it locally with a filename based on the table name.
This setup can be easily customized for different tables and file formats, making it versatile for frequent data export tasks in business intelligence, reporting, or archival scenarios.
Reviews
There are no reviews yet.