ALTERYX CONNECTORS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR SAP CX
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP RPA
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

KNIME CONNECTORS

KNIME CONNECTOR FOR SAP
KNIME CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS

TABLEAU CONNECTOR FOR SAP

POWER BI CONNECTORS

POWER BI CONNECTOR FOR SAP
FREE TRIAL
DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX RPA CONNECTOR
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • DATAIKU CONNECTORS
    • DOMO CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • UPCOMING WEBINARS
      • ON-DEMAND WEBINARS
    • EVENTS >
      • UPCOMING EVENTS
      • PAST EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

ALTERYX CONNECTOR FOR SAP

FREE TRIAL

DVW ALTERYX CONNECTOR FOR SAP

Experience the full benefit of the Alteryx Analytic Process Automation 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​
GET A FREE TRIAL TODAY
  • OVERVIEW
  • DVW ACS SAP READ TOOLS
  • DVW ACS SAP WRITE TOOLS
  • KEY FEATURES
<
>

DVW ACS WORKS WITH YOUR CORE SAP SOLUTIONS

The DVW Alteryx Connector for SAP offers Read and Write capability for all of your core SAP systems including:
  • SAP ECC
  • SAP S/4HANA including SAP S/4HANA Cloud
  • SAP BW including SAP BW on HANA and SAP BW4/HANA
  • 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
Don't see your SAP system here? Take a look at our other Alteryx connectors for SAP products or contact our team to check if your SAP system is covered.
Picture
Picture

DVW ACS WORKS WITH ALL ALTERYX TOOLS

​The ​DVW Alteryx Connector for SAP works with all Alteryx tools.

​The DVW Alteryx Connector for SAP is "baked" into Alteryx and has zero impact on your SAP installation so you can be up and running immediately.

DVW ACS OFFERS EXTENSIVE SAP READ & WRITE CAPABILITIES

Picture

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
  • SAP Attachments e.g. PDF, image files
  • ​SAP BW Queries and Query Views
  • SAP BW InfoProviders​
  • SAP HANA Views

SAP TABLE & VIEW

Extract data from:
  • SAP Tables (Transparent / Pooled / Clustered)
  • SAP Views​

Features:
  • 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​
Picture

SAP TRANSACTION (T-CODE) & REPORT

Extract data from:
  • Standard and custom SAP Transactions (T-Codes)
  • Standard and custom SAP Reports (ABAP Reports)​

Features:
  • Search for SAP Transactions and SAP Reports
  • Utilize existing Transaction and Report Variants
  • Select fields to be extracted
  • Apply Filters to the SAP data to be extracted ​
Picture

SAP QUERY

Extract data from:
  • SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03)

​Features:
  • Search for SAP Queries
  • Select fields to be extracted from the SAP Query
  • Apply Filters to the SAP Query data to be extracted
Picture

SAP SPOOL

Extract data from:
  • Standard and custom SAP Transactions (T-Codes) via the SAP Spool
  • Standard and custom SAP Reports (ABAP Reports)​ via the SAP Spool

Features:
  • Works with SAP Transactions and ABAP Reports that provide the ability to "Execute and Print" and "Execute in Background"
  • for Access SAP Spool Jobs linked to user's SAP User Name


Picture

SAP ODATA

Extract data from:
  • SAP OData services

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

SAP BAPI

Extract data from: 
  • Standard SAP BAPIs
  • Custom SAP BAPIs

Features:
  • Search for 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
Picture

SAP ATTACHMENT

Extract attachments from:
  • SAP Transaction Data
  • SAP Master Data

Features:
  • Extract attachment data in any of the SAP supported MIME type formats including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS PowerPoint etc.
Picture

SAP BW

Extract data from:
  • SAP BW Queries & SAP BW Query Views
  • SAP BW InfoProviders​
  • SAP BW Hierarchies
  • SAP BW Texts

Features:
  • Search for SAP BW Queries & Query Views
  • Select Characteristics and Key Figures 
  • Apply Filters to the SAP BW data to be extracted ​
Picture

​SAP HANA VIEW

Extract data from:
  • SAP HANA CDS Views
  • SAP HANA Calculation Views
  • SAP HANA Attribute Views
  • SAP HANA Analytical Views

Features:
  • Search for SAP HANA Views
  • Select fields to be extracted from a complete list of SAP HANA View fields incl. custom fields
  • Apply Filters to the SAP HANA View data to be extracted
Picture

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 BAPI

Load, create and update data in SAP using:
  • Standard SAP BAPIs
  • Custom SAP BAPIs

Features:
  • Search for SAP BAPIs
  • Automatically map import fields with SAP BAPI fields
  • Trigger the execution of the SAP BAPI from an Alteryx workflow
  • Receive SAP success (confirmation), warning and error messages directly within Alteryx
Picture

SAP IDOC

Load, create and update data in SAP using:
  • Standard IDoc
  • Custom IDoc

Features:
  • Search for SAP IDoc Types
  • Automatically map import fields with SAP IDoc Segments and fields
  • Trigger the execution of the SAP IDoc from an Alteryx workflow
Picture

SAP ODATA

Load, create and update data in SAP using:
  • SAP OData services

Features:
  • Search for SAP OData services
  • Automatically map import fields with SAP OData fields
  • Trigger the execution of the SAP OData service from an Alteryx workflow
Picture

SAP BW INFOPROVIDER

Load data into SAP BW InfoProviders:
  • InfoCube
  • ODS Objects
Picture

1:1 ALIGNMENT BETWEEN ALTERYX & DVW ACS PRODUCTS

The DVW Alteryx Connector for SAP products align 1:1 with the Alteryx product suite:
  • Use Alteryx Designer? Then you need the DVW ACS for Alteryx Designer
  • ​​Use Alteryx Server and want to publish your SAP-based workflows to Alteryx Server? Then you need the DVW ACS for Alteryx Server
Picture

DVW ACS WORKFLOWS ON ALTERYX GALLERY

Sample workflows are available to trial and paid users on Alteryx Gallery.

​Use the workflows to learn the DVW Alteryx Connector for SAP tools and start building workflows immediately.
Picture

DVW ACS SAP READ TOOLS

SAP Read Tools are used to extract data from SAP systems into Alteryx. The following Standard and Premium SAP Read Tools are available for the DVW Alteryx Connector for SAP:
Standard Tools
  • SAP Table Data Tool
  • SAP BW Read Tool
  • ​SAP Report Tool
  • ​SAP Spool Read Tool
  • ​SAP Query Tool
  • ​SAP Table Data Tool (Enhanced)
  • ​SAP Table Data[X] Tool

​Premium Tools
  • ​SAP Document Read Tool​​​
  • ​SAP Text Read Tool
  • ​SAP BAPI Read Tool
Note: Unless otherwise noted the SAP Read Tools require NO installation of software on SAP.

STANDARD TOOLS

SAP TABLE DATA TOOL

  • ​Search for & extract data from SAP Tables (Transparent / Pooled / Clustered)​
  • Search for & extract data from SAP Views
  • Search for & extract data from SAP S/4HANA CDS Views
  • Access a complete list of fields including custom fields
  • Easily identify related tables in the same Development Class
  • Select fields to be extracted
  • Control maximum number of records to be extracted
  • Apply Filters including Dynamic Filters
  • Use "Splits" function to optimize extract of large data volumes​
Picture
STANDARD TOOL

SAP BW READ TOOL

  • Execute any SAP BW Query or SAP BW Query View
  • Execute SAP BW InfoProvider (including InfoCubes, MultiProviders, Composite Providers, InfoSets, DSO, ADSO, InfoObjects acting as InfoProviders, Calculation Views, Attribute Views & Analytical Views)
  • Execute SAP HANA Calculation Views, Attribute Views & Analytical Views.
  • Extract balanced / unbalanced SAP BW Hierarchy data in an optimized flat tabular format
  • Extract SAP BW Text for any SAP BW InfoObject
  • Apply Filters including Dynamic Filters
  • Use "Splits" function to optimize extract of large data volumes​
Picture
STANDARD TOOL

SAP REPORT TOOL

​​The SAP Report Tool is for use by users who require the following capabilities:
  • Extract data from standard and custom SAP Transactions (T-Codes)
  • Extract data from standard and custom SAP Reports

​The SAP Report Tool allows users to:
  • Search for & extract data from standard and custom SAP Transactions (T-Codes)
  • Search for & extract data from standard and custom SAP Reports
  • Utilize existing Transaction and Report Variants
  • Select fields to be extracted
  • Apply Filters including Dynamic Filters
  • Use "Splits" function to optimize extract of large data volumes​
Note: The SAP Report Tool requires installation on the SAP Application Server
Picture
STANDARD TOOL

SAP SPOOL READ TOOL

​The SAP Spool Read Tool is for use by users who require the following capabilities:
  • Extract data from the SAP Spool for standard and custom SAP Transactions (T-Codes)
  • Extract data from the SAP Spool for standard and custom SAP Reports

​The SAP Spool Read Tool:
  • Works with standard and custom SAP Transactions and Reports that provide the ability to "Execute and Print" and "Execute in Background"
  • Allows users to extract data from SAP Spool Jobs linked to their SAP User Name​
Picture
STANDARD TOOL

SAP QUERY TOOL

  • Works with SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03)
  • Search for SAP Queries
  • Build SAP Queries
  • Execute SAP Queries​
Picture
STANDARD TOOL

SAP TABLE DATA (ENHANCED) TOOL

The SAP Table Data (Enhanced) Tool is for use by more advanced users who require the following capabilities:
  • Super-charged extract of large volumes of data
  • ​Selection of an unlimited number of SAP Table fields in a single extract

​The SAP Table Data (Enhanced) Tool shares the following capabilities with the SAP Table Data Tool:
  • Search for & extract data from SAP Tables (Transparent / Pooled / Clustered)
  • Search for & extract data from SAP Views
  • Search for & extract data from SAP S/4HANA CDS Views
  • Access a complete list of fields including custom fields
  • Easily identify related tables in the same Development Class
  • Select fields to be extracted
  • Control maximum number of records to be extracted
  • Apply Filters including Dynamic Filters
  • Use "Splits" function to optimize extract of large data volumes​
Note: The SAP Table Data (Enhanced) Tool requires installation on the SAP Application Server
Picture
STANDARD TOOL

SAP TABLE DATA[X] TOOL

​The SAP Table Data[X] Tool is for use by more advanced users who require the following capabilities:
  • Super-charged extract of large volumes of data
  • Selection of multiple SAP Tables with a single Tool
  • Creation of Table Joins dynamically during the extract
  • Selection of an unlimited number of SAP Table fields in a single extract

The SAP Table Data[X] Tool shares the following capabilities with the SAP Table Data Tool:​
  • Search for & extract data from SAP Tables (Transparent / Pooled / Clustered)
  • Search for & extract data from SAP Views
  • Search for & extract data from SAP S/4HANA CDS Views
  • Access a complete list of fields including custom fields
  • Easily identify related tables in the same Development Class
  • Select fields to be extracted
  • Control maximum number of records to be extracted
  • Apply Filters including Dynamic Filters
  • Use "Splits" function to optimize extract of large data volumes​
Note: The SAP Table Data[X] Tool requires installation on the SAP Application Server
Picture
STANDARD TOOL

PREMIUM TOOLS

SAP DOCUMENT READ TOOL

​The SAP Document Read Tool is an optional Add-On to the DVW Alteryx Connector for SAP and is for use by users who require the following capabilities:
  • Extract attachments from SAP Transactional Data (e.g. Sales Orders, Plant Maintenance Notifications, General Ledger Documents etc.)
  • Extract attachments from SAP Master Data (e.g. Customer Master, Material Master, Equipment etc.)

​The SAP Document Read Tool allows users to:
  • ​​Search for & extract attachments from SAP Transactional Data in any of the SAP supported MIME type formats including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS Powerpoint etc.
  • ​​Search for & extract attachments from SAP Master Data in any of the SAP supported MIME type formats including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS Powerpoint etc.​
Picture
PREMIUM TOOL

SAP TEXT READ TOOL

The SAP Text Read Tool is an optional Add-On to the DVW Alteryx Connector for SAP and is for use by users who require the following capabilities:
  • Extract SAPscript texts from SAP Transactional Data (e.g. Sales Orders, Plant Maintenance Notifications, General Ledger Documents etc.)
  • Extract SAPscript texts from SAP Master Data (e.g. Customer Master, Material Master, Equipment etc.)

​The SAP Text Read Tool allows users to:
  • ​​Search for & extract texts from SAP Transactional Data in any of the supported SAPscript Text Objects and Text IDs
  • ​​Search for & extract texts from SAP Master Data in any of the supported SAPscript Text Objects and Text IDs​
Picture
PREMIUM TOOL

SAP BAPI READ TOOL

The SAP BAPI Read Tool is an optional Add-On to the DVW Alteryx Connector for SAP and is for users who require the following capabilities:
  • Extract data from  SAP BAPIs
  • Extract data from SAP RFC-enabled Function Modules

​The SAP BAPI Read Tool allows users to:
  • Search for & extract data from SAP BAPIs
  • Extract data from SAP RFC-enabled Function Modules
  • Apply Filters to the extract
  • Automatically format the extract output​
Picture
PREMIUM TOOL

DVW ACS SAP WRITE TOOLS

The SAP Write Tools are used to load, create & update data in SAP systems from Alteryx. The following Premium SAP Write Tools are available for the DVW Alteryx Connector for SAP:
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP BW Write Tool
Note: The SAP Write Tools require NO installation of software on SAP.

PREMIUM TOOLS

​SAP BAPI WRITE TOOL

​The SAP BAPI Write Tool is an optional Premium Add-On to the DVW Alteryx Connector for SAP. ​

​Use the SAP BAPI Write Tool to load data from Alteryx workflows directly into SAP using  SAP BAPIs or SAP RFC-enabled Function Modules.

​Multiple use cases are supported including but not limited to:
  • Creation of Sales Orders
  • Creation of Purchase Requisitions
  • Posting Goods Movements
  • Posting G/L Documents
  • Simulating Sales Orders ​​​
Picture
PREMIUM TOOL

SAP IDOC WRITE TOOL

​The SAP IDoc Write Tool is an optional Premium Add-On to the DVW Alteryx Connector for SAP. ​

Use the SAP IDoc Write Tool to load data from Alteryx workflows directly into SAP using IDoc (Intermediate Document) technology.

​Multiple use cases are supported including but not limited to:
  • Data Migration for SAP S/4HANA
  • Loading and update of Master data including Customers, Vendors, Condition Records etc.
  • Loading and update of Transaction data including General Ledger Postings, Sales Orders, Purchase Order etc.
Picture
PREMIUM TOOL

SAP BW WRITE TOOL

​The SAP BW Write Tool is an optional Premium Add-On to the DVW Alteryx Connector for SAP. ​

Use the SAP BW Write Tool to load data from Alteryx workflows directly into SAP BW InfoProviders (InfoCube and ODS Objects)​​
Picture
PREMIUM TOOL

KEY FEATURES OF THE DVW ACS

Picture
Installed as an Alteryx plug-in
Picture
Most DVW ACS Tools need no installation on SAP
Picture
No extra Hardware required
Picture
Works with all Alteryx tools
Picture
Schedule Workflows with Alteryx Server
Picture
No staging of data required
Picture
Use multiple SAP systems in a single Workflow
Picture
Respects user's SAP authorizations
Picture
Designed to optimize extract of large data volumes
Picture
Delta loads supported
Picture
Uses standard SAP API's
Picture
Supports SSO

PRODUCTS

​ALTERYX CONNECTORS
​ALTERYX CONNECTOR FOR SAP
​
ALTERYX RPA TOOLS
​ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
​ALTERYX CONNECTOR FOR BUSINESSOBJECTS
​ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​
​ALTERYX CONNECTOR FOR SAP IBP (COMING SOON)

​KNIME CONNECTORS
​KNIME CONNECTOR FOR SAP
​KNIME CONNECTOR FOR SUCCESSFACTORS

​POWER BI CONNECTORS
POWER BI CONNECTOR FOR SAP

TABLEAU CONNECTORS
TABLEAU CONNECTOR FOR SAP

DATAIKU CONNECTORS

​DOMO CONNECTORS

SNOWFLAKE CONNECTORS

FREE TRIAL

​ALTERYX CONNECTORS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
​FREE TRIAL OF ALTERYX RPA TOOLS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​

​KNIME CONNECTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
FREE TRIAL OF KNIME CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF ​KNIME CONNECTOR FOR SUCCESSFACTORS

POWER BI CONNECTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF POWER BI CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP
​​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF TABLEAU CONNECTOR FOR SUCCESSFACTORS

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP

DOMO CONNECTORS
FREE TRIAL OF DOMO CONNECTOR FOR SAP

SERVICES

PRICING

DEMOS

BLOG

HELP CENTRE

ABOUT US

CONTACT US

The DVW Integration Platform from DVW Analytics, brings the power of SAP to users of Alteryx, KNIME, Power BI, Tableau and other global software leaders for Analytics & Process Automation

© COPYRIGHT 2003 - 2023 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX RPA CONNECTOR
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • DATAIKU CONNECTORS
    • DOMO CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • UPCOMING WEBINARS
      • ON-DEMAND WEBINARS
    • EVENTS >
      • UPCOMING EVENTS
      • PAST EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS