By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
SAS takes off the kid gloves
Despite the fact that SAS is by a long way the largest business intelligence vendor in the market, it has regularly had to listen to claims from Business Objects and Cognos that these are the leading suppliers in the BI space.
The reason for this is that Business Objects and Cognos have largely had the mid-market for BI to themselves, while SAS has focused on the high-end, sophisticated stuff. Well, no more: SAS is taking off its kid gloves and plans to get down to some real bare knuckle stuff and it intends to take on its erstwhile rivals on their own patch.
Actually, it's not just the BI vendors it plans to take on but just about every aspect of business intelligence, in its widest sense, including ETL, data profiling, data cleansing, data warehousing: you name it.
As a point of fact, SAS has had pretty much all of these solutions for some time but they have disparate, disjointed and not fully fledged. With the release of SAS 9.1, which was first mooted earlier this summer and will become generally available towards the end of the year, it will have a much more complete and integrated platform at a technical level, which will from the basis of its higher level horizontal and vertical solutions.
As far as the technical platform is concerned, this will consist of SAS ETLQ, which is the company's ETL and cleansing tool; SAS Intelligent Storage, its data warehousing solution; SAS Business Intelligence; and SAS Analytic Intelligence. However, while covering the products you can buy, this doesn't tell the whole story.
Let's start at the back end. Here, in SAS Intelligent Storage, you can store data in three ways: in SAS data sets, the SAS Scalable Performance Data Server or in SAS OLAP Server. While the first and third of these should be obvious, the second is a parallel, multi-threaded database in much the same way that DB2 or Oracle is. Except that it doesn't have any of the transactional paraphernalia that they do.
On top of the storage product, SAS is introducing the SAS Metadata Server, which provides a consistent metadata layer that is leveraged by all relevant SAS products. This product (though it is not available separately) conforms to the CWM (common warehouse metamodel) standard but SAS is also building a wide range of meta brokers to support non-CWM products.
In terms of tools, the first is not actually ETLQ but is the data profiling and analysis capability provided by Dataflux, which is a wholly owned SAS subsidiary. The same company also develops data cleansing and quality control software, but this is embedded with ETLQ. This is pretty much unique in the way that it supports the extraction of data. While you can extract data in the normal way, you can also, if you have Base SAS installed, transform the data on the source system and then extract it. This should provide significant performance improvements during the extraction process.
At the front-end, it is in SAS Business Intelligence that the company is introducing some significant new features. In particular, SAS wants to offer a BI environment that caters to as wide an audience as possible within the organisation. To this end the product will ship with five different user interfaces: SAS Web Report Studio, a J2EE thin client, for "information consumers"; SAS Add-in for Microsoft Office, for those familiar, particularly, with Microsoft Excel; SAS Report Studio, which provides desktop-based reporting and is aimed at power users; SAS Enterprise Guide, which is fully .NET enabled and is targeted at business analysts; and, finally, administrative interface for managing metadata, developing business intelligence applications, and managing the BI environment. In addition there is, of course, the SAS Portal, which spans its BI and analytic products for presentation purposes.
The question is how successful SAS will be at competing directly with the likes of Business Objects and Informatica. This is by no means merely a technology issue and the answer remains to be seen. However, what is clear is that SAS no longer intends to give its smaller competitors an easy ride.
Copyright 2003. Originally published by IT-Director.com, reprinted with permission. IT-Director.com provides IT decision makers with free daily e-mails containing news analysis, member-only discussion forums, free research, technology spotlights and free on-line consultancy. To register for a free e-mail subscription, click here.
For more information:
- Looking for free research? Browse our comprehensive White Papers section by topic, author or keyword.
- Are you tired of technospeak? The Web Services Advisor column uses plain talk and avoids the hype.
- For insightful opinion and commentary from today's industry leaders, read our Guest Commentary columns.
- Hey Codeheads! Start benefiting from these time-saving XML Developer Tips and .NET Developer Tips.
- Visit our huge Best Web Links for Web Services collection for the freshest editor-selected resources.
- Visit Ask the Experts for answers to your Web services, SOAP, WSDL, XML, .NET, Java and EAI questions.
- Couldn't attend one of our Webcasts? Don't miss out. Visit our archive to watch at your own convenience.
- Choking on the alphabet soup of industry acronyms? Visit our helpful Glossary for the latest lingo.
- Discuss this article, voice your opinion or talk with your peers in the SearchWebServices Discussion Forums.