sso login from excel file to sap system

[HariPanakkal]

Hello,

Does anyone here knows if it is possible to logon to a backend server automatically without the need to prompt user for the login and pwd ? This is based on the assumption that SSO (or some kind of digital certificate) is used for logging on. I will like to acheieve the above using Excel file.

Thanks,

hari

[Former Member]

Hey,

first of all,

you should enable the SSO option in the SAP server (basis team)

After you successed to login with the SAP GUI with SSO,

you should configure the excel to login to the sap server.

notice that excel can login to the sap server,

only if a sap-gui client is installed on the computer

(the excel uses the SAP-GUI dlls in order to login to the SAP system).