topic Re: Text mining with QlikView in QlikView

Text mining with QlikView

Sat, 18 Jul 2015 17:24:04 GMT

Hello everyone,

Actually, I am intending to connect QlikView to an Opensource that connects with social networks for text mining. So, I am trying to find an Opensource that connects at the same time to QlikView and to social networks. Please is there any suggestions?!

I do really need your help to resolve the problem of connection QlikView and social networks for text mining

Thank you !

Re: Text mining with QlikView

swuehl — Sat, 18 Jul 2015 19:36:40 GMT

You can look into QVSource to connect to social media:

QVSource - The QlikView & Qlik Sense API Connector (Home)

Re: Text mining with QlikView

Sun, 19 Jul 2015 09:17:10 GMT

Hello !

Actually, I have to purchase the Qvsource and I can't make for the moment. I have to look for an other alternative in order to carry out the text mining !

Thank you

Re: Text mining with QlikView

Levi_Turner — Mon, 20 Jul 2015 18:11:13 GMT

Unless those services have relatively open APIs, so you can pull in the data in JSON or somesuch and format in QlikView, ODBC/OLE DB access, then you're not going to be able to connect to social networks for data mining purposes, at least directly.

QV Source listed above is one option, and certainly easier than scripting your own Python or Ruby scraper to connect to their APIs and output the results into a text file for analysis.

Re: Text mining with QlikView

Tue, 21 Jul 2015 08:55:19 GMT

Hello Levi,

Do you have any idea how to integrate Python with QlikView? I have tried so with R and I have faced problems of Licence.

Lot of thanks !

Re: Text mining with QlikView

Levi_Turner — Tue, 21 Jul 2015 12:17:05 GMT

It wouldn't be an integration per se. You'd use a python script to scrape the data from Twitter (e.g. computermacgyver/twitter-python · GitHub) or where-ever to form the data you pull into QlikView. Most if not all social media sites worth scraping have APIs but require tokens or secret keys which do not interact well with QlikView.