Generate data extraction reports for SAP

Do you use ABAP reports to unload data from SAP to your big data or BI platforms? We have good news for you: you can keep this approach but cut report development time using a combination of two SAP add-ons. […]

2018-05-14T08:20:42+00:00May 10th, 2018|Comments Off on Generate data extraction reports for SAP

SAP BW Data Extraction with hierarchy flattening

After countless requests from customers and prospects, we finally added SAP BW data extraction as a new feature to our product Data Unfolder. The reason behind so many companies face difficulties extracting hierarchies from SAP is that SAP stores hierarchies in table with a tree structure. It contains Node IDs and Parent Node IDs: [...]

2017-11-21T10:16:38+00:00November 9th, 2017|Comments Off on SAP BW Data Extraction with hierarchy flattening

In-memory Analytics on SAP ERP data using EXASOL

If you need robust analytic performance on SAP data, but for whatever reason don’t want to use HANA, VirtDB and EXASOL got you covered. In this article we will explain how you can load SAP ERP data to EXASOL using Data Unfolder to speed up your ERP analytics. […]

2017-08-25T13:36:44+00:00August 24th, 2017|Comments Off on In-memory Analytics on SAP ERP data using EXASOL

Query SAP data with Spark SQL

In this article, we will show you the easiest way to load data to Hadoop and query it through Spark SQL. Spark SQL The Spark team launched Spark SQL as a Spark component for structured data processing in 2014. Users can run SQL queries, read data from Hive, or use it as means to [...]

2017-08-03T13:36:15+00:00August 3rd, 2017|Comments Off on Query SAP data with Spark SQL

Sales dashboards in Spotfire on SAP ERP data

Push SAP® ERP data to Spotfire® desktop with a few clicks and visualize data easily. TIBCO Spotfire® helps you quickly uncover insights for better decision-making, while SAP ERP has significant percent of the data needed to get those insights. VirtDB Data Unfolder helps you to close the gap between SAP data and [...]

2017-06-21T14:42:28+00:00May 10th, 2017|Comments Off on Sales dashboards in Spotfire on SAP ERP data

Bulk transfer of large SAP ERP data sets

VirtDB’s Mass Data Extractor for SAP One of the difficulties/constraints to extracting large amounts of data from SAP ERP is memory management limitations on the SAP Application server. In instances where you want to process queries resulting from large data sets, SAP (by default) will try to read all data in-memory. When this happens, it [...]

2017-06-21T14:42:29+00:00March 20th, 2017|Comments Off on Bulk transfer of large SAP ERP data sets

VirtDB on S/4HANA

SAP S/4HANA to BI tools One of the most recurring questions we have had from clients and prospects during our demos is: Does VirtDB work with SAP’s S/4HANA? As of now, the proud answer is: ABSOLUTELY YES! If you run the traditional SAP GUI on SAP S/4HANA with VirtDB Add-on installed, you will have the [...]

2017-06-21T14:42:29+00:00March 7th, 2017|Comments Off on VirtDB on S/4HANA

Pacoma boosts self-service data access with VirtDB

Highlights SAP Modules covered Deployment time Extracts per week Less manual effort Customer Pacoma is one of the world's leading suppliers of hydraulic cylinders. Over the course of more than 40 years, they have developed, designed and produced hydraulic cylinders of nearly every possible type. Their [...]

2017-06-21T14:42:30+00:00January 25th, 2017|Comments Off on Pacoma boosts self-service data access with VirtDB

Create SAP data mart  in Tableau (2.)

The goal is similar as it was last time to create a mini data mart from operative SAP ERP data to Tableau in a few minutes only - without ABAP coding or IT staff bothered. This time we load Warehouse Stock Levels and some Material Master data to Tableau - but will do the joins and [...]

2017-06-21T14:42:30+00:00January 17th, 2017|Comments Off on Create SAP data mart  in Tableau (2.)