topic Re: SAP HANA Connection in Alteryx Connect Discussions

SAP HANA Connection

jscruz — Thu, 13 Apr 2023 03:29:44 GMT

Hi, Alteryx Community.

I have successfully connected to the SAP Hana using the input tool. But when I'm trying to Choose Table or Specific Query, there's no table showing in my Visual Query Builder. What would be the possible cause for this?

Thank you,

JKSC

Re: SAP HANA Connection

LisaL — Fri, 14 Apr 2023 17:05:43 GMT

@jscruz I'm not sure, but I know that certain database types take a very long time to populate in the Visual Query Builder. SAP Hana might be one of them. If you use the Tables tab (and check the box to make that the default) you can probably specifya workaround the desired table from that list.

Re: SAP HANA Connection

jscruz — Tue, 18 Apr 2023 04:04:17 GMT

There are still no tables showing if I go in the "Tables" tab.

Is the HDODBC driver might be the issue here? The HDODBC driver version that I'm using is 2.15.22.

Thank you,

JKSC

Re: SAP HANA Connection

LisaL — Tue, 18 Apr 2023 20:35:11 GMT

@jscruz
If you have refreshed that tab and you don't see anything, then I don't know. When you set up your DSN, was the test successful?
I don't know that particular driver. The Data Sources page provides links to SAP to obtain the driver. My ODBC Administrator looks like this:

I don't know whether HDBODBC is the same as HDODBC (or maybe one is a typo?)
Perhaps someone else will be of more help than I. I wish you good luck.

Re: SAP HANA Connection

jscruz — Wed, 19 Apr 2023 02:45:11 GMT

Yes, the test connection was successful. However, the Tables are not showing when I am trying to browse it in the Tables or Visual Query Builder.

Yes, I'm also running HDBODC, sorry it was a typo.

Thank you,

JKSC

Re: SAP HANA Connection

IAJ1966 — Tue, 19 Dec 2023 09:58:14 GMT

@jscruz - As you're connecting to an SAP system, the easiest way to get to the data you need is via the add-in software from DVW Analytics.

We connect to pretty much any object in a SAP HANA system via the application layer from directly within Designer, which makes it safe and easy to use.

Try it for free using the link below. Let me know when/if you register and I'll be sure to get you assistance from our support team on your specific use cases.

https://www.dvwanalytics.com/free-trial.html

Best Regards

Ian

Re: SAP HANA Connection

Simon_Theobald_SW — Tue, 30 Jan 2024 11:48:59 GMT

There is also Xtract for Alteryx which is an Alteryx plugin that allows you to extract SAP data from various systems using many different options (ERP Tables, BW queries, ERP reports, ODP, and many more). It's easy to use and has a free trial available at https://theobald-software.com/en/xtract-for-alteryx For any questions, feel free to reach out to your Alteryx account team (it's the only SAP connector that can be bought directly from Alteryx thanks to a close partnership).