News

Microsoft Updates BI Tool

Microsoft on Wednesday released an updated version of a tool to help system integrators and other Microsoft partners build business intelligence applications atop SQL Server.

The 1.2 release of the SQL Server Business Intelligence Accelerator extends support down to the Standard Edition of SQL Server 2000, adds support for XML data imports and supports Office 2003, which has not yet been released.

At its core, the tool allows an architect to map out a business intelligence solution on an Excel worksheet, including data sources and targets. The tool then uses the Excel worksheet to set up and trigger services from SQL Server, including Data Transformation Services and Analysis Services, to build the BI application. The original version came out in May 2002 and supported only the Enterprise Edition of SQL Server 2000.

For a back-end tool, the Accelerator has been fairly popular with about 10,000 downloads, according to Microsoft. Most of the interest is among Microsoft partners, but advanced users at some companies have used the tool to build their own custom BI applications.

The changes in the new version are relatively minor and driven primarily by partner feedback, says Tom Rizzo, group product manager for SQL Server.

“We heard from partners that they really wanted to work on [SQL Server 2000 Standard Edition] as well. It allows a partner to go into smaller shops and deploy a solution,” Rizzo says. Support for XML-formatted files also plays into partner requirements, he says. Service providers can brand their own front-end application as part of a service offering to build the BI application and drive the data into the Accelerator via XML. Or partners can write pure code and use XML to push it into the Accelerator, rather than having to find some way to get it into Excel first.

Other features of the 1.2 version are separation of application generation and deployment processes to speed the time to production and support for “drill-through actions in count measures [that] enhances the reporting capabilities of the generated application.”

To download or find out more about the SQL Server Accelerator for Business Intelligence, visit www.microsoft.com/solutions/bi/.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • Report: Cost, Sustainability Drive DaaS Adoption Beyond Remote Work

    Gartner's 2025 Magic Quadrant for Desktop as a Service reveals that while secure remote access remains a key driver of DaaS adoption, a growing number of deployments now focus on broader efficiency goals.

  • Windows 365 Reserve, Microsoft's Cloud PC Rental Service, Hits Preview

    Microsoft has launched a limited public preview of its new "Windows 365 Reserve" service, which lets organizations rent cloud PC instances in the event their Windows devices are stolen, lost or damaged.

  • Hands-On AI Skills Now Outshine Certs in Salary Stakes

    For AI-related roles, employers are prioritizing verifiable, hands-on abilities over framed certificates -- and they're paying a premium for it.

  • Roadblocks in Enterprise AI: Data and Skills Shortfalls Could Cost Millions

    Businesses risk losing up to $87 million a year if they fail to catch up with AI innovation, according to the Couchbase FY 2026 CIO AI Survey released this month.