Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database

    Slicing and Dicing Microsofts Freebie BI Tools

    Written by

    Lisa Vaas
    Published June 17, 2004
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      Upon Microsofts release earlier this month of two new, free accelerators aimed at speeding business intelligence by easing data access and scorecard creation, two thoughts occurred: First, that Microsofts handing out of BI tools like they were so much Halloween candy must be driving the proprietors of expensive BI tools nuts. Second, are these tools robust enough to compete with offerings from the likes of Crystal Reports or Cognos?

      BI vendors are indeed scrambling. The fact that theres been so much industry consolidation proves that theyre struggling to cope: Hyperion acquired Brio in the fall; Business Objects acquired Crystal in December; and most recently, Microsoft acquired ActiveViews in April.

      “The BI vendors are scrambling around to add on new features, functionality or even new tools” in the wake of Microsofts entry, pointed out Keith Gile, senior analyst at Forrester Research.

      Indeed, the top vendors well know that theyve saturated the market for high-end analytic reporting and are now trying to branch out to the reporting that gets done by more humble users, Gile opined—think administrative assistant with Excel.

      In the meantime, many if not most enterprises are looking to consolidate on a single BI platform. Steve Berry, president of the BI consultancy and training shop Strafford Technology, told me that the level of interest in Reporting Services is “very significant.”

      It doesnt fit in all cases, particularly in enterprises with more complex needs, but in many cases, customers already have SQL Server databases and are willing to give up some functionality for the price tag—which, in most cases, is zero. If you dont count the cost of licenses for SQL Server, of course.

      But what about the tools themselves? News reports following the accelerators release noted a slew of weaknesses that make them unfit to compete with established BI products.

      As Gile said, its easy to pick on Version 1 of a product. Gile has been telling the many clients who ask him about Reporting Services that he expects it to be a viable production environment in 18 to 24 months.

      Opinions are mixed, however: Berry found the product to be a pretty extensive offering with regards to Web reporting and distribution of reports over the Web, and Adib Khartabil, vice president of professional services at the company, agreed.

      Next page: Which features to look at when considering Reporting Services.

      Drilling Down

      What features are the experts looking at? These things:

      Is the report development mechanism robust enough for power users? Gile finds the report development function of Reporting Services to be “pretty lame,” since it requires a Visual Studio .Net add-in.

      Berry was concerned about the same thing, but when his people got it into the lab, they found that there are a number of third-party tools you can swap in for use as a front end, such as those from ProClarity. Such tools give you much easier interfaces to work with, Berry said.

      No sharing of metadata between reporting platforms. Many of the various proprietary platforms create their own metadata level, meaning you cant leverage that data component from one tool to another. You cant create a Reporting Services report, hit a button and bring it up to work on in Crystal, for instance.

      This isnt Microsofts fault per se and instead has to do with how architectures have evolved, as vendors have attempted to shield hapless end users from the complexity of working in too close a proximity to the convoluted back end of the database.

      Thus we get tools from Brio, Cognos and Hyperion that are, as Khartabil put it, self-serving from a database standpoint, grabbing data from databases and staging it for reporting.

      But then came upstarts such as Brio and Crystal, which allowed users to go directly against the database and get reports fast. Now, we have a situation where every company has its own approach with metadata schemes, since all of those metadata layers are proprietary and prevent sharing.

      Microsoft isnt to blame, but it could and perhaps should take the lead in creating adapters that allow users to seamlessly share reports back and forth. One thing thats holding up others from working in that direction is what Gile says is a paranoia within BI vendors who think that opening up to Microsoft would put them out of business. An understandable fear, but one thats likely short-sighted.

      What will bring us to the holy grail of switching between reporting tools? XML-based reporting, of course. Berry said he knows of at least one company thats got a potential XML-based solution, so keep your eyes peeled for announcements in that direction.

      Tight integration with Office components. Enterprises now need Office developers, Visual Studio developers and SQL Server DBAs, Gile noted. Why isnt Microsofts Office group working more closely with the SQL Server group to make life more cost-effective? Why does the Office group have separate drivers? Why is it a separate group at all?

      If BI vendors are shaking now, just wait until the day when Microsoft pulls all of its disparate parts together and turns out BI tools that bridge the gap between all of those technology islands.

      Write to me at [email protected].

      eWEEK.com Associate Editor Lisa Vaas has written about enterprise applications since 1997.

      Check out eWEEK.coms Database Center at http://database.eweek.com for the latest database news, reviews and analysis.

      Be sure to add our eWEEK.com database news feed to your RSS newsreader or My Yahoo page

      Lisa Vaas
      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2024 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×