使用VBA连接到SAP HANA数据库

问题描述：

我正在尝试使用vba从SAP HANA数据库中将数据提取到Excel中.我遇到了以下问题.

I am trying to fetch data into Excel from SAP HANA database using vba. I came across the below questions.

Do I need to install SAP HANA MDX Provider for this? If yes, please provide the link. I am unable to spot any.

连接到HANA DB的vba脚本应该是什么?

What would be the vba script that I should write to connect to HANA DB?

请帮助我.

谢谢.

答

由于Excel还具有其他连接到HANA的方法，因此尚未使用VBA完成此操作.希望这会有所帮助:

Haven't done this with VBA as Excel has other ways to connect to HANA. Hope this helps:

Using MDX: https://blogs.sap.com/2017/02/17/connecting-ms-excel-to-sap-hana-using-mdx/
Using OData: https://blogs.sap.com/2017/05/02/sap-hana-on-a-whim-a-bing-map-in-my-ms-excel-from-an-anonymous-odata-service/

干杯！