Utilize the BO connection in analysis for VBA

[Former Member]

Hello,

After the user download a workbook and enter in credential after refreshing, is there a way utilize that connection in vba?

In vba, I have created a connection that looks like:

StrSql = "driver=HDBODBC32;servernode=10.###.###.30:30015;DATABASE=Z_PTP_HANA_SCH;uid=xxxxx;pwd=xxxxx;"

   CONN.Open StrSql

I want to be able to accomplsh this connection without including the username and password by using the connection info the user established by logging in through BO

[Former Member]

Hi Wayne,

As far as I know this is not possible, but I do think it would be great if SAP could extend the API to support this.

Something for idea's place?