Preços Iniciar Sessão Cadastre-se

Categorias: Todos - reports

por Galo Diaz 4 anos atrás

204

ETL utilizando SqlServer y Postgress con una herramienta de negocios

In this context, ETL processes using SQLServer and Postgres databases are discussed with a business intelligence tool. The SQLServer database named Northwind is utilized to select specific data from tables such as Customers, Employees, Orders, and Products based on certain country criteria.

Mais informações

Days of the week

por Ulises Cuellar

Using Secondary Data

por Abdulmohssen Albader

Stormdrainage Issues Information

por Harry Ward

LN Update June 2023

por Amir Khan

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')

ETL utilizando SqlServer y Postgress con una herramienta de negocios

In this context, ETL processes using SQLServer and Postgres databases are discussed with a business intelligence tool. The SQLServer database named Northwind is utilized to select specific data from tables such as Customers, Employees, Orders, and Products based on certain country criteria.

Days of the week

Using Secondary Data

Stormdrainage Issues Information

LN Update June 2023

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 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

Mindomo

Mais Informações

Perguntas frequentes

ETL utilizando SqlServer y Postgress con una herramienta de negocios

In this context, ETL processes using SQLServer and Postgres databases are discussed with a business intelligence tool. The SQLServer database named Northwind is utilized to select specific data from tables such as Customers, Employees, Orders, and Products based on certain country criteria.

Days of the week

Using Secondary Data

Stormdrainage Issues Information

LN Update June 2023

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 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

Espalhe a idéia Mindomo

Mindomo

Mais Informações

Perguntas frequentes