ETL utilizando SqlServer y Postgress con una herramienta de negocios

Lisää tämän kaltaisia

Information

luonut Владислав Швець

Deleum Go Live

luonut Dominic Gopal

School Yearbook

luonut Mindomo Team

QAB Spring Projects

luonut Sheila Hyde

Cubo de datos

ETL utilizando SqlServer y Postgress con una herramienta de negocios

Postgres

Instalar psqlodbc_x64

SQLServer

select EmployeeID, LastName+' '+ FirstName as EmployeeName, BirthDate, City, Country from Employees

select ProductID, ProductName, Discontinued from Products

select O.OrderID, O.CustomerID, EmployeeID, OrderDate, ProductID, UnitPrice, Quantity, Discount from Orders as O inner join [Order Details] OD on O.OrderID = OD.OrderID inner join Customers as C on O.CustomerID = C.CustomerID where Country in ('Germany', 'Mexico', 'UK', 'Spain', 'France', 'Brazil', 'Venezuela', 'USA')

select CustomerID,ContactName, ContactTitle, Address, City, Country from Customers where Country in ('Germany', 'Mexico', 'UK', 'Spain', 'France', 'Brazil', 'Venezuela', 'USA')

Utilizar la Base Northwind

Pentajo

Table Ouput

Table Input

Database connectios

PostgresConn

SQLServerConn

Power BI

Generar Reportes

configurar odbc postgres power bi.txt