Query DB without querying

The HR department stores data about a survey that they have conducted on the employees in a database table. Your goal now is to access the database and read the data table in KNIME Analytics Platform. You will need three nodes for this: the SQLite Connector, the DB Table Selector and the DB Reader node.

Note that SQLite is a file-based lightweight database that does not require a separate server process, thus it is perfect for this example. In real-world situations, you will more likely connect to other databases such as MySql, PostgrSQL and so on, that require credentials for authentication.

If you lost any progress, browse your Local space, click on the introduction-to-knime folder, and load the 2_2_bulk_read_20_files workflow from the Exercises folder.