Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikviewforum
Contributor II

How to load data from sharepoint which needs authentication?

Hi All

How to load data from sharepoint which needs authentication?

Thanks,

Qlikview Forum

Tags (2)
15 Replies
shelvinpatel
New Contributor III

Re: How to load data from sharepoint which needs authentication?

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
Contributor II

Re: How to load data from sharepoint which needs authentication?

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
New Contributor III

Re: How to load data from sharepoint which needs authentication?

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
Valued Contributor II

Re: How to load data from sharepoint which needs authentication?

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
Contributor II

Re: How to load data from sharepoint which needs authentication?

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
Contributor II

Re: How to load data from sharepoint which needs authentication?

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
Contributor II

Re: How to load data from sharepoint which needs authentication?

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
Contributor II

Re: How to load data from sharepoint which needs authentication?

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

Not applicable

Re: How to load data from sharepoint which needs authentication?

Hi,

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

Thanks in advance.

Community Browser