DVW ALTERYX CONNECTOR FOR SAP

---

• OVERVIEW
• FEATURES
• CORE TOOLS
• ADVANCED 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. 

GET A FREE TRIAL TODAY

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 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)

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

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 DVW Alteryx Connector for SAP comprises the following Core Tools:

• SAP Table Data Tool
• SAP BW Read Tool
• ​SAP Query Tool

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

SAP BW READ TOOL

• Execute any SAP BW Query or SAP BW Query View
• Execute SAP BW InfoProvider (including InfoCubes, MultiProviders and InfoSets)
• 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 QUERY TOOL

• Works with SAP Queries (Transaction SQVI)
• 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

The DVW Alteryx Connector for SAP comprises the following Advanced Tools:

• SAP Table Data[X] Tool
• SAP BW Read[X] 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
• 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

​SAP BW READ[X] TOOL

The SAP BW Read Table Data[X] Tool is for use by more advanced users who require the following capabilities:

• Super-charged extract of large volumes of data

The SAP BW Read[X] Tool shares the following capabilities with the SAP BW Read Tool:

• Execute SAP BW InfoProvider (including InfoCubes, MultiProviders and InfoSets)
• Apply Filters including Dynamic Filters
• 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 BW Read[X] Tool requires installation on the SAP Application Server

FREE TRIAL

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

GET A FREE TRIAL TODAY

PRICING

Take a look at current pricing for the DVW Alteryx Connector for SAP

PRICING

DON'T HAVE ALTERYX YET?

Get a free 14-day trial of Alteryx Designer from Alteryx

GET A FREE TRIAL OF ALTERYX DESIGNER TODAY