That's a huge topic. We went with SQL-Server and Analysis Services for our warehouse (for Oracle eBiz ERP) - great tools and platform IMHO.
You really need to figure out how you're going to use the DW and based on that figure out what gives you the features and tools that you need. The ERP has little relevence because ultimately you're going to be transforming the data from the ERP into whatever you need in the DW and that's where the real work comes in.
发布评论
评论（1）
这是一个很大的话题。我们为我们的仓库（Oracle eBiz ERP）使用了 SQL-Server 和分析服务 - 恕我直言，这是很棒的工具和平台。
您确实需要弄清楚如何使用 DW，并在此基础上弄清楚什么可以为您提供所需的功能和工具。 ERP 没有什么相关性，因为最终您要将 ERP 中的数据转换为 DW 中您需要的任何数据，这才是真正的工作所在。
That's a huge topic. We went with SQL-Server and Analysis Services for our warehouse (for Oracle eBiz ERP) - great tools and platform IMHO.
You really need to figure out how you're going to use the DW and based on that figure out what gives you the features and tools that you need. The ERP has little relevence because ultimately you're going to be transforming the data from the ERP into whatever you need in the DW and that's where the real work comes in.