About laszlo

This author has not yet filled in any details.
So far laszlo has created 17 blog entries.

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:00 August 3rd, 2017|0 Comments

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:00 May 10th, 2017|0 Comments

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:00 April 20th, 2017|0 Comments

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:00 April 7th, 2017|0 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:00 March 29th, 2017|0 Comments

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:00 March 20th, 2017|0 Comments

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:00 March 7th, 2017|0 Comments

SAP to Hadoop Hive

Push data from SAP to Hadoop Hive What do you think about an SAP datamart in Hadoop HIVE? In cases where - for whatever reason - SAP HANA (or BW or BW on HANA) is not an option for your analytics - you can still offload your SAP data to big data systems, like Hadoop [...]

2017-06-21T14:42:29+00:00 February 20th, 2017|0 Comments

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:00 January 25th, 2017|0 Comments

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:00 January 17th, 2017|0 Comments