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 Connector for SAP Customer Experience (CX)
      • Alteryx Connector for SAP SuccessFactors
      • Alteryx Connector for SAP BusinessObjects
    • Alteryx RPA Tools
    • KNIME Connectors >
      • KNIME Connector for SAP
    • Power BI Connectors >
      • Power BI Connector for SAP
    • Tableau Connectors >
      • Tableau Connector for SAP
    • Dataiku Connectors
    • Snowflake Connectors
  • Demos
    • Alteryx Connector Demos
    • Alteryx RPA Tools Demos
    • KNIME Connector Demos
    • Power BI Connector Demos
    • Tableau Connector Demos
    • Dataiku Connector Demos
    • Snowflake Connector Demos
    • DVW Flow Tool Demos
  • Webinars
    • Alteryx Connector Webinars
    • Alteryx RPA Tools Webinars
    • KNIME Connector Webinars
    • Power BI Connector Webinars
    • Tableau Connector Webinars
    • Dataiku Connector Webinars
    • Snowflake Connector Webinars
    • DVW Flow Tool Webinars
  • Pricing
    • Alteryx Connector Pricing
    • Alteryx RPA Tools Pricing
    • KNIME Connector Pricing
    • Power BI Connector Pricing
    • Tableau Connector Pricing
    • Dataiku Connector Pricing
    • Snowflake Connector Pricing
  • Free Trial
  • Blog
  • Resources
    • About Us
    • Events
    • Customers
    • Partners
    • Resellers
    • Services
    • Sample Workflows
    • License
    • Help Centre
  • Contact Us

Blog

Enabling Analytic Process Automation for SAP with Alteryx & DVW Analytics

20/10/2020

 
Picture
With the introduction of Analytic Process Automation (APA), Alteryx has reframed not only how we think about Alteryx as a company, but also how we use the individual components that comprise the Alteryx APA Platform to deliver business benefit quickly.
As CEO of DVW Analytics my primary focus is on making it as easy as possible for our SAP customers to work with their data in the Alteryx APA Platform.

Why?

Well, for those organizations that run SAP, the SAP systems are the richest source of high-quality business data available to the organization and its employees.

While SAP offers a range of analytics products to customers, we are seeing an increasing number of SAP customers adopting Alteryx for its analytics and process automation capabilities.

When you combine Alteryx with SAP, the results can be genuinely astounding. But don’t take my word for it. Take a look at the on-demand webinar, Analyse + Automate Your SAP Data with Coca-Cola European Partners.

In the remainder of this blog, we’ll demonstrate how Alteryx and DVW Analytics can enable Analytic Process Automation for SAP customers.

​Let’s start with a little more about Alteryx APA.
Picture
So, on the left we have the automation of asset inputs and on the right the automation of outcomes for people and the automation of outcomes to applications.

These are the two areas where DVW Analytics supports SAP customers in their APA journey.
DVW Analytics is an Alteryx Technology Partner that develops and sells three categories of connector that include:
​
  • Alteryx Connector for SAP
  • Alteryx Connector for BusinessObjects
  • Alteryx Connector for SuccessFactors

​For the purposes of this blog, we will focus on enabling APA for SAP with our flagship product, the Alteryx Connector for SAP (ACS).
Picture

Automating Asset Inputs

The DVW ACS Read capability supports the extraction of data from a wide range of SAP systems including but not limited to:
  • SAP ECC
  • SAP S/4HANA
  • SAP BW including SAP BW on HANA and SAP BW4/HANA
  • SAP Business Suite applications including SAP ERP, SAP CRM, SAP SRM, SAP HCM, and SAP PLM
  • SAP Industry solutions including SAP Oil & Gas (IS-Oil), SAP Utilities (IS-UTIL), SAP Telecommunications (IS-Telco), SAP Retail (IS-Retail), and more

Across these different SAP systems, users can extract data from a comprehensive set of SAP data objects. This allows the DVW ACS to be used effectively by everyone, including business users, IT users, SAP novices, and SAP experts. According to your specific use case, you can extract data from:
  • SAP Tables
  • SAP Transactions (T-Codes) and Reports
  • SAP Queries
  • SAP HANA Views
  • SAP BW Queries and Query Views
  • SAP BW InfoProviders
  • SAP Attachments e.g., PDF, image files

​By way of example, take a look at how Alteryx and the DVW ACS can be used to extract SAP General Ledger accounting data into Alteryx – a very common use case.

Automating Outcomes for People and Applications

For many of our customers, the ultimate destination for the SAP data that has been blended and analysed within Alteryx may be visualisation tools such as Tableau and Power BI. For others it could be cloud applications such as Salesforce or even the dear old spreadsheet for those still stuck in them.

