September 29, 2004
Microsoft boosts BI
Upcoming and current databases to benefit
Recommend ThisMicrosoft is bolstering BI and reporting features in both the existing SQL Server 2000 database and the planned SQL Server 2005 release.
The company has been focused on improving BI in SQL Server for the past few years. Tuesday’s announcements link applications such as Exchange and CRM to the company’s BI fray.
Available now for free, SQL Server Report Packs for Exchange Server and CRM enhance the SQL Server 2000 Reporting Services function by providing templates of commonly used reports for users to modify for their own custom reports, according to Microsoft. These particular templates would supplement the Microsoft Exchange Server and Microsoft CRM 1.2 systems. Reports that be developed include one that would gauge who has the largest Exchange e-mail folder or who is sending and receiving the largest set of e-mail.
“Customers want to build reports off of Exchange,” said Alex Payne, senior product manager for SQL Server at Microsoft. “We’ve done the heavy lifting for them. We’re providing the templates.”
Microsoft also said it has begun shipping Microsoft Operations Manager (MOM) with SQL Server Reporting Services. The company is providing sets of reports based on Reporting Services for use with MOM. Additionally, the Visual Studio 2005 development tool due next year will feature reporting controls that can be embedded to more easily build applications with SQL Server Reporting Services.
Data Transformation Services, an ETL engine that has been part of SQL Server 2000, will be renamed SQL Server Integration Services and will feature extended extraction, transformation, and loading capabilities and the ability to consume Web services and load them into a database. Microsoft SQL Server Integration Services will be included in SQL Server 2005 next year.
Also, the ActiveViews technology Microsoft acquired for ad hoc reporting will be renamed Reporting Services Report Builder and will be part of SQL Server 2005. It will debut in a third beta release of SQL Server 2005 set for release at the end of this year.
SQL Server Analysis Services, which ships as an OLAP and data mining engine in SQL Server, will be enhanced next year to feature new data mining algorithms and clustering of data. Algorithms cover functions including classification, regression, segmentation, association, and forecasting as well as text mining and sequence analysis.
Also being added to SQL Server Analysis Services is the ability to develop key performance indicators in the engine, such calculating day sales at a retailer.
Paul Krill is an editor at large at InfoWorld.
White Paper
D2D Virtual Tape Library Replication Primer
This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.
Download now »
White Paper
An Alternative to Virtualization for Datacenter Cost Savings
Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.
Download now »
White Paper
Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network
The emergence of WLANs has created a new breed of security threats to enterprise networks.
Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation
White Paper
Bringing the Edge to the Data Center
Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.
Download now »
- Your Browser Wears No Clothes – Why Fully Patched Browsers Remain Vulnerable | White Paper
- Outdated Browsers and Zscaler: An Overview | White Paper
- How Zscaler Tackles Emerging Web Threats with High Speed, Real-Time Content Inspection in the Cloud | White Paper
- How Hackers are Targeting Enterprise Users via Web 2.0 Browser Exploits | White Paper
- Blocking Malicious Content with Zscaler | White Paper
Sign up to receive Data Management Resource Alerts
Make IT work as one. Register for Novell BrainShare 2010. Complimentary Energy Efficiency Kit - Cut Energy Costs NowRestrict internet access with GFI WebMonitor™. Now 30% Off! www.gfi.com/web-filterToday’s IT means business. New eBook shows you how to align your IT investments.A new level of interoperability. Make IT Work As One at novell.comLimited-time offer: Save up to $100 on Polycom phones. 64-page prescriptive guide to security, compliance, and IT operations.Learn about Foundations of Green IT, from CTO Marty Poniatowski802.11n Drives an Architectural EvolutionSee IBM CloudBurst's self-service user interface in action
Return on Information: Google Enterprise Search pays you back. Get the facts.Analytics: Use your data to drive insights that enable better decisions.See how AT&T can help protect your network. Make IT Work As One at novell.comHP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.HP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.Unified Communications: Thoughts, Strategies and Predictions. Join the discussion.Increase UPS efficiency without sacrificing protectionIn less than 45 minutes, Palisade Systems protects your dataA smarter approach to IT is needed. That smarter approach is IBM CloudBurst.
