It's second time i hear that there is question about loading data from sharepoint... I'm wondering if it's possible.
But as far as i know - is sharepoint is complex of software for frontend sites developing? And IT uses data from some other sources. Like sql server. So why not to take this data directly from this sources?
You can pull the data from SharePoint. The caveat would be, you can pull the data from the files stored in Qliksense. Any files supported by QS can be stored in SharePoint. Thus they can act as source.
You would require Qlik Connector. The beta version of connectors can connect to the QS and load the data from there.
This is the solution for first half of your question.
You would like to show historical data. Refresh date in the right step in this process.
You can use Incremental load. This process loads the new data and keeps the old ones intact.
You can read more here.
Please let me know of any issues.
Please mark the answer helpful/correct in case you find it useful.
Thanks and regards,
Hi , thanks for your response.
Basically I have created connection to share point , and I know how to do the incremental load.
But I want to do this in the automatic way, I do not want to do any manual work , because I have tooo many tables, and if I update the tables every week, that will be a lot of work.
Not sure if I can do the automatic tasks by using QMC?
You can create a connection to List with this:
This is another way of pulling data.
I couldn't find any solution for SharePoint Qlik connector. I will look for it and update you.