ETL utilizando SqlServer y Postgress con una herramienta de negocios

Więcej takich

Technogym Briefing

przez Dominic Gopal

Deleum Go Live

przez Dominic Gopal

EDULOG - Notes

przez Bob Ruby II

Nextore-carte-conceptuelle-V1.00

przez DIALLO Ramata

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