SAP Business Warehouse vs. SAP Data Services

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

It's definitely one of the leading ETL tools, and it's the best ETL tool to use with SAP integration. If you use SAP HANA, then you should think about Data Services as your primary ETL tool.

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

• Integration with SAP ERP/ECC works really well.
• A lot of flexibility in data creation, with different types of communication capabilities like BAPIs, IDocs, and Batch input.
• Reliable and consistent results and easily enforceable data templates.

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

• Debugging is not very easy. When one wants to see the flow of data from one Query to another, the process is not very smooth and efficient.
• A lot of functions do not behave the way they should. I have faced problems with the count() function.
• I have faced problems while loading Excel files. The same set of options will work in one case but not in the other.

Incentivized

As other SAP products, there is excellent support by SAP on this tool. You can access the SAP Help portal in order to give support either from the huge community or directly from SAP.

Incentivized

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

You cannot afford to run your business on questionable data. With SAP® Data Services software, you can access, transform, and connect data to fuel your critical business processes. Together, these enterprise-class solutions enable data integration and data quality, providing the right level of insight across your business so you can make better decisions and operate more effectively.SAP Data Services was previously known as SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data Integrator.

Incentivized

• 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

• Very positive impact in jobs maintenance since support auto-documentation.
• Great impact on learning curve.
• Great results in our Data Quality Projects.

Incentivized