Download - QVSource Brain Dump
![Page 1: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/1.jpg)
BRAIN DUMP
A PRODUCT FROM
INDUSTRIAL CODEBOX
Q L I K T E C H N O LO GY PA R T N E R O F T H E Y E A R 2 0 1 4
The QVSource
![Page 2: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/2.jpg)
Before We Start: You can get a free trial of QVSource at www.qvsource.com and try out everything which follows.
![Page 3: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/3.jpg)
QVSOURCE - THE QLIKVIEW API CONNECTOR
![Page 4: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/4.jpg)
Over 50 Five Star reviews on QlikMarketBy far the highest rated product (at
time of writing)
![Page 5: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/5.jpg)
QVSource is delivered as a simple zipped folder.
There’s nothing to install or register so it’s easy to get on (and off) your system.
All you need is a Windows OS with .NET 4.0 (full edition) installed.
![Page 6: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/6.jpg)
We recommend extracting to c:\QVSource.
Then you just need to run QVSource.exe.
![Page 7: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/7.jpg)
There is also a Windows Service version.
For running QVSource alongside QlikView Server/Publisher.
(See the BatchFiles directory for a script to install and uninstall the service).
![Page 8: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/8.jpg)
Full setup instructions can be found on our extensive documentation wiki.
wiki.qvsource.com
![Page 9: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/9.jpg)
The main QVSource window shows a list of available connectors.
![Page 10: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/10.jpg)
QVSource needs to be running wherever the QlikView reload is taking place.
When minimised you can see that it is still running and available, usually from http://localhost:5555/QVSource
(You can change the port number if necessary).
![Page 11: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/11.jpg)
You can also check QVSource is running using your browser.
![Page 12: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/12.jpg)
Here we can see there is no licence installed.
![Page 13: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/13.jpg)
You will receive a licence file from us and a name to enter when installing it.
![Page 14: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/14.jpg)
Once installed you can confirm the details and licensed connectors.
(Note that all beta connectors are free to use if you have a valid QVSource licence.)
![Page 15: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/15.jpg)
We can now also see that QVSource is licensed via the browser.
Note that:
“Is Licensed As Server” = true
This means that we can also set this up as a Windows Service.
![Page 16: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/16.jpg)
o Facebooko Fan Pages & Groups
o Facebook Insights
o Twitter
o YouTubeo Insights
o Data
o Mailbox (POP3/IMAP)
o Sentiment Analysis & Text Analytics (multiple APIs Supported)
o OData
o File Transfer (FTP & SFTP)
+ More!See www.qvsource.com/Connectors-For-QlikView/All for Full List
o Googleo AdSense/AdWords
o Analytics
o Double Click For Publishers (DFP)
o Drive & Spreadsheets
o Prediction
o SugarCRM
o MailChimp
o MongoDB
o Blue Yonder
o Klout
o + General XML/JSON/SOAP API Connector
QVSource has 30+ Connectors, including:
![Page 17: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/17.jpg)
Let’s pick the Twitter Connector as an example.
To open it, you can double click it or press the ‘Configure’ button.
![Page 18: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/18.jpg)
The Connector Configuration screen has a number of key elements.
![Page 19: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/19.jpg)
A list of available tables.
![Page 20: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/20.jpg)
A description of the currently selected table.
![Page 21: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/21.jpg)
A set of input controls / parameters for the current table.
![Page 22: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/22.jpg)
A help page link for the connector.
![Page 23: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/23.jpg)
(Which takes you to the relevant page on our wiki.)
![Page 24: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/24.jpg)
An area to preview the table’s data.
![Page 25: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/25.jpg)
…and grab the QlikView load script to paste into your application.
An area to preview the table’s data.
![Page 26: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/26.jpg)
Many Connectors will require authentication.
For the Twitter Connector, we will be redirected to Twitter’s website…
![Page 27: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/27.jpg)
Where you will authorise the Connector.
![Page 28: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/28.jpg)
And receive an access token in return.
![Page 29: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/29.jpg)
And receive an access token in return.
We can now start getting some data!
![Page 30: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/30.jpg)
Let’s search for Tweets containing the word ‘qvsource’.
![Page 31: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/31.jpg)
And specify that we are only interested in Tweets in English.
![Page 32: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/32.jpg)
Once we have configured our inputs we can run the table.
![Page 33: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/33.jpg)
And then check the data returned.
Before moving to the “QlikView Load Script” tab...
![Page 34: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/34.jpg)
To preview the auto generated QlikView load script.
![Page 35: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/35.jpg)
Let’s copy the generated QlikView load script.
![Page 36: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/36.jpg)
And paste it into a new QlikView application.
![Page 37: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/37.jpg)
We can now simply reload our QlikView application.
![Page 38: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/38.jpg)
And we will have our first QVSource enabled data model!
![Page 39: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/39.jpg)
Note: If you ever receive a “Script Error” during a QVSource related reload.
![Page 40: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/40.jpg)
The first step is always to copy the request URL (between the [ ] after the FROM statement).
![Page 41: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/41.jpg)
And paste it into a browser’s address bar where you should receive more detailed information.
Often the reason is simply that there is no valid QVSource licence installed or the connector has not been authenticated with.
![Page 42: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/42.jpg)
Back to our auto generated load script…
![Page 43: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/43.jpg)
Notice that the connector automatically includes script to convert some fields to native QlikView date and times.
![Page 44: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/44.jpg)
Notice also that the QlikView load statement is requesting the data from QVSource’s mini web server running on the local machine.
![Page 45: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/45.jpg)
Here we can also see: The name of the Connector.
![Page 46: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/46.jpg)
The name of the table we selected.
![Page 47: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/47.jpg)
But most importantly, the input parameters for the table.
![Page 48: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/48.jpg)
This means that we can split these out into variables, and no longer need to use the QVSource UI to configure new searches.
![Page 49: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/49.jpg)
This means that we can split these out into variables, and no longer need to use the QVSource UI to configure new searches.
(We just need to ensure that QVSource is running when the reload takes place.)
![Page 50: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/50.jpg)
Let’s make this a little more sophisticated…
![Page 51: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/51.jpg)
First we define a table containing a list of search terms we would like results for.
![Page 52: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/52.jpg)
Then we loop through each row in the TwitterSearchTerms table, running the search for each…
![Page 53: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/53.jpg)
Then we loop through each row in the TwitterSearchTerms table, running the search for each…
Note: There is an even more concise way of writing this script using QVSource’s Sync/Async/Batch feature but this is a slightly more advanced topic.
![Page 54: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/54.jpg)
After reloading this, we now have more enhanced QVSource enabled QlikView application.
![Page 55: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/55.jpg)
We have a number of free QlikView “Starter Apps” available over on our GitHub page:
github.com/qvsource
(BTW - You don’t need a GitHub account – just look for the “Download ZIP” button:
)
![Page 56: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/56.jpg)
With more advanced load scripts and UIs.
![Page 57: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/57.jpg)
You should now know 80% of what you will need to start using QVSource effectively with QlikView.
![Page 58: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/58.jpg)
QVSource pricing depends on a number of factors - you may either request a quote directly via our website.
![Page 60: QVSource Brain Dump](https://reader035.vdocuments.us/reader035/viewer/2022081414/54c8c3ac4a79590a5e8b45f5/html5/thumbnails/60.jpg)
Don’t Forget that you can download a fully functional trial version from www.qvsource.com
You can also find further documentation on installing/upgrading QVSource, working with connectors, server configuration etc. at:
wiki.qvsource.com
You can also follow us on:
Our Blog: blog.qvsource.com
Twitter: @qvsource
Facebook: www.facebook.com/qvsource
Any questions –> [email protected].
Thanks for checking out QVSource.