HOW TO CONNECT SAP DATASPHERE TO ALTERYX VIA ODBC/JDBC OR REST API

Question

I need the steps and logic on how we can connect SAP DataSphere to Alteryx by any means, whether rest API, ODBC/JDBC, or ODATA. I have gone through this documentation on how we can connect SAP Data Sphere to Power BI, but I am not able to figure out how we can connect the same using Alteryx using the Download tool.

Also, I will give a summary of what we are doing. We are replicating tables present in SAP HANA to Datasphere via ABAP and creating a replication flow in the Datasphere. Once the table arrives in Datasphere, it will need to be pulled by Alteryx.

I would need to know how to achieve this, or any input to start from.

Note: I know there is a direct connector in Alteryx to connect to HANA, but the owner of the system is not allowing it as the system is going through a very high number of transactions and direct connect will impact the regular company operations.

apathetichell · Answer

Everything in those instructions makes sense for Alteryx except this:

* In Redirect URI field we can set the PowerBI standard: https://oauth.powerbi.com/views/oauthredirect.html

Alteryx is onprem. PowerBI in this case is getting the redirect via a website.

3 options:

1) You can try to set this up with a local redirect (127.0.0.1) -- no idea if it works.

2) You can also host a redirect url (cloud function)  to capture the code and throw in a cloud secret --- and retrieve that secret at runtime. (I would do this via AWS Lambda/Cloud Run Functions and Python) ---  your infosec may not be happy with that.

3) you can manually get the code every 30 days and update the workflow with it.

I'd recommend hiring an Alteryx consultant here. Preferably one who knows what they are doing and won't just come back to Community and ask. Everything else in the S4/PowerBI connection is pretty straight-forward to create in Alteryx.