OpenText Magellan vs. SAP Business Warehouse

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.

SAP BW is best for: 1. Large enterprises 2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge) 3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive) SAP BW is less appropriate for: 1. Small enterprises 2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions 3. HANA

Incentivized

• The report outputs can vary across different types such as HTML, PDF, and Excel
• Their open source offering is very sufficient
• There are great boards and blogs for developers and engineers to expand and use their features.
• The people from the company that I've worked with are professional and courteous.

Incentivized

• It tracks bin locations for parts which can be really helpful.
• SAP Business Warehouse tells you who has a part checked out so you can find it.
• It shows current parts shortages so buyers are flagged to get parts on order based on current demand.

Incentivized

• The documentation on all the available features, but most importantly on the scripting side, can be improved
• The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
• The server portal needs to provide better tools
• More integration is needed with other OpenText products

Incentivized

• Support comes slow. This is not a limitation of the software itself but could be a symptom from the local office. Once we get support everything works along smoothly.
• It is always important to review the instructions. This is not a system that does well initially with personalization without review of standard procedures. A log of time can be lost if the technicians and programmers working with the data are not following correct procedures.

Incentivized

I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite

Incentivized

It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.

Incentivized

Always there on the front and backend for us and the client.

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.

SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system.

Incentivized

• Actuate can handle 50 to 60 sub reports inside a report very well.
• Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.

• Exporting of data and reports to Excel is very easy for the end user to interpret and manipulate.
• Negatively, the speed at which BW retrieves data and reports is very slow and out of date.
• Addition of daughter application HANA has helped this aging application stay afloat for a few more years. Overall it has been a great tool but it's showing its age very fast.

Incentivized