topic Need To connect to cloud database using qlikview in QlikView

Need To connect to cloud database using qlikview

anjali0108 — Wed, 09 Mar 2016 07:45:41 GMT

Hi ,

We have to connect to a database that is stored in cloud. We have been asked to connect using Soap Web Services .We are also given some WSDL to connect to the same .

Can anyone suggest how can we establish connection with cloud database using qlikview?

Any suggestions will be of great help ..

Thanks in advance.

Re: Need To connect to cloud database using qlikview

Gysbert_Wassenaar — Wed, 09 Mar 2016 18:29:04 GMT

Perhaps you can use QVSource to create a connector. There's no standard connector to use soap web services as a data source.

Re: Need To connect to cloud database using qlikview

petter — Wed, 09 Mar 2016 22:43:59 GMT

If you prefer to do this without a third party connector you could:

1) Use cURL ... it is a command line tool that is open source, free and downloadable. It is called curl.exe on Windows.

This can be invoked from a load script by using:

EXECUTE c:\bin\curl.exe http : // some-soap-endpoint ..... ;

2) Use a VBScript function that uses Microsoft XMLHttpRequest to post a SOAP request.

Re: Need To connect to cloud database using qlikview

anjali0108 — Thu, 07 Apr 2016 09:07:59 GMT

Hi Peter,

Can you tell me what VBScript function should i use ? Please explain in detail as I have never tried this .

Thanks in advance.