ETL utilizando SqlServer y Postgress con una herramienta de negocios

configurar odbc postgres power bi.txt

Generar Reportes

Database connectios

SQLServerConn

PostgresConn

Table Input

Table Ouput

Utilizar la Base Northwind

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

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 ProductID, ProductName, Discontinued from Products

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

Instalar psqlodbc_x64