Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to setup Qlikview to import data that is within an Excel Sheet stored in Sharepoint? I am not looking for a difficult solution. Rather, I am trying to find out if this is easily done like it is with other common data sources.
Thanks!
hello Steve ,
thanks for ur reply but i ma really confused can u please explain me that what exactly we need to fetch data from share point.
is there any QV source or any other set up is required for it...
what exactly it is????
Hi Rajni, The solution I put in was on a client site, and I'm afraid I don't have access to a SharePoint server to revist this at this time. I seem to recall that when the SharePoint server was configured in the right way QlikView could see the spreadsheet exactly as if it was on a regular network share. If the correct permissions were granted then no pop-up would appear asking for credentials. From when I was reading up at the time I recall the version of SharePoint made a difference, as did the platform (64 or 32 bit) it was installed on.
Sorry I can't be of more help at this time. I'm sure someone else will be able to offer a solution though.
- Steve
Rajni,
The problem is that it is not possible to config QlikView to pass the user/pwd to authenticate in Sharepoint. QlikView will use the credentials of the user doing the reload.
You should config the Sharepoint site allowing your user (the user you are logged on your machine in case you're reloading from QV Desktop OR the user configured in the QlikView Server's services if you're reloading through a task in QV Server) to access the XLS file without inputting user/pwd.
(I think that this is what Steve suggested, but in other words... )
Hope this helps you
Fernando
Hi All
The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.
Created the new thread for the same below.
http://community.qlik.com/message/249859#249859
Thanks,
qlikview forum
Hi All,
I tried my level best but unfortunately couldn't able to succeed yet.
I read some where about QVSource. Is it possible to load the data from secured sharepoint site using the same? Any help please?
Thanks,
qlikviewforum
You should be able to load data from Sharepoint 2010 if it's on the same network (as opposed to an internet hosted instance).
We have some notes here:
http://www.qvsource.com/wiki/Sharepoint-Connector-For-QlikView.ashx
Did you try it already?
Hi Chris
Thanks for your reply! The link which you have attached is no more working.
Thanks,
qlikviewforum
The link is now: Sharepoint Connector For QlikView - QVSource: The QlikView & Qlik Sense API Connector (Docs)
However, it does not have anything to do with Excel files. It is related to Sharepoint lists.