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