How to load data from sharepoint which needs authentication?

[qlikviewforum]

Hi All

How to load data from sharepoint which needs authentication?

Thanks,

Qlikview Forum

[shelvinpatel]

As far as I know, you can't pass any user credential to fetch data from SharePoint to Qlikview unless you develop a custom connector.  Same applied to any internet files unless authentication is embeded in the url itself.  I am using a third party tool which allows me enter credential which dumps the SharePoint list into a SQL database.  And my QV apps connects to SQL database via ODBC or OLE DB connection.  Direct SQL connection to SharePoint is not recommended by MS.

Thanks, Shelvin

[qlikviewforum]

Hi Shelvin

Thanks for your reply! Could you please let me know how to develop the custom connetor to fetch the data from sharepoint which needs authentication. I cannot use the thirdaparty for the same so please help me out for the same.

Thanks,

qlikviewforum

[shelvinpatel]

I don't have particular skill to develop a custom connector but I did play around with Qlikview API and read some bolg about QV custom connectors.  From those, my understanding is that this could be possible.  I might one day sit down with friend of my who is a developer and we might nail it but as of now, I can't help you much.

Thanks, Shelvin

[chematos]

I was trying to read a lista of sharepoint from QlikView and first I had to open the login page of Sharepoint from QlikView using like a browser

1.- File -> Open URL (sharepoint home)

2.- Login your sharepoint

Now you are connected to sharepoint so you must be able to get data.

You could follow the document to get lists for example

http://community.qlik.com/docs/DOC-1308

hope this helps

[qlikviewforum]

Thanks! But I have already with what given in the link but couldn't find the solution.

Major problem problem here is to login to sharepoint through qlikview. Loading data from sharepoint is not an issue but issue loading the data from sharepoint which needs authentication.

[qlikviewforum]

Thanks Shelvin, I will try to google and see on how to develop the custom connector. In the meantime if you get a chance to sit with your friend and develop the same then please share it with me. I will keep you updated about my progress in this post.

[qlikviewforum]

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

[qlikviewforum]

Hi Shelvin

Did you find time to develop the custom connector with the help of your friend? If not could you please try to develop the same in your convenient time. As I still I couldn't manage to fetch the data from the sharepoint. It's been more than a month since I am looking for the solution.

Thanks,

qvforum

[#10]

Hi,

Did you manage to solve this issue? I'm also trying to get data from a sharepoint that requires autentication.

Thanks in advance.