SQL Server 2000 Reporting Services Overview SQL Server
- Slides: 24
SQL Server 2000 Reporting Services Overview 박명은 과장/기술사업부 한국마이크로소프트
비즈니스 리포팅 현황 기업내에서 요구 되는 보고서들 현시점에서 각 리 포팅 솔루션에 대 한 현황 SQL Server Magazine Online Poll 44% - Custom Reporting solutions 45% - 3 rd party Reporting solutions 4% - Don’t do much reporting 7% - Satisfied with what we have (5/2003)
리포트 전달 Ø Ø Ø 전통적인 방식과 상호작용가능한 리포트들 On-demand (“pull”) or event-based (“push”) 전달 방식 Microsoft Office System 과 완벽하게 통합 multiple formats (html, Word, PDF, XML)으로 export 가능 Any device로 리포트 전달 가능
Reporting Services 아키텍쳐 Browser Data Sources (SQL, OLE DB, XML/A, ODBC, Oracle, Custom) Custom Application Office XML Web Service Interface Security Services (NT, Passport, Custom) Report Server Report Processing Output Formats (HTML, Excel, PDF, Custom) Data Processing Security Rendering Scheduling & Delivery SQL Server Catalog Delivery Targets (E-mail, Share. Point, Custom)
서버 구성안 : 소규모 조직 Database and Data Sources Reporting Server Oracle Reporting Services SQL Server DB 2 Flat Files OLEDB, ODBC, . NET SQL Server 2000 Windows Server Client
서버 구성안 : 대규모 조직 Data Sources Database Server Reporting Server Web Farm IIS Oracle Reporting Services Windows Server IIS SQL Server Report Metadata Reporting Services Windows Server DB 2 SQL Server 2000 Flat Files OLEDB, ODBC, . NET IIS Reporting Services Windows Server Client
다양한 확장 방안 단일서버 구성 Config. A Report Server DB Config. B Web-Farm Configuration 에 버 서 0 0 0 r 2 Report r e v Report r e S Server L Server Q S s 기존 <OR> rvice e S e g e n r i t F r 용 비 Repo 이센스 Standard Report Server Web-Farm 구성 분리 서버 구성 Report Server 이 라 시 사용 Standard Report Server DB Enterprise Report Server DB * Optional Server * Data Sources
SQL Server 2000 Reporting Services 홈페이지 (korea) http: //www. microsoft. com/korea/sql/reporting 2월 중순부터 한글 정품 CD 배포가능 한글 평가판 다운로드 사이트 http: //www. microsoft. com/sql/reporting/productinfo /trial. asp#download
- Sql server reporting services architecture
- Reporting services 2000
- Dts xchange
- Mssql ce
- Sql server 2000 sp
- Sql server 2000 activity monitor
- Sql server 2000
- Microsoft sql server 2005 analysis services
- Sql server predictive analytics
- Sql server master data services
- Sql server analysis services 2012
- Windows server 2000 caracteristicas
- Master data services overview
- Sql azure reporting
- Epm live project publisher
- Objectives of printing
- Sql server report builder
- Fidelity personal trust services
- Difference between pl/sql and sql
- Sql developer unit testing
- Azure sql server advanced data security
- Sql server virtualization
- Sql security best practices
- Sql server security basics
- Sql server 101