ETL utilizando SqlServer y Postgress con una herramienta de negocios

Più simili a questo

PTRS Exam

da Angel Chavez

NIMBUS REGRESSION - VECC

da Chad Cook

My SAP

da rohan poovaiah

Collections

da Helen Philip

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