At Alteryx Inspire, Apex Tool Group talked about their experience creating measurable returns with Alteryx and the DVW Alteryx Connector for SAP. Underpinning one of their use cases was the ability to be able to extract data from SAP (in this case SAP BW), analyzing the data in Alteryx before pushing to Salesforce.com and Tableau.

The DVW ACS Write capability opens up the ability for our users to load, create, or update data back into their SAP systems from Alteryx. Currently, ACS Write capability is supported for SAP systems including:
  • SAP ECC
  • SAP S/4HANA
  • SAP BW including SAP BW on HANA and SAP BW4/HANA
  • SAP Business Suite applications including SAP ERP, SAP CRM, SAP SRM, SAP HCM, and SAP PLM
  • SAP Industry solutions including SAP Oil & Gas (IS-Oil), SAP Utilities (IS-UTIL), SAP Telecommunications (IS-Telco), and SAP Retail (IS-Retail)

​This ability combined with the capabilities of Alteryx explode the number of potential use cases that are available to SAP customers with the Alteryx APA platform. As a customer recently said, “I’m really only limited by my imagination in what I can do.”

Examples

Let’s consider a couple of examples focused on process automation and data migration.

​Process Automation

There are an almost limitless number of process automation use cases ranging from the posting of G/L Journal Entries into SAP to the generation of Goods Movements and the creation and modification of master data records such as the Material Master. These are typically time-consuming, manual tasks performed by SAP end users.

Watch this example of how Alteryx and the DVW ACS can be used to automate a task such as the posting of G/L Journal Entries into SAP.

Data Migration

The implementation of SAP S/4HANA will be front of mind for the majority of SAP customers over the next few years. The primary reason is that the dominant ERP application used by SAP customers today, SAP ECC, goes out of mainstream support in 2027. This may sound like a long way away. But, when you consider that many of these programmes will span multiple years and run into the tens of millions, if not hundreds of millions of dollars, 2027 is closer than it seems.
​
Using the DVW ACS with the Alteryx APA platform, SAP customers can reduce the time, cost, and risk associated with an SAP migration.
Picture
In the above example, the DVW ACS Read capability is used to perform the mass or selective extract of data from the source SAP ECC system into Alteryx. No army of developers required.

Alteryx is then used to review, cleanse, transform, and prepare the data for loading into the target SAP S/4HANA system.

The DVW ACS Write capability is then used to load the data from Alteryx into the SAP S/4HANA system. We support IDOC and BAPI for this.

Finally, the DVW ACS Read capability and Alteryx are used to reconcile the migration with extracts from both the source and target systems.

​Watch this simple example of SAP ECC Pricing Condition Record data being migrated to SAP S/4HANA.
While I’ve focused on SAP ECC to SAP S/4HANA migrations, the same principles apply to Non-SAP to SAP migrations and SAP to Non-SAP migrations.
​
So, by using the Alteryx APA platform with the DVW ACS, SAP customers can:
  • Reduce the cost, time, and risk associated with an SAP migration
  • Provide enhanced visibility of the migration process for business sponsors and business users
  • Enable simplified migration reconciliation reporting (on-the-fly reconciliation is possible)
  • Improved collaboration through the migration process with the use of Alteryx Connect

Anecdotes

Not all our customers like to be named but I can share some anecdotes to conclude on:

Global Oil & Gas Company
  • Before Alteryx & DVW Analytics: Analytics project with $5M budget & implementation timeframe of 6 months
  • With Alteryx & DVW Analytics: Project delivered with 1 person in 1 week (During the DVW ACS trial)

Global Consumer Goods Company
  • Before Alteryx & DVW Analytics: 12-week SAP development project required to perform one data extract before analytics project could commence
  • With Alteryx & DVW Analytics: 3-days to build the data extract workflow

Global Beverage Company
  • Before Alteryx & DVW Analytics: 3-months for 2 resources to build a Customer Profitability solution which took 8 hours to execute. No flexibility to customize the solution to specific markets
  • With Alteryx & DVW Analytics: 1-day to build a customizable solution. Execution time reduced to 6 minutes from 8 hours

Global Apparel and Footwear Company
  • With Alteryx: Analytics saved 1 week per month
  • With Alteryx & DVW Analytics: Data extract and analytics saved 3 weeks per month

​This blog was originally posted on Alteryx Community in October 2020
Get a Free Trial today

