DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • 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 >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

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

13/2/2017

0 Comments

 
Picture
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).
For the purposes of this blog I’ve defined the following simple scenario: I want to identify all open Opportunities in SFDC that have an Amount (i.e. value) greater than the Customer’s Credit Limit in SAP ECC. 

​To deliver the scenario, I’m going to create an Alteryx workflow that extracts Account and Opportunity data from SFDC and blends it with Customer and Customer Credit Management data from SAP. I’ll then apply a formula to the blended data to identify Opportunities which, if converted into Orders or Contracts, will result in the Customer Credit Limit being breached. Finally, I’ll split the categorized data into two outputs: A list of Opportunities that will breach the Customer Credit Limit and a list of Opportunities which have sufficient Credit Limit coverage.
Picture
While the scenario is admittedly a very simple one, my hope is that this blog and video will give you some inspiration as to how your business could benefit from combining data from these very different sources using Alteryx.

​Let’s get started.

​Identifying the source of data in Salesforce.com

I need access to Account and Opportunity data in SFDC. 
​
In my SFDC system I have some basic Account data that I’m interested in. Specifically, the Account Name and Account Number.
Picture
This data is stored in the SFDC Account table.

​On the Opportunity, I’m interested in the Account and the Amount.
Picture
​This data is stored in the SFDC Opportunity table.

Identifying the source of data in SAP

I need access to Customer and Customer Credit Limit Information in SAP ECC. Specifically, I’m interested in the Customer Number, Customer Name and Credit Limit.

​At the transaction code level, I can access the Customer Master record using transaction VD03 or XD03. This will provide me with the Customer Number and Customer Name.
Picture
Within Alteryx I can use the Alteryx Connector for SAP (ACS) to access this data using either the SAP Table Connector, the SAP BW Query Connector or the SAP BW InfoProvider Connector.

​In this scenario I’m going to use the SAP Table Connector. The Customer data I need is stored in table KNA1 (General Data in Customer Master). You can see the table level view of this data using transaction SE16 or SE16N.
Picture
​The Customer Credit Limit information is accessed with a different transaction: FD33.
Picture
The Customer Credit Limit data I need is stored in table KNKK (Customer Master Credit Management). You can see the table level view of this data using transaction SE16 or SE16N.

​I’m also going to use the ACS Table Connector to access this data.
Picture

Extracting data from Salesforce.com

​Now that I’ve identified my SFDC and SAP data sources, I can start to build the Alteryx workflow.
Picture
​Connecting to SFDC via Alteryx is pretty straightforward. In our scenario, I’m extracting data from SFDC so simply drag the SFDC Input tool onto the canvas. I’m then prompted to enter my SFDC Credentials.
Picture
The Security Token is assigned when your SFDC user is set-up and is updated if you request a password reset.

​For the SFDC Opportunity extract I’ve used a Custom Query because I only want to extract Opportunity data where the status of the Opportunity is not, “Closed”.
Picture
I also Validate the query to make sure that it is can processed by SFDC.

​For the Account data I’m using the Query Builder function and have selected the fields that I’m interested in. I’m most interested in the “Id” field and the “Name” field.
Picture
​In the Opportunity extract the “Account Id” is available not the Account “Name”.
Picture
Because of this I need to combine data from the Account and Opportunity tables.

​In Alteryx, I use the Join tool to do this. 
Picture
​The combined output gives me something I can start to work with. 
Picture

Extracting data from SAP

Picture
Connecting to SAP with the Alteryx Connector for SAP (ACS) is as simple as for SFDC.

​As a starting point I drag the SAP Logon tool onto the canvas, enter my ACS license key and search for my available SAP Servers.
Picture
​I then select the Parameters tab, select the SAP systems I want to connect to and in this scenario (because I am using User and Password access to SAP rather than SSO) enter the User and Password for each SAP system I’ve selected. In this workflow I’m just going to connect to my SAP ECC system.
Picture
The next step is to set-up the SAP data extract. So, I’m going to use the SAP Table connector to access data from my SAP Customer table (KNA1) and my SAP Customer Credit Management table (KNKK).

