Pentaho SAP Connector
SAP Connector
We are the largest Pentaho implementation and training partner in EMEA.
Your data integration interfacefor SAP
The Pentaho SAP Connector is the ideal extension for Pentaho Data Integration (PDI) to integrate your SAP data world into your data integration and analysis strategy.
Details on SAP Note 3255746 and the effects on the Pentaho SAP Connector can be found in our customer information: Download now
Advantages of using the Pentaho SAP Connector
Seamless, easy integration with SAP ERP/BW
The connector’s well-laid out design and simple, straightforward installation give you swift interaction with SAP in the shortest possible time.
Querying of complex and nested SAP structures
Its extensive functionalities as well as the use of existing business logic means the connector supports users in handling complex queries and interactions.
High performance and scalability
Thanks to optimised query logic and easy expandability, strong performance can be achieved even in large system environments.
Bi-directional communication
In addition to loading data from SAP, functions that are fully compliant with SAP security are also available for writing back data to the SAP system.
Enterprise readiness with integrated security
Thanks to its integrated SAP security, the connector can be quickly and easily integrated into your central user management setup.
Supporting load scenarios (Delta)
In addition to support for a traditional full load of SAP data, extensive functionalities are also available for enabling incremental data loading scenarios.
Seamless, easy integration with SAP ERP/BW
The connector’s well-laid out design and simple, straightforward installation give you swift interaction with SAP in the shortest possible time.
Querying of complex and nested SAP structures
Its extensive functionalities as well as the use of existing business logic means the connector supports users in handling complex queries and interactions.
High performance and scalability
Thanks to optimised query logic and easy expandability, strong performance can be achieved even in large system environments.
Bi-directional communication
In addition to loading data from SAP, functions that are fully compliant with SAP security are also available for writing back data to the SAP system.
Enterprise readiness with integrated security
Thanks to its integrated SAP security, the connector can be quickly and easily integrated into your central user management setup.
Supporting load scenarios (Delta)
In addition to support for a traditional full load of SAP data, extensive functionalities are also available for enabling incremental data loading scenarios.
Source: Hitachi Vantara
A powerful combination:
PDI and the Pentaho SAP Connector
Simple drag & drop data integration (ETL)
The intuitive PDI user interface is also available in the connector. No programming skills are required. No coding skills are required.
Automating the data pipeline
Thanks to the connector’s easy use, you can quickly automate the data processes you use with SAP (as well as all your other data sources) giving you significant savings on development costs. You save development costs.
Full support of all Pentaho functionalities
Common Pentaho functions such as metadata injection, using variables and parameters as well as all other functions are also possible with the connector.
Data blending with corporate data
Thanks to PDI, companies can easily combine data from SAP ERP, SAP BW and HANA with data from non-SAP systems to create powerful analytics applications. The graphical functionality also supports all data sources and file types. The graphical functionality supports all data sources and file types.
Future Readiness
We are continuously working on the further development of the connector (in line with Pentaho release cycles), so can ensure all functionalities will continue to work in the future.
Extracting SAP data in any target environment
The enormous number of standardised data connectors within the suite allows the integration of SAP data into any (Cloud) environment or database.
Simple drag & drop data integration (ETL)
The intuitive PDI user interface is also available in the connector. No programming skills are required. No coding skills are required.
Automating the data pipeline
Thanks to the connector’s easy use, you can quickly automate the data processes you use with SAP (as well as all your other data sources) giving you significant savings on development costs. You save development costs.
Full support of all Pentaho functionalities
Common Pentaho functions such as metadata injection, using variables and parameters as well as all other functions are also possible with the connector.
Data blending with corporate data
Thanks to PDI, companies can easily combine data from SAP ERP, SAP BW and HANA with data from non-SAP systems to create powerful analytics applications. The graphical functionality also supports all data sources and file types. The graphical functionality supports all data sources and file types.
Future Readiness
We are continuously working on the further development of the connector (in line with Pentaho release cycles), so can ensure all functionalities will continue to work in the future.
Extracting SAP data in any target environment
The enormous number of standardised data connectors within the suite allows the integration of SAP data into any (Cloud) environment or database.