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

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
  • SAP Metadata Connector for Alteryx Connect

​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
    BusinessObjects
    Data Migration
    DVW Integration Platform
    Finance
    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 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
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

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