DVW Alteryx Connector for SAP

The fastest, easiest way to read and write SAP data in Alteryx. 

Experience the full benefit of the Alteryx platform with DVW Analytics.

The DVW Alteryx Connector for SAP (ACS) is the fastest, easiest way to:

• Read data from SAP into Alteryx
• Write data from Alteryx into SAP

​The DVW Alteryx Connector for SAP supports the widest range of SAP products and write-back capabilities in the DVW Connector family.

​Free Trial | Demos | Pricing

---

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

The DVW Alteryx 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
• SAP Business ByDesign

Non-Core SAP Solutions

• SAP Integrated Business Planning (IBP)
• SAP SuccessFactors
• SAP Customer Experience (CX)
• SAP Ariba
• SAP BusinessObjects

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

---

DVW Alteryx Connector for SAP Works with All Alteryx Tools

The DVW Alteryx Connector for SAP works with all Alteryx tools.
​
The DVW Alteryx Connector for SAP is installed as a plug-in to Alteryx and has zero impact on your SAP installation so you can be up and running immediately.

---

Analytics, Machine Learning and AI with SAP Data

The DVW Alteryx Connector for SAP supports the full range of Alteryx use cases, including analytics, machine learning and AI workflows.

Alteryx Designer and Alteryx Server users get direct, structured access to SAP data for use alongside Alteryx's native ML and AI capabilities. No manual exports, no staging databases, no ABAP development required

Typical use cases include:

• Predictive modelling on SAP financial, supply chain and operational data
• Demand forecasting using SAP sales history and inventory data
• Predictive maintenance models built on SAP Plant Maintenance data
• Customer segmentation and churn modelling using SAP CRM and billing data
• Automated anomaly detection on SAP transactional data
• AI-assisted data validation and transformation during SAP migration projects
• Writing model outputs back to SAP: post forecasts to SAP IBP, update scores in SAP CRM, write results to SAP BW

​SAP data is extracted directly into Alteryx workflows on a scheduled or on-demand basis. Model outputs can be written back to SAP using the DVW Alteryx Connector for SAP write capabilities. The full read and write capability detail is below.

---

SAP Read Capabilities

Extract data from SAP

The DVW Alteryx 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 BAPI (Add-On)
• 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 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)
• Extract data from standard and custom SAP Reports (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 from the SAP Query
• Apply Filters to the SAP Query data to be extracted

SAP Spool

• Works with standard and custom SAP Transactions and Reports that provide the ability to "Execute and Print" and "Execute in Background"
• 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 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 Attachment

• Extract attachments from SAP Transaction Data and SAP Master Data
• Supports any SAP supported MIME type format including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS PowerPoint etc.

SAP Long Text

• Extract SAPscript texts from SAP Transaction Data and SAP Master Data
• Supports any SAPscript Text Object and Text ID

SAP BW

• Extract data from SAP BW Queries & SAP BW Query Views
• Extract data from SAP BW InfoProviders (InfoCubes, MultiProviders, Composite Providers, InfoSets, DSO, ADSO, InfoObjects acting as InfoProviders)
• Extract SAP BW Hierarchy data in an optimised flat tabular format
• 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
• Search for SAP HANA Views
• Select fields to be extracted
• Apply Filters to the SAP HANA View data to be extracted

SAP Analytics Cloud

• Extract data from SAP Analytics Cloud objects

---

SAP Write Capabilities

Load, create & update data in SAP

The DVW Alteryx Connector for SAP uses SAP BAPI, SAP IDoc, SAP OData and SAP InfoProvider write capability to support the load, creation and update of:

• SAP Master Data e.g. Customer, Material etc.
• SAP Transaction Data e.g. Sales Order, G/L Journal Entry etc.
• SAP BW InfoProvider Data
• SAP Analytics Cloud Data

SAP BAPI Write (Add-On)

• Load data from Alteryx workflows directly into SAP using SAP BAPIs or SAP RFC-enabled Function Modules
• Supports use cases including creation of Sales Orders, Purchase Requisitions, posting Goods Movements, posting G/L Documents

SAP IDoc Write (Add-On)

• Load data from Alteryx workflows directly into SAP using IDoc (Intermediate Document) technology
• Supports data migration for SAP S/4HANA, loading and update of Master Data and Transaction Data

SAP OData Write (Add-On)

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

SAP Analytics Cloud Write (Add-On)

• Write data to SAP Analytics Cloud objects from Alteryx workflows

SAP BW Write (Add-On)

• Load data from Alteryx workflows directly into SAP BW InfoProviders (InfoCube, ODS Objects, ADSO)
• Update SAP BW InfoObjects and Text
• Write data to SAP BW Hierarchies

SAP ECC Hierarchy Updates (Add-On)

• Update SAP ECC Cost Centre, Profit Centre, Cost Element, Activity Type, Business Process and Internal Order Group Hierarchies

---

Add-Ons for Non-Core SAP Products

The following non-core SAP products are available as Add-Ons to the DVW Alteryx Connector for SAP. Add-Ons require an active DVW ACS Base Licence.

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

• Read data from and write data to SAP IBP Planning Areas

SAP SuccessFactors (Add-On)

• Read data from and write data to SAP SuccessFactors using SAP OData
• Works with SAP SuccessFactors modules including Employee Central, Compensation, Onboarding, Performance & Goals, Recruiting, Succession & Development

SAP Customer Experience (CX) (Add-On)

• Read data from and write data to SAP Cloud for Customer, SAP Sales Cloud, SAP Service Cloud and SAP Marketing Cloud

SAP Ariba (Add-On)

• Read data from SAP Ariba Analytics Procurement and Sourcing Reports

​SAP BusinessObjects (Add-On)

• Read data from BusinessObjects Universes and Webi Reports

---

Key Features of the DVW Alteryx Connector for SAP

• Installed as an Alteryx plug-in
• Most DVW Alteryx Connector for SAP Tools need no installation on SAP
• No extra hardware required
• Works with all Alteryx tools
• Schedule workflows with Alteryx Server
• No staging of data required
• Use multiple SAP systems in a single workflow
• Respects user's SAP authorisations
• Designed to optimise extract of large data volumes
• Delta loads supported
• Uses standard SAP APIs
• Supports SSO to SAP on Alteryx Designer & Alteryx Server

---

Getting Started

Register for a 30-day trial of the DVW Alteryx Connector for SAP.

Free Trial | Demos | Pricing