I am new in my company, my manager ask me about the possibility of displaying attendance data for each employee in SharePoint online!

  • How can show data from the SAP system in SharePoint online?

  • Is SharePoint online suitable for intranet?

2 Answers 2


This post deals with a similar type of question. At work, we have SP 2013, but we import 'external data' from other systems - like you wish to do with SAP. In SP 2013 there is a List type called 'External List'.

These are only high-level steps, you'll need to work out the details.

  • Create External List (let's call it SAP List).
  • The SAP List has limited functionality, so we need to convert it to a Sharepoint List.
  • Create a 'Native' (normal) Sharepoint List.
  • Create 'look-up' fields in your SP List pointing towards the SAP list, this will enable you to 'pull' data over. You can further customise the Sharepoint List and set up views etc.

What you will still need to do is create a mechanism to keep your SAP list refreshed with new/modified data from your SAP system. Possibly Windows Task Manager and PowerShell could do this. Possibly a Sharepoint Designer Workflow could then be configured on your SAP List; when an item is created/modified on the SAP List -> run workflow to create/modify items in your native SP List.

This is the only method I know about, others will hopefully have other suggestions for you too!

  • Thank you, this solution for SharePoint on-prem not online!
    – Arul kumar
    Jan 27, 2018 at 12:47

I agree with the answer Tally provided as the solution, however it would seem that in your case simply purchasing an SAP integration system from a third party provider may be the preferred option

  • Thank you, this solution for SharePoint on-prem not online!
    – Arul kumar
    Jan 27, 2018 at 12:48
  • I fail to see how either of the provided answers would fail to suit your needs regardless of the environment: layer2solutions.com/solutions/…
    – J. Doe
    Jan 29, 2018 at 8:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.