Hana SDI Sharepoint site?

[jbungay]

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?

Cheers,

James

[jmalla]

Hi James,

Wondering if were able to get this working. I do see from the note that the ExcelAdapter and FileAdapter do not support SSL which is not good. We do not want to send the username and password for basic authentication over HTTP but according to the note, it looks like this is the only option.

For the User Token for the Excel folder Access, did you have to generate the access token and send this back? We are able to generate the access token through the https://accounts.accesscontrol.windows.net/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/tokens/OAuth/2 by passing the grant_type, client_id, client_secret and resource. We can use this token then to maneuver through the Sharepoint set through - https://ourcompany.sharepoint.com/sites/MyUser/_api/web/Activities

Thanks,

Jay

[jbungay]

Hi Jay,

Unfortunately I was not able to get this working. I'm currently looking at using the SFTPAdapterDatastore instead.

So you were actually able to get the Excel Folder Access working with the sharepoint site? If so I might revisit this using your approach.

Cheers,

James

[colm_boyle]

Hi Jay/James,

did you get this working? Also, James, did you manage to integrate the SFTP adapter, and if so how did it go?

Thanks,
Colm

[jmalla]

Hi colm.boyle - we built a custom solution. I just posted a blog about it - Integrating SAP HANA XSA with Microsoft Office 365 Sharepoint Excel using Microsoft Graph API and No.... We developed a custom NodeJS application to use the Microsoft Graph API to access Microsoft Office 365 Sharepoint excel data and saved this in the HANA database. We triggered this from the file adapter. Please do check my blog and also add feedback/comments. You can also reach me at jay.malla@licensedtocode.com. I worked with jim.havlicek and we came up with this approach.

Cheers,

Jay