topic Qliksense desktop import from Alteryx Database (.yxdb)?? in Connectivity & Data Prep

Qliksense desktop import from Alteryx Database (.yxdb)??

Fri, 26 Sep 2014 17:20:55 GMT

Hi, does Qliksense support an import from Alteryx Database file (extension .yxdb)? And if so, how can it be done? Thanks!

Re: Qliksense desktop import from Alteryx Database (.yxdb)??

ToniKautto — Fri, 26 Sep 2014 18:34:17 GMT

I am not familiar with Alteryx Database, but ODBC or OLEDB are common way of accessing data base servers. Alternatively is to use a custom connector that pulls data from a system into QlikView

Looking at Qlik Market there appears to be some content related to Alteryx. Could this be what you are looking for?

Alteryx Survey Data Manipulation for QlikView

Re: Qliksense desktop import from Alteryx Database (.yxdb)??

Fri, 26 Sep 2014 19:24:28 GMT

Qlik does not support yxdb, but Alteryx 9.0 and greater does output to Qlik's QVX format via the output tool. You can check out some examples of Alteryx and Qlik integration by downloading the Visual Analytics Kit

Re: Qliksense desktop import from Alteryx Database (.yxdb)??

jaimeaguilar — Fri, 26 Sep 2014 21:32:06 GMT

According to their community and what I read, there is no ODBC for connecting to yxdb files. However, they have an output tool that will let you write data in plenty of formats (many of then can be accessed by QlikView):

downloads.alteryx.com/Alteryx8.6.2/WebHelp/DbFileOutput.htm

I think you will need to do this in Alteryx designer or any of their products

hope this helps

regards

Re: Qliksense desktop import from Alteryx Database (.yxdb)??

Tue, 30 Sep 2014 00:41:10 GMT

I opted to output the database as a .qvx file from Alteryx and was able to load it in Qliksense. Thanks Jaime!