Likelihood to Recommend First, get the database on Oracle. If you are in an Oracle stack, it would be much better to use the Oracle products. If you are driving a Ferrari, you wouldn’t put a Mercedes engine in it. If you are writing a query, you cannot rely on other brands. Since I'm an architect, when I look for a product, I look for performance. The installation is easy because it comes out-of-the-box and you just start using it. Previous to Oracle Exadata, we were using a normal Oracle RAC service. We were just waiting for this product to come out. I'm currently writing a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m. This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%. Read full review 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
Read full review Pros Customize-able for specific functionality optimized for combination of online transaction or analytical processing. Ability to serve mix workloads with resource management feature enables prioritizing allocation for certain workload. Scale-able on-premise with compatibility for cloud deployment offers flexible solution for organization considering to transition from on-premise solution. Read full review 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. Read full review Cons Patching can often become quite involved and convoluted. It should be more transparent and straightforward. Storage metrics can be difficult and time consuming to obtain. Basic administrative functions can be hard to repair when discovered. Vendor support can take a while to obtain. Generally several attempts are necessary to reach the right area of vendor expertise. Read full review 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. Read full review Alternatives Considered Oracle Exadata Database Machine had the best performance overall hands down. It clearly beat the competition and we were seeing 1000X improvement on
SAP HANA . Oracle Exadata Database Machine beat that without us refactoring our code. To achieve that in HANA, we had to refactor the code somewhat. Now this was for our limited POC of 5 use cases. Given the large number of stored procedures we had in Sybase, we need to capture more production metrics but we are seeing incredible performance.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review 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.
Read full review Return on Investment Single support from a single vendor with both machine and database from Oracle, which is costing us less. With Exadata, we need less technical manpower and less technical support. A business transaction with the integrated and centralized database helps us focus on other business needs. We don't need to buy additional licenses and Hardware for the next 3 to 5 years. Habeeb Akbar Sr. Product Manager/Consultant for Software Technologies and Infrastructure
Read full review 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. Read full review ScreenShots