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

New Product: BI Bridge for SAP

Our new product, BI Bridge for SAP Solutions, displays live SAP ERP transactions in BI reports and dashboards. Embedding or linking relevant SAP screens enables analysts to access and work with SAP data in one interface and reduces the margin for error and increasing productivity. Benefits Dive deeper into your [...]

2017-11-08T12:03:21+00:00November 6th, 2017|Comments Off on New Product: BI Bridge for SAP

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

SAP compliant ETL jobs

Evolve ERP data extract ETL’s to become SAP compliant In previous posts we highlighted the risks of SAP Indirect Access and the increasing stringent nature of SAP licence audits in this area. As it turned out from the UK ruling in the SAP vs Diageo case - all SAP clients are at risk of unlicenced [...]

2017-06-21T14:42:28+00:00April 20th, 2017|Comments Off on SAP compliant ETL jobs

Efficient delta extractions from SAP

Often there are datasets in SAP that grow so large it’s impossible to extract them periodically in a reasonable timeframe. Also, it makes no sense to extract records that are already in the target system and have not been changed since the last extraction. In such circumstances, the logic is to apply delta handling: transferring [...]

2017-06-21T14:42:29+00:00April 7th, 2017|2 Comments

SAP Indirect Access – VirtDB’s solution

For just over a month the SAP community has fiercely been debating the UK court ruling on SAP indirect access licensing. Diageo, the world’s largest distiller, lost a case against SAP that resulted in a hefty claim for license fees and backdated maintenance charges which included accumulated interest being awarded to the software giant. SAP [...]

2017-06-21T14:42:29+00:00March 29th, 2017|Comments Off on SAP Indirect Access – VirtDB’s solution