PASS Community Summit 2008: Program Sessions (Business Intelligence)

Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools

Presenter:
Christian Bremeau (Meta Integration Technology, Inc.)

Co-Presenter:
John Friedrich (Meta Integration Technology, Inc.)

Session Details

Microsoft's data integration and business intelligence (DI and BI) suite of tools based upon the SQL Server platform (Integration, Analysis, and Reporting Services, or SSIS, SSAS, and SSRS) comprise a rich opportunity for metadata integration with other popular modeling tools.  In particular, data modeling tools, such as CA ERwin Data Modeler, may contain and/or maintain the metadata required for source and/or target DI specifications in SSIS, SSAS relational databases.  Other design tools, like Kalido, maintain warehouse and BI designs which may be forward engineered into SSAS.  In addition, with multiple producers and consumers of metadata there is a great need for multi-vendor metadata management, as well as end-to-end lineage and impact analysis.  This session will explore the means by which these other vendors are able to exchange relational, OLAP and reporting design metadata with SSIS, SSAS and SSRS.  In addition, the session will show end-to-end lineage and impact analysis for complete IM solutions based upon a collection of the products.  Finally, the metadata management implications of such a heterogeneous environment will be discussed.

Register Now for PASS Community Summit 2008!