Can Qlikview Data can be pulled through a web service call or any kind of automation.
Hi All not sure if there is possibility but it might be challenging. Everyday our qlikview application will export data into csv formats which are precalculated in the straight tables and then our Ecommerce team have written a java code which will parse the csv files and then put that data into DB2 which is a good thing . To give more detail on this process Qlikview exporting and Java code refresh is automated so no manual refresh is required.But here comes the problem , if by any chance if business people thought of adding a new column or any renaming of the fields then our ecommerce team has to change the code to fit to the change. What they(Ecommerce team) are requesting is if there is a way to connect qlikview through a webservice call then we can automate that process. Please let me know if i have given detail information on this. Any help on this will be greatly appreciated.
I can't quite work out what is changing - is it the source data columns that are changing or being added to and you need a dynamic load script for Qlikview?
Hi Flipside sorry for getting back to late. its the source data columns changing. the main thing i want here by SOAP webservice call can an external system pull data from Qlikview.
I'm not aware of the ability to pull data from Qlikview using a web service, but others may know if this is possible.
However if the source data columns are changing, wouldn't this break the Qlikview reload anyway? Even if you use a Select * command, the straight table calculations and csv export are probably going to fail. And then you need to tell Qlikview how to use the amended AND newly added columns in calculations if they are needed.
One possible solution could be to store the Qlikview load script commands in XML format so they can be exposed to a webservice and amended accordingly by your ecommerce team, then read the amended code in the QV load script. Rather than using a Straight Table object, you would have to create a table in script and this logic would also need to be in the XML. You then have a choice of storing the table data to txt (or csv) or qvd in the script, OR using a post reload macro to export to XML to expose the data that way.
you cannot really pull out data. But you could push. The first question then is if you want to push during the load process or related to a user activity (interaction).
In the load process you could export data to a file or you could insert data into a table (queue) record-wise thru a connection..
In the second case - the front end - you can build an extension object which could push the data a user has selected via XMLHttpRequest (XHR) to a server or web service.
