Evaluating Business Intelligence Options for Software developers

667481 members! Sign up to stay informed.

Sponsored Links

Resources

Enterprise Java
Research Library
Get Java white papers, product information, case studies and webcasts

Industry news Industry news Industry news	Messages: 1 Messages: 1 Messages: 1 Printer friendly Printer friendly Printer friendly Post reply Post reply Post reply XML XML XML

Evaluating Business Intelligence Options for Software developers Posted by: Mandrid James on November 15, 2007 DIGG (AP) Increasingly application developers are required to include flexible and extensible reporting options within their core product sets. This is not only being driven by CIO's, who rank Business Intelligence in the top 3 of priorities, but also their end users – the business users who are becoming more BI savvy, and whose expectations are growing. The essential BI elements sought after by end users in any integrated BI solution include: 1. Dashboards 2. Ad Hoc Reporting Functionality 3. Ease of use And all of this needs to be web based too! For the software vendor Business intelligence as a business function continues to evolve from being primarily a downstream, after the fact application silo, into a value-added, integrated component of packaged and custom applications. This in conjunction with greater awareness of BI is driving software vendors to deliver a comprehensive BI solution as a module of their solutions. For the vendor this means that they can either develop a solution from scratch in-house or integrate a 3rd party BI package into their product suite. In the past application developers have traditionally gone the in-house development route to meet their BI needs. The benefits of In-house BI development is a reporting solution 100% integrated into the core product, hence the usability, look/feel and navigation will be consistent with the core application. The in-house option is fraught with difficulty however. For the vendor, with a speciality in a functional space, they do not have the time, expertise, resources, budget to build an enterprise quality reporting solution, In house design/builds also risk lengthy delays, design and construction complications and final product results that miss the expectation of the design phase – not to mention the sales / marketing teams. The engineering time associated with these delays and cancellations are very expensive and lead to opportunity costs of missed sales and revenue potential of a rapid go to market model. The trend for developers is now to reduce coding time and where code effort is needed to dedicate that time/effort to the core functionality. To do this developers must fill the gaps in function with other vendors products, be that commercial or open source options. Speed to market and leading BI capability are the prime drivers for the selection of an embeddable BI solution. With embeddable being the key point here. In delivering a BI module to their clients the software vendors needs to search out a solution that can be highly integrated into their existing solution and sold as a seamlessly integrated module. After-all in the customers eyes they are purchasing an additional module from their vendor and do not want to deal with the complexity of a 3rd party. The 3rd party integration option faces the difficulty of searching out other vendors products that achieve the required functionality, yet also integrate into the core products. Developers can try to pursue a tight integration or failing that they must bridge the two applications suites in a manner that does not confuse the end user. Bridged software can work well, but the end user will need to deal with two sets of navigation and differences in look/feel. For Business intelligence, most solutions are designed for stand alone usage, such that any attempts to embed them can be uneven. For example BI products such as Crystal and Microsoft Reporting services which are easier to embed, still suffer the legacy of the GUI world – they require client side software to be distributed to enable access. Time and budget are always the constraining factors in the development and go to market cycle, so the business and architectural decisions in choosing any 3rd party business intelligence tool must include: 1. Its ability to be integrated quickly to save develop time, 2. Its high level of stability and functionality to minimize on going product support ; and 3. a cost sensible solution to allow customers to make easy buy decisions. If your core solution is currently selling for $100.00 per seat, it will not make sense to choose a BI add on that will drive that cost to $500.00 per seat. The BI module has to be inline with your pricing model.. In choosing a solution based on commercial aspects a "total cost of development" evaluation framework is required by which a vendor can anticipate their design results and minimize financial risk. This framework embodies a cost-based analysis of factors that include: • The total time to market, • the cost of development, • development tool cost, • maintenance and support costs; and • The cost of runtime licenses. This is essential in making any solution choice be it opens source or commercial. One of the main choices in choosing a 3rd party BI solution is whether to go open source or a commercially supported solution. The commercial solution (or paid for open source) has dedicated professional development/releases and a commercially focussed company backing it or alternately one could look to an open source product, that is free to use, with a potentially inconsistent code base, uncertain development timelines, limited documentation, possible integration issues, but again at the end of the day is free. In Business Intelligence, open source projects like BIRT, Jasper or Pentaho offer developers products developed and maintained by strong communities. However, if integration and ongoing support costs are too great or not definable, then the developer may well be better off going with a commercial option. Commercial options for software vendors include Crystal Reports, Pentaho (Enterprise), Jasper (Enterprise), Microsoft Reporting Services, and Yellowfin. Tier 1 products such as Cognos and Business Objects have been excluded since their highly priced commercial models and minimal integration options exclude them for the majority of software vendors as viable options. Most software developers want to develop applications that are: 1. Platform independent to enhance their market potential. This means they are transportable across database technologies and OPSYS platforms. If this is the goal then BI platforms that lock a vendor into a platform must be excluded – for example Microsoft Reporting services which is to restrictive with DB options. 2. Browser based – so their BI solution must deploy with zero client footprint. 3. Integrated Security – so a highly flexible security framework is required. Many solutions only provide role based security and not data level security – which tends to be the core of most transactional application. Crystal Reports was once the embedded reporting solution of choice. However, changes in ownership, and licensing, and the lack of reasonably priced ad hoc have had a huge impact on the embedded Crystal Market with Vendors looking elsewhere. In terms of a product with a unique licensing model and functionality that is suited to the software vendor on solution stands out - Yellowfin. Yellowfin offers a pure browser based solution built on Java for n’platform support. Not only does it include its own drag and drop report writer but also supports BIRT and Jasper for added flexibility. The most interesting aspect though is the pricing model. Unlike traditional licensing schemes Yellowfin works with each of its partners to set and share the revenue generated by the end customer. This approach is different and its main benefit appears to be simplicity and profitability for both Yellowfin and the software developer. Yellowfin also has arguably the best dashboard concept and usability for business end users. As a browser based solution designed from the ground up to be integrated into 3rd party applications it is unique. It offers dashboards, ad hoc ROLAP and MOLAP reporting, analytical functionality and a comprehensive meta-data layer. JasperSoft and Pentaho both claim to be the most downloaded open source business intelligence software, and have very similar BI stacks. Their Suites are comprised of an interactive reporting server, graphical and ad hoc report design interfaces, OLAP, analysis, an ETL tool for data integration. Both offers an Enterprise version, which we assume is commercially packaged, installable, supported and documented. However, the licensing cost for the enterprise variant brings the cost of either option on par with tier 1 competitors such as Business Objects leaving little in terms of value added differentiation. The choice for software vendors in embedded BI solutions is not an easy one. There are a multitude of options available to them. However, the main considerations need to be one that has the right level of functionality, is affordable; is easy to embed and most of all easy to use by their end users. The BI component of any application needs to be considered a core marketing tool – after all the sizzle created by a dashboard can be the difference between a sale or not.

	Message #242798 Post reply Post reply Post reply Go to top Go to top Go to top

