Background

CentreStack supports connecting to SharePoint Online document libraries via CentreStack Team Folders. In this way, SharePoint Online document libraries may be viewed in via the CentreStack drive letter, or in the CentreStack portal, alongside other CentreStack Team Folders.

Known Limitations

• CentreStack build 9.2.5126.40535 or later is required.
• SharePoint Online Document Libraries are per CentreStack tenant

Configuration

1. Login as the CentreStack cluster admin or tenant admin.
2. From the Dashboard click on the tenant that will be configured for SharePoint Online access.
3. Click on the CONTROL PANEL button at the right of the page.
4. Click on Storage Manager
5. Click Edit
6. Scroll down to Sharepoint Online and copy the text in the Callback URL Paste it into a text editor for now.
7. Sign into https://portal.azure.com as a global administrator for the Azure AD tenant.
8. In the left-most blade click Azure Active Directory:
   
9. In the next blade click App registrations:
   
   
10. In the next blade click New application registration:
    
    
    
11. In the Create blade use these settings:
    Name: AccessSharePointFromCentreStack
    Application type: Web app / API
    Sign-on URL: <the Callback URL from the CentreStack Storage Manager>
    
12. Click the Create button at the bottom of the Create blade.
13. In the App registrations blade, click on the AccessSharePointFromCentreStack app that was created.
14. Click the Settings button:
    
    
15. In the Settings blade click Required permissions:
    
16. In the Required permissions blade click the Add button:
    
17. Click Select an API in the Add API access blade.
    
18. Click on Office 365 SharePoint Online:
    
19. Click the Select button at the bottom of the Select an API blade.
20. In the Enable Access blade, click on the 5 check boxes under the DELEGATED PERMISSIONS section where REQUIRES ADMIN is displayed as No (in other words, permissions that do not require Admin consent):
    
21. Click the Select button at the bottom of the Enable Access blade.
22. Click the Done button at the bottom of the Add API access blade.
23. Close the Required permissions blade.
24. Back in the Settings blade click on Keys:
    
25. In the Keys blade under the Passwords section, type some text in the Description such as AppPassword or Secret (the value is arbitrary). The Expires option is a drop-down that allows you to configure how long until the password expires. Select an Expires value appropriate for the security requirements for your organization:
26. Click the Save button in the Keys The secret Value will be displayed. Copy the contents of the Value field to the clipboard. Paste it into a text editor for now because once this blade is closed the value won't be retrievable. Close the Keys blade.
27. Close the Settings blade.
28. In the Registered app blade, hover over the Application ID field and click the Click to copy button to copy this text to the clipboard. Paste this text in the text editor along with the secret. Both strings are required to make a programmatic connection to Azure AD. You may want to store these strings in LastPass or your password management system of choice.
29. You will need the Tenant Id (Directory Id) of your Azure AD tenant. In the Azure portal, navigate to Active Directory-->Properties. Click the copy to clipboard button next to the Directory ID text box. Paste this text into your text editor.
30. Login as the CentreStack cluster admin or tenant admin.
31. From the Dashboard click on the tenant that will be configured for SharePoint Online access.
32. Click on the CONTROL PANEL button at the right of the page.
33. Click on Storage Manager
34. Click Edit
    1. Scroll down to Sharepoint Online and click the option to enable it.
    2. In the Client ID field paste in the value from Azure AD's Application ID
    3. In the Client Secret field paste in the value from Azure AD's password Value field.
    4. In the Tenant Id, use the text corresponding to the Directory ID from the Azure portal.
       
    5. Click Apply at the upper right of the page to save the settings.
35. Click on TENANT DASHBOARD at the top of the page.
36. Click on Create Team Folder:
    
37. Click on Cloud Storage:
    
38. Click on Microsoft SharePoint Online:
    
39. In the Folder name field use a name like the SharePoint Online site name then click Next:
    
40. Paste the URL of the SharePoint Online site into the text box, then click on Get Authorization Code:
    
41. Click Accept:
    
42. Click Finish
43. Click Add Collaborator:
    
    
44. Add the appropriate users or groups, then click the Save icon:
    
    
45. The collaborators you added will have the new Team Folder in their CentreStack drive.