Drag the SAP Table connector on to the canvas and link it to the SAP Logon tool. This ensures that the SAP system credentials are passed from the SAP Logon tool to the other SAP connector tools without me having to reenter my login details.

​Choose the SAP system you want to use with the SAP Table tool.
Picture
On the parameters tab of the SAP Table tool, I search for the table I’m interested in.

​I’m going to extract data from the General Data in Customer Master table or KNA1. I’m primarily interested in the Customer Number (KUNNR) and Name (NAME1).
Picture
​I repeat the set-up step to access data from the Customer Master Credit Management (KNKK). I’m interested in the Customer (KUNNR) and Credit Limit (KLIMK) fields.
Picture
​I then use the Alteryx Join tool to combine the output from both tables based on the Customer Number field (KUNNR). The reason for doing this is the same as with SFDC. The KNA1 table includes the Customer Number, Customer Name, Customer Address etc. The KNKK table has the Customer Number only. So if I want to see the Customer Name as well as the Customer Number along with the Credit Limit I need to combine the data from both tables.
Picture
​As with SFDC, the combined SAP output gives me something I can start to work with. 
Picture

Blending the data from Salesforce.com and SAP

Picture
Use the Alteryx Join tool to combine the SFDC data with the SAP data.
Picture
​In our systems the SFDC Account Id and SAP Customer Number are the same, so the join is made on the common fields. I’ve also renamed the SAP fields to align them with SFDC.
Picture

Apply a simple formula to the blended data from Salesforce.com and SAP

Picture
I’m now going to apply a simple formula to the combined SFDC – SAP output. The formula is going to write the value “GOOD” to a new Output Field, “Credit Limit Breach” if the SFDC Opportunity Value is greater than the SAP Credit Limit for the Customer. Otherwise, it will write the value, “DEAL VALUE EXCEEDS CREDIT LIMIT”.
Picture
Finally, I want to split the categorized data into 2 streams. One stream will capture the SFDC Opportunities where the SAP Credit Limit is greater than the value of the Opportunity. The second stream will capture the SFDC Opportunities where the SAP Credit Limit is less than the value of the Opportunity.

​For this, I’m going to use the Filters tool.
Picture
Picture

The Final Result – The least interesting part… 

​After running the workflow, I get the following final outputs.
Picture
Picture
While the scenario I've walked through is a simple one, I hope that it stimulates some ideas as to how you could use your Salesforce.com and SAP data within Alteryx.
GET A FREE TRIAL OF THE DVW ALTERYX CONNECTOR FOR SAP
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Categories

    All
    ACS
    ACS BusinessObjects
    ACS BW Write
    ACS Cloud
    ACS Metadata
    Alteryx
    Alteryx Gallery
    Alteryx Server
    Analytic Process Automation
    APA
    Audit
    BusinessObjects
    Consulting
    DVW Integration Platform
    DVW IP
    Inspire
    Jobs
    KCS
    KNIME
    Microsoft Azure
    Microsoft Power BI
    Office Of Finance
    Predictive Analytics
    Qlik
    Salesforce
    Salesforce Wave Analytics
    SAP BAPI Read Tool
    SAP BAPI Write Tool
    SAP BusinessObjects
    SAP Business Suite
    SAP BW
    SAP Data Migration
    SAP Document Tool
    SAP ECC
    SAP ERP
    SAP HANA
    SAP IDoc Tool
    SAP Query Tool
    SAP Read Tools
    SAP Report Tool
    SAP S/4HANA
    SAP Table Data Tool
    SAP Tables
    SAP Transaction Codes
    SAP Write Tools
    Services
    Tableau
    Tax
    TCS
    ThoughtSpot
    Top 10 Blog
    Training
    Webinar

    Archives

    December 2020
    November 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
    May 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 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

SERVICES

PROFESSIONAL SERVICES
TRAINING

DEMOS

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
​
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​​
​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP

PRICING

BLOG

ABOUT US

CONTACT US

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.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • 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 >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS