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

How to load data from sharepoint which needs authentication?

qlikviewforum — Mon, 20 Aug 2012 13:16:56 GMT

Hi All

How to load data from sharepoint which needs authentication?

Thanks,

Qlikview Forum

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

shelvinpatel — Mon, 20 Aug 2012 16:18:59 GMT

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

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

qlikviewforum — Wed, 29 Aug 2012 12:50:08 GMT

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

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

shelvinpatel — Wed, 29 Aug 2012 13:02:05 GMT

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

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

chematos — Wed, 29 Aug 2012 15:47:17 GMT

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

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

qlikviewforum — Wed, 29 Aug 2012 16:04:03 GMT

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.

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

qlikviewforum — Wed, 29 Aug 2012 16:11:04 GMT

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.

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

qlikviewforum — Fri, 31 Aug 2012 12:12:32 GMT

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

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

qlikviewforum — Wed, 10 Oct 2012 10:09:26 GMT

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

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

Thu, 17 Jan 2013 11:32:36 GMT

Hi,

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

Thanks in advance.

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

qlikviewforum — Wed, 30 Jan 2013 11:53:46 GMT

Hi,

No luck to get any solution on this. Keep me update about your progress on this!

Thanks,

qvforum

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

Wed, 10 Apr 2013 08:56:57 GMT

Hi,

I have similar requirement across my organisation.

As I understand, Qlikview uses the IE authentication model - so if you can access your SharePoint site without a sign-on then you can also get list data from a script using owssvr method.

Assuming you are using AD authentication to the SharePoint server.

If your PC is on the same domain as that used for SharePoint authentication, just add your SharePoint site to the "Local Intranet" zone in IE.

If your PC is not in the same domain, you will also need to authenticate and make sure you check the 'remember password'. This will store your credentials in the windows Credentials Manager.

hope this helps.

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

Wed, 29 May 2013 12:57:59 GMT

Hi All,

we have a similar issue, that is when we try to access a web xml file through the File Wizard (xml type).

it returns "access denied" in the prod environment while we correctly see the xml data in the test environment.

we already set the source web site as "trusted" in IE for both the environments

which other check can we do to solve the issue?

Many thanks.

Francesco

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

gizzel123 — Fri, 10 Oct 2014 10:58:10 GMT

Hi,

I am also trying to do the same.

It works when I open the sharepoint using qlikview as a browser, by :

FILE<OPEN URL.

is there any way to do it??

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

Fri, 10 Oct 2014 11:09:57 GMT

Reading Data from Sharepoint lists into QlikView

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

Mon, 10 Aug 2015 13:03:07 GMT

Hello.

You can use an external command like curl to download the file:

curl.exe https://mysharepointserver/site/page/file123.csv -k -u user:pass >> C:\TempFolder\downloaded_file123.cvs

Regards.

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

rimantasendriuk — Sat, 29 Feb 2020 14:45:39 GMT

Not sure what specifically you mean by "needs authentication", but... I hope you mean your SharePoint requires username/password, and your QlikView document reload script needs to provide them, because reload is done by some process which does not have SharePoint access (over SSO, for example).

You can simply add username/password to the URL (as defined in URL protocol syntax specification):

LOAD ...

FROM [http://username:password@share_pont_server/site_name/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={...}]