For anyone interested, I have received a reply from SAP support.
It is not possible to connect Sap Analytics Cloud(SAC) to a HANA Database running on the SAP Cloud foundry environment.
Maybe sometime in the future. It was on the SAP road map for Q1 this year but never happened and it seems it’s no longer in the planning.
No issue if your HANA DB is running on the NEO cloud environment.
Colm.
Colmboc (BOB member since 2017-05-10)