Icon

00.2_​Setup_​PostgreSQL_​Database

00.2_Setup_PostgreSQL_Database
Setup PostgreSQL database1. Connect to your local PostgreSQL database. In the Credentials Configuration component, provide the username andpassword. In the PostgreSQL Connector node, specify the hostname, the database name, and the port. If you followedour guide, the default parameters should be: Hostname: localhost Database name: postgres Port: 5432 Username: postgres Password: the password you provided during the installation2. Execute this workflow. This workflow writes tables "customers", "contracts", "statistics" to PostgreSQL database.These tables in the database will be used in the further exercises. Part 1 - ETL ProcessingExercise 00_Setup_PostgreSQL_Database CustomersContractsStatisticsCustomersContractsStatistics Table Reader Table Reader Table Reader PostgreSQLConnector DB Writer DB Writer DB Writer DB CredentialsConfiguration Setup PostgreSQL database1. Connect to your local PostgreSQL database. In the Credentials Configuration component, provide the username andpassword. In the PostgreSQL Connector node, specify the hostname, the database name, and the port. If you followedour guide, the default parameters should be: Hostname: localhost Database name: postgres Port: 5432 Username: postgres Password: the password you provided during the installation2. Execute this workflow. This workflow writes tables "customers", "contracts", "statistics" to PostgreSQL database.These tables in the database will be used in the further exercises. Part 1 - ETL ProcessingExercise 00_Setup_PostgreSQL_Database CustomersContractsStatisticsCustomersContractsStatistics Table Reader Table Reader Table Reader PostgreSQLConnector DB Writer DB Writer DB Writer DB CredentialsConfiguration

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Lada.Rudnitckaia
Created at: 2021-11-24
On NodePit since: 2022-11-01
Last update: 2024-11-23
Created with KNIME version: v4.5.2
Tags: EducationData engineeringData engineerBest practices

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!