Blog - DVW Analytics

Using the most commonly used SAP Transactions (T-Codes) with Alteryx

16/7/2020

In this blog we present a list of the most commonly used SAP Transactions (T-Codes) and the DVW ACS tools that can be used to either read (extract) data from them or write (load / create / update) data to them.

The list of T-Codes was compiled based on a combination of web search and personal experience. So, if there's a particular T-Code that is used extensively within your company and is not on this list, let us know and we will update the blog with details.

Analytic Process Automation in action - Creating SAP Sales Orders with Alteryx & the DVW Alteryx Connector for SAP

26/6/2020

Many of you will already be familiar with the capabilities of the DVW Alteryx Connector for SAP in reading (extracting) data from a wide range of SAP systems and sources into Alteryx.

Enabling Analytic Process Automation in an SAP context however requires the ability not only to read data but to write (load) it back into SAP.

On-Demand Webinar: Analyse + Automate Your SAP Data

20/6/2020

Thanks to everyone who joined Alteryx, DVW Analytics and Coca-Cola European Partners for, "Analyse and Automate your SAP data".

The webinar is now available on-demand. So, if you missed it first time around or just want to relive the "magic" again, read on.

On-Demand Webinar: What's new with the DVW Alteryx Connector for SAP

28/5/2020

View this on-demand webinar to learn how we’ve enhanced the functionality and capability of the DVW Alteryx Connector for SAP (ACS) with version 2.1.2018, our first major release since 2019.

Tax, Audit & Finance - Extract Sales & Purchasing Tax Data from SAP ECC & SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP

20/2/2020

The use of Alteryx within the Tax, Audit and Finance functions is a particularly hot topic at the moment and with good reason. Alteryx can help users across the Tax, Audit, and Finance offices to significantly reduce the time and effort spent manually gathering data and reconciling business and legal entities, along with generating their internal and regulatory reporting.

All of this is true, but if the majority of the data you need to access resides in an SAP system you will need the DVW Alteryx Connector for SAP to streamline the import of that data into Alteryx.

SAP Data Migration - Load SAP ECC Pricing Condition Record Data into SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP

16/11/2019

In this demo we will show you how Alteryx and the DVW Alteryx Connector for SAP can be used to migrate SAP ECC Pricing Condition Records to SAP S/4HANA.

Extract SAP Vendor Line Item data into Alteryx (T-Code FBL1N)

7/10/2019

The SAP Report tool is used to extract data from SAP Transaction Codes (T-Codes) and SAP Reports directly into Alteryx.

In this blog we will show you how to use the SAP Report tool to extract data from the SAP Vendor Line Item Display transaction (T-Code FBL1N) into Alteryx.

Accelerate your migration to SAP S/4HANA with Alteryx and the DVW Alteryx Connector for SAP

13/9/2019

As an SAP customer you will, at some point in the near future, need to consider replacing SAP ECC with SAP S/4HANA.

Regardless of whether you proceed with a new (Greenfield) implementation, a system conversion (the so-called, Brownfield approach) or a selective data transition; the successful migration of your business data will be key to delivering a successful programme.

How to extract attachments for SAP ECC & SAP S/4HANA Plant Maintenance and Customer Service documents into Alteryx

31/8/2019

The SAP Document Read tool can extract attachments 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.

In this blog we will show you how to extract attachments for Plant Maintenance and Customer Service documents stored in SAP ECC or SAP S/4HANA. For example you can extract the attachments for Plant Maintenance Notifications (IW21 / IW22 / IW23), Plant Maintenance Orders / Service Orders (IW31 / IW32 / IW33), Service Notifications (IW51 / IW52 / IW53), Functional Locations (IL01 / IL02 / IL03), Equipment (IE01 / IE02 / IE03) and so on.

On-Demand Webinar: SAP for everyone - An introduction to SAP data preparation and analytics with Alteryx

17/7/2019

Business users want to power their analytics with SAP data. But, working with SAP data can be cumbersome, time-consuming and costly.

Join this on-demand webinar to learn how you can easily extract data from SAP; consume that data in almost any way you choose and then automate the whole process. Instead of extracting your SAP data manually using common techniques - learn how you can use Alteryx and the DVW Alteryx Connector for SAP (ACS) to do the job for you.

On-Demand Webinar: Detailed walkthrough of the DVW Alteryx Connector for SAP

17/7/2019

Watch this On-Demand webinar to learn:

How to install the DVW Alteryx Connector for SAP
How to use the SAP BW Read tool
How to use the SAP Table Data tool and Filter tool
How to use the SAP Query tool
How to use the SAP Report tool
Important sources: Installation Guide / Tutorials / Software

Learn how you can easily extract SAP General Ledger accounting data from SAP ECC & SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP

