- Sap hana studio hadoop integration driver#
- Sap hana studio hadoop integration series#
- Sap hana studio hadoop integration download#
The server provides a so-called table extraction feature where we can extract specific tables/views from various SAP systems and store them as “ table extraction” queries. We want to access the “Sales Document: Item Data” table that contains detailed information about item orders (each row contains details of a specific item of an order) and is accessible via the Theobald Xtract Universal Server. Accessing Theobald Xtract Universal Server
![sap hana studio hadoop integration sap hana studio hadoop integration](https://image.slidesharecdn.com/integrationofsaphanaandhadoop2-140707033631-phpapp01/95/integration-of-sap-hana-with-hadoop-6-638.jpg)
The Will They Blend: SAP Theobald meets SAP HANA workflow can be downloaded from the KNIME Hub.
Sap hana studio hadoop integration driver#
A workflow to access SAP data via Theobald and via the JDBC driver of the SAP HANA database, and to blend and preprocess data before calculating and visualizing KPIs in an interactive dashboard.
Sap hana studio hadoop integration download#
Download the workflow Will They Blend: SAP Theobald meets SAP HANA from the KNIME Hub.įigure 2.The KPIs are shown in the interactive view of the KPI Dashboard component (Figure 3). Next, we calculate four different KPIs: total number of orders per month, average number of orders per month, average net weight of an order in each month, and the most popular product in each year. After accessing the data, we join the tables, and extract year and month from the timestamps in order to calculate the KPIs at a meaningful granularity. The data for this experiment is stored in the Sales Document: Item Data and Sales Document: Header Data tables included in SAP ERP. The workflow in Figure 2 shows the steps in accessing the SAP data via Theobald (top branch) and via the JDBC driver of the database (bottom branch). Integrated Tools: SAP, Theobald Experiment Topic: Calculate KPIs of orders/items data and visualize the historical development of the KPIs in an interactive dashboardĪccess mode: Connect to Theobald Xtract Universal Server and to SAP HANA database We connect to both systems from within KNIME, join the data on the sales document key column available in both tables, and show the historical development of a few KPIs in an interactive dashboard: Is the number of orders increasing over time? What is the most popular product per year? Let’s take a look!Ĭhallenge: Access SAP data via Theobald and via the JDBC driver of the SAP HANA database The data about the features of the ordered items are available on the Theobald Xtract Universal Server, so we read this data with the SAP Reader (Theobald) node. We access the data about the submitted orders the legacy way.
![sap hana studio hadoop integration sap hana studio hadoop integration](https://media.springernature.com/original/springer-static/image/chp%3A10.1007%2F978-3-030-78821-6_4/MediaObjects/507412_1_En_4_Fig4_HTML.png)
In our example, we extract KPIs from orders data, and show their development over time. Using the SAP integration available from KNIME Analytics Platform version 4.2 forward, you can access and load SAP data into KNIME just by one node called SAP Reader (Theobald). The legacy way requires a few steps: registering the JDBC driver of the SAP HANA database in KNIME, connecting to the database with the DB Connector node, selecting a table on the connected database, and reading it into KNIME.
![sap hana studio hadoop integration sap hana studio hadoop integration](https://i.stack.imgur.com/uAxZi.jpg)
![sap hana studio hadoop integration sap hana studio hadoop integration](https://learntips.b-cdn.net/wp-content/uploads/2021/01/1-42-4658437.png)
Whether it’s mixing traditional sources with modern data lakes, open-source devops on the cloud with protected internal legacy tools, SQL with noSQL, web-wisdom-of-the-crowd with in-house handwritten notes, or IoT sensor data with idle chatting, we’re curious to find out: will they blend? Want to find out what happens when IBM Watson meets Google News, Hadoop Hive meets Excel, R meets Python, or MS Word meets MongoDB?įollow us here and send us your ideas for the next data blending challenge you’d like to see at Today’s challenge: blend data on a SAP system that is accessed in two ways
Sap hana studio hadoop integration series#
In the Will They Blend blog series we experiment with the most interesting blends of data and tools.