建立一个DWH [英] Building a DWH

问题描述

嘿，

我正在建立一个中央DWH，以便能够更轻松地访问数据.我们的组织使用许多小型数据库，因此目前无法轻松组合数据.

目前，我们已经通过SQL服务器将所有单个数据源集中到一台服务器上.现在，我们希望将此数据传输到中央DWH(包括业务规则)，以使合并在一起.

问题是:是否有(便宜的)工具无需编写大量脚本即可将数据集中到DWH中?这会使过程受苦.

谢谢您的帮助.

Gr

解决方案

从SQL Server迁移到SQL数据仓库"，其中概述了一些内容.涉及 将现有数据库解决方案迁移到Azure SQL数据仓库.

希望这会有所帮助.

Hey,

I am building a central DWH in order to be able to access the data more easily. Our organization works with many small databases, which makes it impossible at the moment to easily combine data.

We are currently at the point where we have brought all individual data sources together on 1 server through SQL server. We now want to transfer this data to the central DWH including business rules so that combined comes together.

The question is: is there (cheap) tooling that brings the data together in the DWH without writing extensive scripts? This to make the process suffer.

Thank you for your help.

Gr

解决方案

You may refer "Migrate from SQL Server to SQL Data Warehouse" which provide an overview of what’s involved with migrating an existing database solution to Azure SQL Data Warehouse.

Hope this helps.

这篇关于建立一个DWH的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！