Re: Evaluating Business Intelligence Options for Software developers Posted by: niceware niceware on November 19, 2007 in response to Message #242689 They are best softwares and best price. The list is not full and now will be more new version, any more need, please mail me: ftpone@hotmail.com Amtec Tecplot 10.0 Bernina Artista 4 COADE CAESAR 4.50 COADE PVELITE2005 COADE TANK2.50 COADE CADWORX_PIPE2004 CypeCAD OLGA2000 v4.13 Flarenet 3.51 PIPENET 9.0 Plant design management system 11.6 Pdms REVIEW 6.2 Powercad 6.0 I-sktech 2.50 I-convert 3.3 I-view&adata I-run I-spoolgen I-tools Prokon Structural Design & Analysis 2004 Quickbooks Point Of Sale v4.0 2020.Kitchen.Designer.6.1 ADAPTSOFT.ADAPT.PT.V7.0 Applied.Flow.Technology._Fathom.v6.0 AceCad StruCad v11 ADINA 8.3 AEA TECHNOLOGY HYPROTECH HYSYS V3.2 Manual Amira 3.1 ANSYS all products V11 Ansys LS-DYNA 9.70 Applied Flow Technology Arrow v3.0 Applied Flow Technology -impulse 3.0 ArcGis desktop 9.2 ARTCAM 6 AspenTech Aspen ICARUS Products v12.0 aspen 12.1 3CD Autocad 2008 Autodesk Revit Series v6.1 Autodesk Viz 2007 Autodesk Civil 3D Professional 2007 Autodesk Survey 2007 Autodesk Land Desktop 2007 Autodesk Architectural Desktop 2008 Autoform 4.04 BENTLEY SERIES Cad Cam Procam 2000 Cadpipe 2002 demo(with crack) CADSTAR v7.0 Cfdesign 7.0 Chaos Systems TopoCAD v7.0.3 Chem CAD 5.1.3 Chemoffice Chem office Ultra 2004 v8.0 ChessBase 9.0 Chief Architect 10.08 Full Cimatron E6 Civilcad2004 CSI ETABS NL V10 CST Microwave Studio 5.2 CypeCad 2003 DELCAM POWERMILL V5.0 ISO DYNAFORM 5.5 EDS FEMAP V8.3 Embroidery - Wilcom Es v9.0 Elcad 7.10 EPCON APITECH DATABASE V3.0-LND Eplan 5.50 Esko Graphics ArtiosCAD 6.02 ESI PAM-STAMP 2G V2004 Euroglot Professional 4.01 EViews 5.0 FastShip.v6.1.25 Festo FluidSIM 3.5 Flarenet 3.51 FloorPlan Floor Plan 3D v8.0.32 Fluent mixsim 1.74 Galaad v3 GIBBSCAM V8 GRAPHISOFT DUCTWORK FOR ARCHICAD V9.0 GRAITEC ADVANCE STEEL SUITE V5.2 HTFS2003 HYDROSOFT NAVCAD V4.23 HYSYS V3.2-LND IDECAD 5.14 INFORMATIX PIRANESI V4.0 IMOLD for Solidworks 20-20 Kitchen Designer 6.1 LUSAS FEA V13.6 Matlab 7.0 Mecsoft Visualmill 5.0 Service Pack 4 Mechsoft For Solidworks 2004 Midas Civil v6.3-LND MIDAS GEN V6.3.2-LND MIDAS SET V3.2.1-LND Minitab 14.12 modelsim 6.0 NeuroDimension NeuroSolutions v4.32 Developer.Edition Nemetschek Allplan 2005 Office dl 517 geoslope OnyxTREE Professional Suite v6 procast 2005 PHOENICS 3.5.1 Plaxis 8.0 Plaxis 3d tunnel v1.2 Proteus 6.5 & Librerias Quickbooks Point Of Sale v4.0 Rhinoceros v3.0 SR3 Rebis AutoPIPE v6.20 Robot Millennium v19 Robot Office v17.5 Sas 9.0 ScanVec CASmate Pro 6.52 Schlumberger PIPESIM v2003 Siemens Simatic Step7 V5.6 Siemens Simatic TeleService 5.2 Simsci Pro II 6.0 Simsci Pipephase 8.1 Simci vitural flow 4.1 SolarWinds Engineers Edition v5.5 STAAD PRO V2004 SURFCAM 2004 Tecplot v10.0.4 Tekla Xsteel Structures 13 Teksoft ProCAM II V2006 Tina Pro v6.008 ucam 6.23 VANTAGE Plant Design products AVEVA(PDMS 11.6) Wilcom-V9 VX.CAD.CAM.V10.91 ZEMAX 10.0 Xfdtd 6.0.6.3 Anything you need ,anything I try to get for you ,just contact me: ftpone@hotmail.com

