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

• Age of software is showing as it struggles with very large data modules, which were not as prevalent in its early years
• Querying performance at times can be very slow
• Support and development for BEx has been discontinued or hard to find.

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

• Positive - This tool report output is in Excel so it's a good tool if your users are familiar with Excel.
• Positive: this tool has rich BI content so developing extractors for standard processes from SAP ECC can be done in minutes.
• Negative: It lacks lot of features which are available in other newer tools today. For ex. - rich charts, rich filtering, exporting capabilities, user interface.
• Negative: Its not a plug and play tool like Qlikview, Lumira, or Tableau. Even a single report development in this tool takes a lot of time compared to others.

Incentivized

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

Incentivized