SAP Integration Overview

You can integrate Jedox financial planning and forecasting with SAP Business Technology Platform to achieve more efficient processes.

Jedox SAP Connector works through two components: a Jedox ETL Add-On that can be selected as part of Jedox Setup, and a SAP Add-On that has to be transported to the SAP System.

Jedox uses its own extract types within the Jedox SAP Connector to get SAP data easily loaded into Jedox. The possibility of transforming the data is given in a very easy way, with no programming needed.

In the SAP system, queries are raised in one single work process. This should not slow down SAP performance.

Enabling Jedox SAP Connector

To enable Jedox SAP Connector, you will have to perform the following installation steps:

  1. Install SAP Java Connector*
  2. Install Jedox Integrator Add-On SAP*
  3. Install SAP Transport Packages

*on-premises installations only

Overview of Jedox SAP Connector extract types

To extract data from SAP Data Dictionary Tables and Remote Function Calls (RFCs), there are two generic extract types. They can be used for any SAP Netweaver-based system (SAP R/3, S/4HANA, ERP, CRM, SCM…):

  1. SAPTable Extract
  2. SAPGenericRFC Extract

To extract data from SAP ERP Systems, SAP R/3, or S/4HANA, there are 3 specific extract types. To use these extracts, it is necessary to install the transport package for SAP ERP.

  1. SAPERPHierarchy Extract
  2. SAPBalanceSheet Extract
  3. SAPProject Extract

To extract data from SAP Business Warehouse systems (SAP BW/BI) there are 4 specific extract types.To use these extracts, it is necessary to install the transport package for SAP BW.

  1. SAPBIMaster Extract
  2. SAPBIHierarchy Extract
  3. SAPBIDataStore Extract
  4. SAPBICube Extract

Related articles

Updated July 6, 2023