The ACS works with SAP systems independent of the underlying database regardless of whether SAP is running on HANA, Oracle, DB2, SQL etc.
The ACS can access data from SAP Business Suite applications (i.e. ECC, CRM, SCM, HCM etc.), SAP BW, SAP S/4HANA On-Premise and Private Cloud Editions. The ACS can also access data in SAP HANA CDS Views.
The use of SAP HANA CDS views becomes interesting if your entire SAP landscape is running on SAP HANA.
It does however require appropriate SAP HANA licensing and skilled IT resource to design, build and implement the views. Implementation is therefore likely to be both time consuming and expensive.
In addition to time and cost, there are some additional considerations when deciding whether or not to use SAP HANA CDS Views with Alteryx:
IT Governance and Security
Visualization Layer and SAP HANA Performance
But, I really want to use SAP HANA CDS Views
A number of our customers use Alteryx, the ACS and Tableau (and other visualization tools) for prototyping and discovery. It is fast and it is economical. Once the prototyped solution has been reviewed and signed-off it is then baked back into the SAP HANA platform and exposed as SAP HANA CDS Views which can then be consumed in Alteryx either via the ODBC connector or via the ACS. This is a cost-effective approach to agile development in the SAP HANA analytics space.
Try the Alteryx Connector for SAP
To request a free trial, please click the button below.