Recent active threads Recent active threads Recent active threads

More More More

	IPhone App Development with JSF
	Web as the Platform: Day 1 at the Ajax Experience
	Need help for login page using java servlet
	Stateful Webservice in java
	SAP Asks Sun/Oracle to Let Java Be Free
	Registration for TheServerSide Java Symposium Las Vegas now open
	Use Sun SPOTs as your build canary
	AspectJ In Action Published; Sample Chapters Posted on TSS
	WSO2 goes all RESTy
	Return to previous view after user action

More active threads »

Top posters of the weekTop posters of the weekTop posters of the week

This list contains the members who have made the most posts in all forums over the last 7 days: Dan Evans James Watson William Louth sara foster Chief Thrall

Hot threads Hot threads Hot threads

More hot threads More hot threads More hot threads

Object pooling is now a serious performance loss

Brian Goetz continues to lift the lid and peak into the inner workings of Java in Java Urban Performance Legends. In this article he exposes the fallacy behind some of the more common performance myths found in the annals of the JVM.
(93 comments, last posted February 06, 2009)

Beyond Java

Bruce Tate, author of Better, Faster Lighter Java and Bitter EJB has come out with a new book called Beyond Java. Bruce has an epiphany about the future of software development. Does it include Java?
(770 comments, last posted September 23, 2009)

Three forms of AJAX: solid, liquid and gas.

Looks like today AJAX concept have several interpretations. We can distinguish different approaches of AJAX integration. Can they co-exist within the same application? Can we talk about layered AJAX integration?
(68 comments, last posted May 08, 2008)

Design-Time API Promises to make Java more like VB

Artima has published a short article describing the Design-Time API for JavaBeans, which was recently approved as JSR 273. This API promises to bring VB-like ease to Java development, but may face a cultural bias among Java developers who tend to think more in terms of class libraries than components.
(225 comments, last posted November 19, 2009)

Will Sun be that target of a management buyout?

There is plenty of speculation today regarding a potential buyout of Sun Microsystems by Scott McNealy and Silver Lake Partners. How would privatization of Sun affect Java?
(16 comments, last posted May 15, 2009)

More hot threads »