Good day colleagues,
I'm currently working on an SDI integration scenario using the excel adapter (Hana 2.0 SPS02) to connect to a Sharepoint site, but I can't seem to authenticate the connection.
When selecting "Sharepoint" as the File Source Type I'm required to provide the url and credentials - Domain\Username and Password........but for Sharepoint online its just username@domain. I've tried username@domain, domain\username, and other combinations but nothing seems to work. Just keep getting the following error:
"Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: SharePoint Server URL [https://domain.sharepoint.com/sites/Test1] or login credential is not correct"
Has anyone been able to get this adapter working with Sharepoint online?