DVW Dataiku Connector for SAP

Integrate SAP data into Dataiku for advanced analytics, data science and machine learning.

The DVW Dataiku Connector for SAP (DCS) is the fastest, easiest way to:

• Read data from SAP into Dataiku
• Write data from Dataiku into SAP

Free Trial | Demos | Pricing

---

DVW Dataiku Connector for SAP Works with the Most Popular SAP Solutions

The DVW Dataiku Connector for SAP supports integration with a wide range of core and non-SAP solutions including:

Core SAP Solutions

• SAP ECC
• SAP ERP
• SAP S/4HANA
• SAP S/4HANA Cloud Private Edition
• SAP S/4HANA Cloud Public Edition
• SAP BW including SAP BW on HANA
• SAP BW4/HANA
• SAP Analytics Cloud
• SAP Business Suite applications i.e. SAP CRM, SAP ERP, SAP PLM, SAP SCM & SAP SRM
• SAP Industry Solutions (25+) including SAP Oil & Gas (IS-Oil), SAP Utilities (IS-UTIL), SAP Telecommunications (IS-Telco) & SAP Retail (IS-Retail)
• SAP BPC

Non-Core SAP Solutions

• SAP Integrated Business Planning (IBP)
• SAP SuccessFactors

​Don't see your SAP system here? Then please contact our team to check if your SAP system is covered.

---

DVW Dataiku Connector for SAP Works within Dataiku Projects

The DVW Dataiku Connector for SAP integrates directly within Dataiku projects, enabling data engineering, analytics and ML teams to incorporate SAP data into their pipelines.

​The DVW Dataiku Connector for SAP has zero impact on your SAP installation so you can be up and running immediately.

---

Analytics, Data Science and Machine Learning with SAP Data

The DVW Dataiku Connector for SAP supports analytics, data science and machine learning use cases, giving Dataiku users direct, structured access to SAP data inside Dataiku's native workflow environment.

Dataiku's AI and ML capabilities work directly on SAP data extracted by the connector. No manual exports, no staging databases, no ABAP development required.

​Typical use cases include:

• Training machine learning models on SAP financial, supply chain and operational data
• Demand forecasting using SAP sales history and inventory data
• Customer segmentation and churn modelling using SAP CRM and billing data
• AI-assisted data quality and validation workflows during SAP migration projects
• Automated anomaly detection on SAP transactional data
• End-to-end data science projects with SAP data inside Dataiku's visual and code-based workflow environment
• Writing model outputs back to SAP via BAPI, IDoc and OData add-ons

​SAP data is extracted directly into Dataiku workflows on a scheduled or on-demand basis. Write capabilities are available via add-ons. The full read and write capability detail is below.

---

SAP Read Capabilities

Extract data from SAP

The DVW Dataiku Connector for SAP supports the extract of data from a wide range of SAP sources including:

• SAP Tables
• SAP Transactions (T-Codes) and Reports
• SAP Queries
• SAP Spool
• SAP OData
• SAP Attachments e.g. PDF, image files
• SAP Long Text
• SAP BW Queries and Query Views
• SAP BW InfoProviders
• SAP HANA Views
• SAP Analytics Cloud
• SAP BAPI (Add-On)

SAP Table & View

• Extract data from SAP Tables (Transparent / Pooled / Clustered) and SAP Views
• Search for SAP Tables and related SAP Tables
• Select fields to be extracted from a complete list of Table fields incl. custom fields
• Apply Filters to the SAP Table data to be extracted

SAP Transaction (T-Code) & Report

• Extract data from standard and custom SAP Transactions (T-Codes) and ABAP Reports
• Utilise existing Transaction and Report Variants
• Select fields to be extracted
• Apply Filters to the SAP data to be extracted

SAP Query

• Works with SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03)
• Search for SAP Queries
• Select fields to be extracted
• Apply Filters to the SAP Query data to be extracted

SAP Spool

• Works with SAP Transactions and Reports via the SAP Spool
• Access SAP Spool Jobs linked to user's SAP User Name

SAP OData

• Search for SAP OData services
• Select fields to be extracted from the OData service
• Apply Filters to the SAP OData data to be extracted

SAP Attachment

• Extract attachments from SAP Transaction Data and SAP Master Data
• Supports any SAP supported MIME type format

SAP Long Text

• Extract SAPscript texts from SAP Transaction Data and SAP Master Data

SAP BW

• Extract data from SAP BW Queries & SAP BW Query Views
• Extract data from SAP BW InfoProviders
• Extract SAP BW Hierarchy data
• Extract SAP BW Text for any SAP BW InfoObject

SAP HANA View

• Extract data from SAP HANA CDS Views, Calculation Views, Attribute Views and Analytical Views

SAP Analytics Cloud

• Extract data from SAP Analytics Cloud objects

SAP BAPI

• Search for standard and custom SAP BAPIs
• Select SAP BAPI tables and fields to be included in extract
• Apply Filters to the SAP BAPI extract
• Automatically format the SAP BAPI extract output

---

SAP Write Capabilities

Load, create & update data in SAP

The DVW Dataiku Connector for SAP uses SAP BAPI, SAP IDoc, SAP OData and SAP Analytics Cloud write capability to support the load, creation and update of data in SAP.

SAP BAPI Write (Add-On)

• Load data from KNIME workflows directly into SAP using SAP BAPIs or SAP RFC-enabled Function Modules

SAP IDoc Write (Add-On)

• Load data from KNIME workflows directly into SAP using IDoc technology

SAP OData Write (Add-On)

• Load data from KNIME workflows directly into SAP S/4HANA Cloud via OData services

​SAP Analytics Cloud Write (Add-On)

• Write data to SAP Analytics Cloud objects from KNIME workflows

---

Add-Ons for Non-Core SAP Products

The following non-core SAP products are available as Add-Ons to the DVW Dataiku Connector for SAP. 

SAP Integrated Business Planning (IBP) (Add-On)

• Read data from SAP IBP Planning Areas

​SAP SuccessFactors (Add-On)

• Read data from and write data to SAP SuccessFactors using SAP OData

---

Key Features of the DVW Dataiku Connector for SAP

• Integrates within Dataiku projects
• Most DVW Dataiku Connector for SAP nodes need no installation on SAP
• Works within Dataiku's data pipeline framework
• Schedule workflows with Dataiku Server
• No staging of data required
• Use multiple SAP systems in a single project
• Respects user's SAP authorisations
• Designed to optimise extract of large data volumes
• Delta loads supported
• Uses standard SAP APIs
• Supports SSO

---

Getting Started

Register for a free 30-day trial of the DVW Dataiku Connector for SAP.​​​

​Free Trial | Demos | Pricing