7/6/2019

In this blog we will show you how you can easily extract SAP General Ledger Accounting Data from SAP ECC & SAP S/4HANA into Alteryx with the DVW Alteryx Connector for SAP.

Accelerate your SAP and Salesforce migrations with Alteryx and the DVW Alteryx Connectors for SAP

30/9/2018

Alteryx is recognised as a leader in the self-service data analytics movement, yet it’s data blending capabilities lend it to use cases beyond those of interest to its core data analytics audience.

In this blog, we’ll consider the use of Alteryx to accelerate the migration of data from one enterprise application software product to another. Specifically, we’ll look at the migration of data from one Customer Relationship Management (CRM) solution to another.

If I plan to use SAP HANA CDS Views with Alteryx, do I still need the Alteryx Connector for SAP?

23/8/2018

The use of SAP HANA CDS Views and the Alteryx Connector for SAP (ACS) with Alteryx is not mutually exclusive. Whether you should use one, the other or both depends upon a number of different factors.

Alteryx Inspire 18 - Announcing the Winners of our Alteryx Connector for SAP Prize Draw

17/6/2018

We want to send a big thank you to everyone who participated in our Alteryx Inspire 18 Prize Draw and helped make it a success!

Alteryx SAP HANA ODBC driver vs the DVW Alteryx Connector for SAP

10/6/2018

We are often asked by Alteryx users the difference between using the Alteryx SAP HANA ODBC driver and the DVW Alteryx Connector for SAP.

Introducing DVW Analytics Training Services for Alteryx, Tableau, SAP, BusinessObjects and the DVW Connectors for SAP

9/6/2018

The DVW Analytics Training Team can help you to maximize your investment in Alteryx, Tableau, SAP, BusinessObjects and our portfolio of SAP connectors including:

Alteryx Connectors for SAP presentation to the Alteryx Dallas Ft. Worth User Group January 2018

1/2/2018

Many thanks to Teknion Data Solutions for hosting the Alteryx Dallas Ft. Worth User Group on 26th January, 2018. If you were unable to attend or want to relive the "magic", take a look at our presentation of the Alteryx Connectors for SAP.

Check out Alteryx CEO, Dean Stoecker's keynote speech at Inspire 2017

1/7/2017

It's not often that you get a shout-out from the CEO of a publicly listed company during the keynote speech of the company's annual conference. But, that's what happened last month at Alteryx Inspire 2017.

Struggling to use your SAP data in Tableau? We’ve got the answer.

17/4/2017

If you are a Tableau user who also uses SAP, getting access to your SAP data within Tableau can be a real headache. In this blog, we will introduce you to two approaches that will allow you to quickly and easily connect to your SAP BW, SAP Business Suite and SAP BusinessObjects data without having to install any additional software within your SAP landscape.

Predict new customers using Alteryx, SAP and Microsoft Power BI

26/3/2017

In this blog we will use Alteryx to build a model that produces a prioritized list of prospective customers for targeted marketing campaigns.

The Alteryx workflow builds a linear regression model using current customer data from SAP which is scored against prospective customer data from an Excel Sheet to produce a prioritized list of prospects.

The data is then published to Microsoft Power BI.

Blending Salesforce.com data with SAP data using Alteryx and the Alteryx Connector for SAP

13/2/2017

In this blog we will show you how you can seamlessly blend data from Salesforce.com (SFDC) with data from SAP using Alteryx and the Alteryx Connector for SAP (ACS).

Analyse your SAP data in Salesforce Wave Analytics with Alteryx and the Alteryx Connector for SAP

12/2/2017

If you are using Salesforce Wave Analytics to analyse your CRM data you may find it useful to blend that with your back office SAP ECC data. Take a look at our short demo showing how easy it is to pull data from SAP using the Alteryx Connector for SAP before loading it into Salesforce Wave Analytics with Alteryx.

Load SAP data into Salesforce.com with Alteryx and the Alteryx Connector for SAP

11/2/2017

Running SAP ECC for your back office but Salesforce.com for your CRM? Take a look at our short demo showing how easy it is to pull data from SAP using the Alteryx Connector for SAP before loading it into Salesforce.com with Alteryx.

SAP, Alteryx Predictive Analytics and Qlik

10/2/2017

If you are pulling your SAP data directly into Qlik you could be missing a trick. Check out our short demo of SAP data being used with the Predictive Analytics capabilities of Alteryx before visualising the data in Qlik.

PRODUCTS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP CLOUD
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

SERVICES

PROFESSIONAL SERVICES
TRAINING

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS

DEMOS

BLOG

ABOUT US

CONTACT US

DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, Tableau & other global leaders in BI and analytics.

© COPYRIGHT 2003 - 2020 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.