Need to connect to SAP Data Source

Hi All,

I need a small help regarding connectivity of SAP Data Source in Alteryx. How to connect SAP Data Source with alteryx. It will be of great help if some one guides me regarding it.

Alteryx designer has a In-Database connectivity module where it has options for connecting it with SAP data source.

When I tried to research for it I came to know that alteryx sap integration needs some thirdy party tools such as Xtract Universal and DVW for integrating sap with alteryx.

So can anyone give me a comparison and overview of what these third party tools can do different as opposed to alteryx designer Input data tool.

Also give me some reference links for it.

Thanks,

Karthik

Workflow

Developer

Developer Tools

Settings

Tips and Tricks

Custom Tools

Connectors

Common Use Cases

Best Practices

Database Connection

Documentation

Accepted answers

fmvizcaino

Hi @Karthik_7694 ,

The difference between both is actually the platform, the input data tool connects to SAP Hana while theobald or dwv connects to SAP BW.

Making it simple, Hana is the sucessor of the sap bw and alteryx can connect to it with no cost, while BW demands a homologated provider, which makes those tools not free.

You only need to find out which SAP platform your company have and use one or another.

https://tcblog.protiviti.com/2019/03/29/whats-your-sap-bi-strategy-bw-on-hana-bw-4hana-or-sap-hana-enterprise/#:~:text=Comparing%20BW%20on%20HANA%20and,power%20of%20the%20HANA%20database.

Best,

Fernando V.

T_Willins

HI @Karthik_7694

I'll also weigh in on this. In addition to what @fmvizcaino has mentioned, you will want to work with your internal SAP governance group. While Alteryx can connect to SAP Hana tables, I have found many companies do not allow this. DVW works by requesting/imbedding the user's SAP credentials into the workflow to ensure proper access to SAP data, so I have seen this implemented successfully. Cost is a consideration with DVW as it is an additional licensing fee.

All comments

fmvizcaino

Hi @Karthik_7694 ,

The difference between both is actually the platform, the input data tool connects to SAP Hana while theobald or dwv connects to SAP BW.

Making it simple, Hana is the sucessor of the sap bw and alteryx can connect to it with no cost, while BW demands a homologated provider, which makes those tools not free.

You only need to find out which SAP platform your company have and use one or another.

https://tcblog.protiviti.com/2019/03/29/whats-your-sap-bi-strategy-bw-on-hana-bw-4hana-or-sap-hana-enterprise/#:~:text=Comparing%20BW%20on%20HANA%20and,power%20of%20the%20HANA%20database.

Best,

Fernando V.

T_Willins

HI @Karthik_7694

darronwalton

Thanks @T_Willins .

Hi @Karthik_7694 this is Darron Walton from DVW Analytics. If you would like to test out your SAP use case, feel free to visit us at https://www.dvwanalytics.com/ to register for a trial.

darronwalton

@Yonge - The email address you registered with keeps bouncing.

Thanks,

Darron Walton

DVW Analytics

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703