InformationsBrcken schlagen

1
Informations-Brücken schlagen
Event vom 26.01.2005 in Aarau

• Neues vom SQL Server

Referent Werner Durrer
2
Neues vom SQL Server

• Reporting Service (Rekapitulation)
• Architektur
• Im Einsatz
• Neuerungen im Service Pack 2
• SQL Server 2005 Yukon
• Komponenten und Verwaltung
• Nutzen
• Neuerungen im Bereich
• Management
• Reporting Services
• Analysis Services
• Data Mining

3
Reporting Services

• Lücke mit Reporting Services geschlossen
• Launch 27. Januar 2004
• Was sind die Reporting Services
• Addon für SQL Server 2000 / integriert in Yukon
• Komplettes Set zur Erstellung, Verwaltung,
  Visualisierung und Auslieferung von Reports
• Letzte Meile des Business Intelligence (BI)
  Frameworks
• Kosten / Lizenzen
• Reporting Services sind lizenzfrei
• Lizenzierter SQL Server 2000 für Meta-Daten

4
Architektur
Browser
Office
Custom App.
Web UI
XML Web Service Interface
XML WS
Reporting Server
Report Processing
SQL Server
Security
Data Retrieval
Data Sources
AnalysisServices
Rendering
Scheduling Depl.
SQL Server Catalog
5
RS im Einsatz - Web-UI (Grafik)

• .NET Web User Interface (C)
• Reporting Services in Applikation integriert

6
RS im Einsatz - Web-UI (Drill down)

• Interaktiver Drill down Report

7
Neuerungen im Service Pack 2

• Roll-up Bug Fix seit SP1
• Neue Erweiterungen
• Client-Side Printing
• Neue SharePoint Web Parts zum Anzeigen und
  Durchsuchen von Reports auf dem Reportserver

8
SQL Server 2005
A Complete Enterprise Data Management and BI
Solution
Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Data Transformation Services ETL
SQL Server Relational Engine
9

• High availability for enterprise applications
• Key security and performance features
• Focus on self manageability and optimization

• Integration with Visual Studio and .NET
• Native XML technology
• Interoperability via Web Services

• Real time decision making reporting, data mining
• Rich client and SharePoint solutions
• Comprehensive ETL solution up to 600 faster

10
BI Development Studio

• A complete, integrated tool for the development
  of BI applications
• One tool, multiple technologies
• Relational, OLAP, DM, DTS, Reporting, Code, Web
  pages
• Enterprise software development environment
• Integrated into Visual Studio.NET
• Team development, source control, versioning,
  developer isolation, resource independent coding
• Development cycle lifetime support
• Develop, Test, Deploy, Modify, Test
• Breakthrough ease of use

11
Reporting Services

• Introduced with SQL Server 2000
• Open, extensible enterprise reporting solution
• Report authoring, management, delivery
• Office System integration
• VS.NET development environment
• SQL Server 2005 enhancements
• Integration with AS, DTS, management tools
• Developer enhancements
• Improved report interactivity
• Rich end-user reporting

12
Analysis Services

• Unified Dimensional Model
• Integrating relational and OLAP views
• Pro-active caching
• Bringing the best of MOLAP to ROLAP
• Advanced Business Intelligence
• KPIs, MDX scripts, translations, currency
• Web services
• Native XML/A

13
Data Mining Focus

• Complete set of analytics
• Most popular data mining algorithms (5 new)
• Enhanced creating, editing, and viewing
  environment
• Embedded data mining
• Embed data mining in LOB applications
• Complete SQL language based API
• Native XML/A support
• Integrated solution
• Tight integration with Relational, OLAP, DTS,
  Reporting technologies
• Comprehensive SQL Server BI platform
• Alliance with ISVs
• Focus on broadening the market
• Agreed on finalizing DM industry standard based
  on OLE DB for DM and XML/A

14
Informations-Brücken schlagen

• Fragen

15
So erreichen Sie uns

• Kull AGEntfelderstrasse 25000 Aarau
  (Switzerland)Tel [phone]Fax 41 62
  824 2718
• E-Mail info_at_kull.chHomepage http//www.kull.ch