Data sources
SAP
This page explains the individual features when accessing an SAP data source from Peakboard. Under the following link you will find a tutorial on how external data sources are generally configured and linked to Peakboard-Elements:
Getting Started with External Data Sources Using the Example of an XML Data Source
The connection to SAP can be implemented in various ways. Which of these is best for your case depends on several factors that are explained below:
- Direct RFC
-
In the case of Direct RFC, the box communicates directly with an SAP application server. Without middleware and without the need to configure biggerthings on SAP. This is usually the best access option for almost all customers.
- SAP Gateway
-
The SAP Gateway is a module within SAP that can be accessed using transaction code SEGW. There, RFC function modules are usually provided as an OData service. You can find an introduction to SAP Gateway either via Google or here. To connect to a gateway service using Peakboard, you need at leastthe URL of the service and the name of the entity set. Please note that a big disadvantage of this access method is the development effort that might be necessary on the gateway side.
- Peakboard-Bridge
-
In the first generation of Peakboard, the bridge was needed to communicate with SAP. Since the second generation (approx. May 2017) this feature is obsolete and should no longer be used.
Access via “Direct RFC”
To connect the data source to SAP, the fields Client, User Name, Password, and Language (with the usual SAP language code) must be filled in. The tab page ‘Direct RFC’ must also be activated. On this tab page, enter the SAP application server and the system number.
The actual access to SAP is formulated using an XQL statement. So that you do not have to enter the XQL statement completely manually, you can insert a pattern using the template button. The following screenshot shows an instruction for a simple SAP table. Further information and examples of XQL can be found on another page.
The next steps are the Load button to load the columns or metadata and the Preview button to check the plausibility of the data.
Access via SAP Gateway
Access is based on a gateway service that returns a list of all users currently logged in. The following screenshot shows the service in the draft view of transaction SEGW:
The newly created data source requires a unique name and user name and password of the SAP system. In the SAP Gateway tab page, enter the URL of the gateway service. Then click on the small button with the three dots to load all entity sets into the selection dialog available under this service URL.
As soon as you have chosen an entity, confirm with OK. Now the columns and their data types are loaded and displayed. This concludes the configuration. Check the data for plausibility by looking at it in the Preview window.