ETL Northwind

About this Project

Data integration on the Northwind dataset. Created in the Business Intelligence course.

Getting Started

Installing

1. Clone this repository

2. Up the docker

   docker-compose up -d

3. Create the transactional database (Northwind)

   localhost:8081

   Sistema: Postgres

   Servidor: db_postgres

   Usuário: postgres

   Senha: root

4. Restore the backup

   cat ./postgres/dump/Northwind\ -\ POSTGRES.backup | docker exec -i pdi_db_postgres_1 pg_restore -v -h localhost -U postgres -d Northwind

5. Create the dimensional database (DM_Northwind)

6. Run the SQL

   cat ./postgres/model/modelo\ dimensional_postgre.sql | docker exec -i pdi_db_postgres_1 psql -U postgres -d DM_Northwind -a