- FREE TRIAL
- ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
- ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
- ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
- ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
- ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
- ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
- ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
- ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
- EVENTS >
- RESELLER RESOURCES
- GETTING STARTED
- INSTALLATION GUIDES
- SOFTWARE DOWNLOADS
- SAMPLE WORKFLOWS
- WEBINARS >
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.
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.
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:
For the purposes of this blog, we will focus on enabling APA for SAP with our flagship product, the Alteryx Connector for SAP (ACS).
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:
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:
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:
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.”
Let’s consider a couple of examples focused on process automation and data migration.
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.
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.
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:
Not all our customers like to be named but I can share some anecdotes to conclude on:
Global Oil & Gas Company
Global Consumer Goods Company
Global Beverage Company
Global Apparel and Footwear Company
ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT
KNIME CONNECTOR FOR SAP
POWER BI CONNECTOR FOR SAP
TABLEAU CONNECTOR FOR SAP
DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, KNIME, Power BI, Tableau & other global leaders in BI and analytics.
© COPYRIGHT 2003 - 2021 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.