SQL Server Alternatives
We’ve talked mostly about SQL Server mainly because Microsoft has focused not just on enterprise level BI, but also on the needs of smaller companies. David Hobbs-Mallyon, SQL Server product manager, claims: ‘Right from the start, Microsoft has
If your client has a licence for the Standard or Enterprise editions of SQL Server then you already have the tools you are likely to need. But what if they haven’t? Are there alternatives? Yes. However, remember that BI can produce huge returns on investment (ROI) which equate to huge sums of money and, generally speaking, that means that software companies charge concomitantly large sums for their wares. Products such as IBM Cognos’ TM1 are typical: TM1 offers ‘fast, easy-to-use analytics for financial performance management’ and the entry level price for the Enterprise edition is around $75,000.
The open source industry has a couple of alternatives: two of the biggest players are Jaspersoft and Pentaho. Their products are aimed at enterprise customers and ‘open source’ is certainly not synonymous with cheap (it pays to remember that open source refers to the code base, not the licensing model). Jaspersoft’s Business Intelligence Suite Professional Edition, for instance, will cost significant money; you need to apply to the company for a specific quotation.
Several companies, Birst, for example, offers free BI to get you started and then charges monthly costs depending on the features you select. There is also Adersoft’s OlapCube 1.1 for a mere £58 for a single user license: it is capable of creating local cubes from data stored in many relational databases, including Microsoft Access, SQL Server and its Express version, Oracle, Oracle Express, MySQL and others.
www.cognos.com/products/tm1
www.jaspersoft.com
www.pentaho.com
www.birst.com
www.olapcube.com
Click here to go to the main feature - Business Intelligence for Small Businesses with SQL Server
RECENT COMMENTS
I just followed the instructions provided in this blog and found it quite helpful. Well, I managed t...
I came across your article and firstly want to thank you for an informative piece of writing. I am i...
To echo the other comments here this is an excellent article and much easier than anything I have se...
Nice tutorial but its better to show each and every thing with screen shots
I recomend Sharepoint doc*ment management software http://www.enovapoint.com/jungledoc/sharepoint-do...