Feeds

Weird scenes inside the BI gold mine

The rush for Business intelligence

Combat fraud and increase customer satisfaction

Comment If there is a gold mine in the software industry right now it is surely business intelligence. However, the business intelligence market is supposed to be consolidating and commoditising. In that case, why is it that there are a whole bunch of new vendors and products entering the market?

I have spoken with four in just the last couple of weeks. Perhaps that's not weird, but it is certainly interesting. And even well-established players are coming up with innovative and fresh approaches to queries and reporting. Information Builders, for example, is very active in developing new ways in which business intelligence, particularly at the operational level, can be used. However, that is a story for another article, as are the other three newbies: the one I want to discuss today is ICS.

ICS (www.icsltd-uk.com) is a well-established (over 10 years old) service company focused on the BI market. Its client list includes household names in both the public and private sector. While this isn't actually the first product the company has launched, it is the first the company expects to have a significant impact on the market and it has given the product, RSinteract, its own website (www.rsinteract.com) to prove it.

RS (as the astute among you may have guessed) stands for Reporting Services, as in SQL Server Reporting Services and RSinteract is a tool for building and deploying reports based on Reporting Services. So, why would you want to use this in preference to the facilities provided by Microsoft?

To answer that you need to understand the options offered by Microsoft. With the previous version of SQL Server your only option was to use the Report Builder in Visual Studio. However, this is a developer tool. It is fine for building rich, strictly formatted reports and forms but it isn't much use if you want to generate an ad hoc report and it is not suitable for end users.

To meet the needs of business users for less formal reporting, with SQL Server 2005 Microsoft has introduced a second product called Report Builder. While this is fine for quick, simple things, it has a number of drawbacks. First, it requires you to download a smart client. Secondly, it has a different semantic data layer (because it is based on acquired technology) from SQL Server itself. Thirdly, you can only have one report on a page, you can't display a chart and its data together, there is a restricted set of templates, the editor is separate from rather than a part of the product. I could go on, but you get the idea.

What ICS has done is build a tool that not only overcomes these issues but has much greater applicability. So, for example, it is a zero footprint product on the client, the editor is built in, there are extended template definition and reuse capabilities, there are additional report types supported, you can mix and match data and charts, you can create compound reports, and so on. The company has not yet built in support for the SQL Server semantic data layer but it will do so in due course.

As yet the company is only selling direct, and within the UK, however it is actively seeking re-sellers and partners both here and abroad. Target markets are both end-user organisations and ISVs that might want to use RSinteract to build reports into their own products.

Copyright © 2006, IT-Analysis.com

High performance access to file storage

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.