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 TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • 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
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • 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 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

    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
    December 2016
    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 CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS

​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 SAP SUCCESSFACTORS
FREE TRIAL OF KNIME CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 SAP SUCCESSFACTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 SAP SUCCESSFACTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)


SNOWFLAKE CONNECTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)

FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • 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
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS