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

Introducing the De Villiers Walton SAP Metadata Connector for Alteryx Connect

3/6/2018

0 Comments

 
Picture
The ​SAP Metadata Connector for Alteryx Connect extracts metadata from SAP and loads it into Alteryx Connect. The SAP Connector for Alteryx Connect works with:
  • SAP BW
  • SAP Business Suite (i.e. SAP ECC, SAP CRM, SCM etc.) and SAP S/4HANA On-Premise edition
In this blog we will focus on SAP BW and show you how to:
  1. Load SAP BW metadata into Alteryx Connect
  2. Explore SAP BW metadata in Alteryx Connect

1. Load SAP BW metadata into Alteryx Connect

Step 1 - Select the SAP Logon Tool

  • Drag the SAP Logon Tool for the SAP Metadata Connector for Alteryx Connect onto the Alteryx Workflow canvas.
Picture

Step 2 - Configure the SAP Logon Tool

  • Click on the Parameters tab of the SAP Logon Tool
  • Click Add in the System Selection grid
  • Select the Alteryx Connect system from the drop down list
  • Repeat the step to select the SAP system you want to extract metadata from
Picture
  • Enter your User Name and Password for each selected system
  • Click Ping Servers to verify that connectivity to the systems has been established.
Picture

Step 3 - Select the SAP BW Connect Tool

  • Drag the SAP BW Connect Tool onto the Alteryx Workflow canvas.
  • Connect the SAP BW Connect Tool to the SAP Logon Tool. 
Picture

Step 4 - Configure the SAP BW Connect Tool

  • Select the Alteryx Connect server from the Server Name drop-down list.
Picture

Step 5 - Add Browse Tools to the SAP BW Connect Tool (Optional)

  • To see details of the metadata extracted from SAP BW and loaded into Alteryx Connect, add a Browse Tool to each of the SAP BW Connect Tool out ports.
Picture

Step 6 - Execute the extract and load into Alteryx Connect

  • To execute the extract and load of SAP BW metadata into Alteryx Connect, click the Alteryx Run Workflow button
Picture

Step 7 - Review the extract output (Optional)

Picture

2. Explore SAP BW metadata in Alteryx Connect

Step 1 - Logon to Alteryx Connect

Picture

Step 2 - Review Data Sources

  • Select Data Sources from the Alteryx Connect Homepage.
Picture

Step 3 - Select SAP Systems

  • Select SAP Systems from the Data Sources page.
Picture

Step 4 - Select SAP BW System

  • Select the SAP BW system that was previously loaded into Alteryx  Connect with metadata
Picture

Step 5 - Review SAP System details

  • The technical SAP system details are displayed including the SAP Server, SAP Client etc.
Picture
  • SAP BW InfoProvider data is displayed.
Picture
  • SAP BW Query data is displayed.
Picture
  • SAP BW View data is displayed.
Picture
  • SAP BW InfoObject data is displayed.
Picture

Step 6 - Search for a SAP BW Query

  • Click on the Magnifying Glass to activate the search function.
  • Enter the search criteria.
  • Click, OK to execute the search.
Picture
  • Click on the desired SAP BW Query to select it.
Picture

Step 7 - Review the selected SAP BW Query

  • Details of the selected SAP BW Query are displayed including Associated Objects (in this example the SAP BW InfoProvider that the SAP BW Query is based on).
Picture
  • Query Details are displayed including Y-Axis, X-Axis​...
Picture
  • ... and Free Characteristics
Picture

Step 8 - Select a SAP BW Query InfoObject

  • In this example, we will drill into the X-Axis InfoObject
Picture

Step 9 - Review details of the selected InfoObject

Picture

Step 10 - Explore a Relationship

  • Select a Relationship 
Picture

Step 11 - Review details of the selected Relationship

Picture

GET A FREE TRIAL OF THE SAP METADATA CONNECTOR FOR ALTERYX CONNECT
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