DVW ALTERYX CONNECTOR FOR SAP

  • OVERVIEW
  • FEATURES
  • SAP READ TOOLS
  • SAP WRITE TOOLS
  • NEXT STEPS
<
>
The DVW Alteryx Connector for SAP (ACS) is the fastest, easiest way to extract data from SAP into Alteryx.

​Seamlessly extract and blend data from SAP with data from other sources into your analytical applications. 

WORKS WITH YOUR CORE SAP SYSTEMS

The DVW Alteryx Connector for SAP works with all of your core SAP systems including:
  • SAP BW (incl. SAP BW/4HANA)
  • SAP Business Suite Applications (incl. SAP ECC, SAP ERP, SAP CRM, SAP SCM, SAP TPM etc.)
  • SAP S/4HANA 
Don't see your SAP system here? Then please contact our team to check if your SAP system is covered.
If you want to extract data from a BusinessObjects system then check out the DVW Alteryx Connector for BusinessObjects.

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.

SAP TABLES

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​

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 ​

SAP TRANSACTIONS (T-CODES)

Extract data from:
  • Standard and custom SAP Transactions (T-Codes)
  • Standard and custom SAP 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 ​

SAP HANA CALCULATION VIEWS 

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

SAP HANA CDS VIEWS 

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

SAP QUERIES

Extract data from:
  • SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03)
Features:
  • Search for SAP Queries
  • Build SAP Queries
  • Execute SAP Queries

WHICH DVW ALTERYX CONNECTOR FOR SAP DO I NEED?

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 Designer with the Desktop Scheduling add-in from Alteryx? Then you need the DVW ACS for Alteryx Designer with Desktop Scheduling
  • Use Alteryx Server and want to publish your SAP-based workflows to Alteryx Server? Then you need the DVW ACS for Alteryx Server

SAMPLE 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.
Installed as an Alteryx plug-in
Core tools need no installation on SAP
No extra Hardware required
Works with all Alteryx tools
Schedule Workflows with Alteryx Scheduler & Alteryx Server
No staging of data required
Use multiple SAP systems in a single Workflow
Respects user's SAP authorizations
Designed to optimize extract of large data volumes
Delta loads supported
Uses standard SAP API's
Supports SSO
The SAP Read Tools are used to extract data from SAP systems into Alteryx. ​The following SAP Read Tools are available for the DVW Alteryx Connector for SAP:

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
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • Requires NO installation on SAP
STANDARD TOOL
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
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • Requires NO installation on SAP

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
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
Note: The SAP Report Tool requires installation on the SAP Application Server
STANDARD TOOL
STANDARD TOOL

SAP QUERY TOOL

  • Works with SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03)
  • Search for SAP Queries
  • Build SAP Queries
  • Execute SAP Queries
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • Requires NO installation on SAP

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
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
Note: The SAP Table Data[X] Tool requires installation on the SAP Application Server
STANDARD TOOL
PREMIUM TOOL

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.
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • ​Requires NO installation on SAP

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
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • ​Requires NO installation on SAP
PREMIUM TOOL
The SAP Write Tools are used to load data into SAP systems from Alteryx. The following SAP Write Tools are available for the DVW Alteryx Connector for SAP:

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.
Other features of note:
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • ​Requires NO installation on SAP
PREMIUM TOOL
PREMIUM TOOL

SAP BW WRITE TOOL

​The SAP BW Write Tool is an optional Premium Add-On to the DVW Alteryx Connector for SAP. ​
  • Load data from Alteryx workflows directly into SAP BW InfoProviders (InfoCube and ODS Objects)
  • Schedule Workflows with DVW ACS for Alteryx Designer with Desktop Scheduling and DVW ACS for Alteryx Server
  • Publish Workflows to Alteryx Gallery with DVW ACS for Alteryx Server
  • Requires NO installation on SAP

FREE TRIAL

We offer a free 14-day trial of the DVW Alteryx Connector for SAP

PRICING

Take a look at current pricing for the DVW Alteryx Connector for SAP
© COPYRIGHT 2003 - 2020 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY