20 August 2011

How to choose BI vendor?

Announcing the SQL Server Code Name “Denali”
Bill Inmonn started the BI revolution if you want to call it a revolution and started the creation of a new IT solution in Data warehousing and BI.
Microsoft is developing a new great improvement on SQL Server 2008 R2, called SQL Server Code Name Denali (which might be SQL Server 2011). What is it and how can it help you improve your Business results. Watch the demo video below for more information.
They lead the quadrant:

Now that you have watch the video, you might wonder why should I choose Microsoft and not Oracle OBIEE 11gR1 or IBM BI on System z with Linux z and Cognos? Here are some reasons Microsoft can give you!
Top 10 Reasons to Choose SQL Server
Microsoft DBAs run more mission critical databases, when compared to Oracle DBAs.
Source: Microsoft SQL Server and Oracle Database: A Comparative Study on Total Cost of Administration (TCA)
SQL Server delivers six nines (99.9999%) uptime availability.
Source: Microsoft Case Study: Stratus Technologies
SQL Server is the most secure of any of the major database platforms.
Source: ITIC: SQL Server Delivers Industry-Leading Security, Sept 2010
SQL Server is the uncontested leader in TPC-E Performance Benchmarks.
Source: TPC-E Top Ten Performance Results
SQL Server delivers a 460% savings in annual cost of administration per database over Oracle.
Source: Microsoft SQL Server and Oracle Database: A Comparative Study on Total Cost of Administration (TCA)
Microsoft is positioned as a leader in Magic Quadrant for Business Intelligence Platforms.
Source: Gartner, Magic Quadrant for Business Intelligence Platforms, January 27, 2011
Microsoft outpaced the Business Intelligence software market with 23.6% growth based on revenue in 2010.
Source: Gartner, Market Share: All Software Markets, Worldwide, 2010, March 30, 2011
SQL Server overtakes IBM DB2 to claim no. 2 spot in 2009 RDBMS license revenue.
Source: IDC WW RDBMS 2009 Vendor Analysis: Top 10 Vendor License Revenue by Operating environment, August 2010

But offcourse IBM is still not bad either, they have a great offering on Linux z on their System z Servers. Linux is very stable and fast and with the development of BtrFs file system for Linux which has approximately the same advantages as ZFS file system on Unix, you have a cheap and stable and state of art file system with encryption as well:

Business Intelligence

Make faster, better decisions using Linux on System z
IBM Cognos BI for Linux on System z, combined with the IBM Information Server and other IBM information management products, such as IBM DB2, IBM DataQuant, IBM DB2 Alphablox or IBM DB2 Connect allow you to build a comprehensive Information On Demand / Information as a Service solution on System z

Beside IBM DB2 for z/OS, additional data bases are available on Linux on System z, such as IBM DB2 for Linux2, IBM Informix Dynamic Server, Oracle DB or open source data bases, can seamlessly integrated in the data processes. Data from Lotus Domino applications can be integrated as well.
Here is a short video about their Cognos 10 version.

PowerPivot was voted one of eWeek's Top 10 Technologies of 2010.
Source: eWeek 2010 Products of the Year: Messaging and Collaboration
SQL Server reduces downtime by over 20% by migrating an SAP ERP environment to SQL Server.
Source: Microsoft SQL Server TCO Study for SAP ERP Customers

But is SQL Server Denali the best choice for you. A can be seen in my previous blog, Oracle OBIEE 11gR1 saves you 7 cents per transaction on an HP Server. With the new generation EXADATA  server racks you are even cheaper by the cost per transaction and have the best performance, stability and lowest TCO possible with software written for the hardware deliverd.


Monday, January 31, 2011
Gartner Magic Quadrant for BI Platforms 2011
Gartner, a well-recognized information technology research and advisory company, published its Magic Quadrant for Business Intelligence Platforms (link to Oracle reprint, this is the permanent link) for 2011, Gartner RAS Core Research Note G00210036, authored by Rita L. Sallam, James Richardson, John Hagerty, and Bill Hostmann.

Oracle, unsurprisingly, continues to be positioned in the "Leaders Quadrant", for the fifth year running.

Here are some excerpts from the Gartner Research Note (emphasis mine):
Oracle customers indicate they deploy the Oracle Business Intelligence Suite Enterprise Edition (OBIEE) platform to support among the most complex deployments in our survey. Their scope of deployments tends to be the widest across an enterprise — regionally/nationally and globally deployed versus in a single or multiple departments — while OBIEE supports, on average, among the largest numbers of users, the highest data volume, broadest product functionality use, and highest complexity of analytic workload.

Oracle's OBIEE platform is considered the BI standard in more of its customers' organizations (survey respondents) than any other vendor's platform (considered a standard in 85% of their organizations compared to the survey average of 56%).

Some links on Oracle BI:

Here is a small demo video for you:

As you can see there is more to BI then meets the eye, multiple vendors with good products with Dashboards that are great looking and with all the information you need at hand. Should you choose Microsoft, Oracle or IBM solution, or even an other solution like SAS, it all depends on your needs and what your current license costs are and what knowledge is available at you company site for maintenance and extension. For an objective and custom advice about BI renewal or implementation please contact DBA Consulting at info@dbaconsulting.nl



  1. This comment has been removed by the author.

  2. Nice work, keep on posting.Videos gives essential knowledge about server racks.
    Server Racks