3.5. Summary
In this chapter we described how the Microsoft BI toolset maps to industry standard terminology. We made a compelling argument that you can build your entire business intelligence system using software only from Microsoft. You're not tied to Microsoft for your entire project, however: the components are "open," in the sense that they are linked together by published interfaces. If you wish, you can use a non-Microsoft product for any component of your DW/BI system. Many people will develop a heterogeneous DW/BI system—it's particularly common for an enterprise to require the relational database or front end tools to use the corporate standard.
We described the basic recommended architecture of a Microsoft DW/BI system and introduced the studio tools—SQL Server Management Studio and BI Development Studio. We will provide much more information about these tools in upcoming chapters.
Get The Microsoft® Data Warehouse Toolkit: With SQL Server™ 2005 and the Microsoft® Business Intelligence Toolset now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
