Connecting Power BI with SAP – Part II

Part II: Visualizing Customer Sales Data in Power Map Power Map is a great tool for visualizing business data on a map, using the familiar Excel application. With a few steps, the Excel user can create interactive scenes, showing multiple layers of data and dynamically changing data over time on a 3D map. Power Map works with data that has been loaded into a spreadsheet or into a Power Pivot data model. Creating a Power Map on top of your data is pretty straight forward – all you need is location data and…continue reading →

Connecting Power BI with SAP – Part I

Part I: Analyzing Employee Data in Power View Power View is a great tool for visualizing and analyzing data, using the familiar Excel application. With a few steps, the Excel user can create interactive presentations of data, for example in form of charts or maps. Power View works with data that has been loaded into a spreadsheet or into a Power Pivot data model. Creating a Power View on top of your data is relatively straight forward - with the right data in the right format. If you have worked with SAP data…continue reading →

How to build perfect SAP Integration using Xtract Universal and Kettle

In this blog I will show how to use Kettle to run SAP extractions created with Xtract Universal to load it into an Oracle Database. Xtract Universal is an SAP connector by Theobald Software, a leading vendor of SAP Integration products. Xtract Universal supports integration of your SAP data in the most different target systems, like SQL Server, Oracle, IBM DB2, Teradata, flat files and others – fast, straight-forward and user-friendly. Kettle (aka Pentaho Data Integration (PDI)) is an open source data integration (ETL) engine that allows the user to define data integration…continue reading →

Activating Datasources in the SAP OLTP System

To be able to extract OLTP Datasources from SAP ERP, you first of all have to activate the relevant DataSources in the SAP OLTP system. After activating the DataSources you can extract data from all the active DataSources using the DeltaQ component. Thoses steps have to be carried out in the SAP ERP system (OLTP). No SAP BW system is required. 814continue reading →