Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Examples
  • 40_Partners
  • 01_Microsoft
  • 01_SQL_Server_InDB_Processing(Azure)
WorkflowWorkflow

In-Database Processing on SQL Server

ETL KNIME Microsoft Azure In database Processing
+1
KNIME profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
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

Used extensions & nodes

Created with KNIME Analytics Platform version 3.3.2
  • Go to item
    KNIME Connectors for Common Databases Trusted extension

    KNIME GmbH, Konstanz, Germany

    Version 3.3.1

    KNIME profile image
    knime
  • Go to item
    KNIME Core Trusted extension

    KNIME GmbH, Konstanz, Germany

    Version 3.3.2

    KNIME profile image
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item
Loading deployments
Loading ad hoc executions

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits