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

SAP Data Services is a data integration and transformation software application. It allows users to develop and execute workflows that take data from predefined sources called data stores (applications, Web services, flat-files, databases, etc.)

Incentivized

• ETL, great at taking data from OLTP source, flat file, etc... Easy drag and drop for transformations.
• Great reporting possibilities, easy to connect with BO, BPC, etc...
• Great Master Data Management (MDM )for BPC - helps us maintain master data for BPC.

Incentivized

• Extracting data from various types of data sources
• Transforming data using joins, functions, look ups, etc.
• Loading data into different kinds of targets

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

• New connectivity options for cloud solutions must be added.
• Avoid dependency from flash in Information Steward scorecard.
• More connectivity options for hadoop distributions.

Incentivized

It needs minimal trainings and can perform tasks of data management and reporting.

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

SAP Data Services is better at integration with other SAP products and data sources with native HANA connectors. There are also accelerators to consider when looking at it as a data migration tool for SAP implementations.

Incentivized

• It has helped cut down on parts shortages with the minimum stock flags.
• People are able to track down parts easier because they can see where they were last used.
• Our sales team has better visibility on lead times so they can accurately quote our customers.

Incentivized

• DS has had a very positive impact by reducing deployment times for SAP and has provided ability to deploy multiple sites at the same time.
• Ongoing master data creation/migration benefits significantly from DS, and it's easy to stand up a new business unit.
• Data accuracy improved and manual inspections are minimal.

Incentivized