Comments are closed.

    RSS Feed

    Categories

    All
    ACS
    ACS BOP
    ACS CX
    ACS Metadata
    ACS SF
    Alteryx
    Alteryx Connector For BusinessObjects
    Alteryx Connector For SAP
    Alteryx Connector For SuccessFactors
    Alteryx Gallery
    Alteryx Inspire
    Alteryx RPA Tools
    Alteryx Server
    APA
    Audit
    Augmented Analytics
    BusinessObjects
    Dataiku
    Data Migration
    DVW Flow Tool
    DVW Integration Platform
    Finance
    Flow Tool
    KCS
    KNIME
    KNIME Connector For SAP
    Microsoft Azure
    Office Of Finance
    On Demand Webinar
    Power BI
    Power BI Connector For SAP
    Predictive Analytics
    Process Automation
    Professional Services
    Qlik
    Read Tools
    RPA
    Salesforce
    Salesforce Wave Analytics
    Sample Workflow
    SAP Business Suite
    SAP BW
    SAP C4C
    SAP ECC
    SAP ERP
    SAP HANA
    SAP S/4HANA
    SAP Tables
    SAP T Codes
    SAP T-Codes
    SAP Transaction Codes
    Snowflake
    Snowflake Connector For SAP
    SuccessFactors
    Tableau
    Tableau Connector For SAP
    Tableau Desktop
    Tableau Online
    Tableau Prep
    Tableau Server
    Tax
    TCS
    ThoughtSpot
    Tool: BOP Universe
    Tool: BOP Webi
    Tool: HTML RPA
    Tool: SAP BAPI Read
    Tool: SAP BAPI Write
    Tool: SAP BW Write
    Tool: SAP Document Read
    Tool: SAP IDoc
    Tool: SAP Query
    Tool: SAP Report
    Tool: SAP RPA
    Tool: SAP Spool Read
    Tool: SAP Table Data
    Tool: SuccessFactors Read
    Tool: SuccessFactors Write
    Top 10 Blog
    Webinar
    Write Tools

    Archives

    January 2025
    November 2024
    October 2024
    September 2024
    July 2024
    June 2024
    May 2024
    March 2024
    February 2024
    December 2023
    October 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    October 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    May 2021
    April 2021
    December 2020
    October 2020
    July 2020
    June 2020
    May 2020
    February 2020
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    September 2018
    August 2018
    June 2018
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

Products

​Alteryx Connectors
​KNIME Connectors
​Power BI Connectors
Tableau Connectors
Dataiku 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 CX
Free Trial of Alteryx Connector for SAP SuccessFactors
Free Trial of Alteryx Connector for SAP IBP
Free Trial of Alteryx Connector for SAP Ariba
Free Trial of Alteryx Connector for SAP BusinessObjects

​KNIME Connectors
​Free Trial of KNIME Connector for SAP

Power BI Connectors
Free Trial of Power BI Connector for SAP

Tableau Connectors
Free Trial of Tableau Connector for SAP

Dataiku Connectors
Free Trial of Dataiku Connector for SAP

Snowflake Connectors
Free Trial of Snowflake Connector for SAP

DVW Flow Tool
Free Trial of DVW Flow Tool

Services

Pricing

Demos

Blog

Help Centre

About Us

Contact Us

DVW Analytics brings the power of SAP to users of Alteryx, KNIME, Power BI, Dataiku and other global software leaders.

© COPYRIGHT 2003 - 2024 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 Connector for SAP Customer Experience (CX)
      • Alteryx Connector for SAP SuccessFactors
      • Alteryx Connector for SAP BusinessObjects
    • Alteryx RPA Tools
    • KNIME Connectors >
      • KNIME Connector for SAP
    • Power BI Connectors >
      • Power BI Connector for SAP
    • Tableau Connectors >
      • Tableau Connector for SAP
    • Dataiku Connectors
    • Snowflake Connectors
  • Demos
    • Alteryx Connector Demos
    • Alteryx RPA Tools Demos
    • KNIME Connector Demos
    • Power BI Connector Demos
    • Tableau Connector Demos
    • Dataiku Connector Demos
    • Snowflake Connector Demos
    • DVW Flow Tool Demos
  • Webinars
    • Alteryx Connector Webinars
    • Alteryx RPA Tools Webinars
    • KNIME Connector Webinars
    • Power BI Connector Webinars
    • Tableau Connector Webinars
    • Dataiku Connector Webinars
    • Snowflake Connector Webinars
    • DVW Flow Tool Webinars
  • Pricing
    • Alteryx Connector Pricing
    • Alteryx RPA Tools Pricing
    • KNIME Connector Pricing
    • Power BI Connector Pricing
    • Tableau Connector Pricing
    • Dataiku Connector Pricing
    • Snowflake Connector Pricing
  • Free Trial
  • Blog
  • Resources
    • About Us
    • Events
    • Customers
    • Partners
    • Resellers
    • Services
    • Sample Workflows
    • License
    • Help Centre
  • Contact Us