In-Database Processing on SQL Server

This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server Connector node. It then shows column filtering, row filtering, aggregation, joining, and sorting. Many more in-database processing operations are possible either via nodes with graphical UI such as the ones below or via the Database Query node. The Database Query node in fact allows for custom manual SQL queries. The Database Connection Table Reader node at the end of most branches here passes the data into KNIME Analytics Platform. The Database Connection Table Writer node in the last branch writes the data into a new table in the SQL Server. In this last case, the data never leaves the SQL Server. Data for this example come from the new CENSUS dataset which is publicly available and can be downloaded from: http://www.census.gov/programs-surveys/acs/data/pums.html