topic qlik Sense personal edition in App Development

qlik Sense personal edition

gidon500 — Thu, 28 Jan 2016 18:41:15 GMT

I am not able to use the standard OLE DB that I use in

my QlikView script .

is it possible to use it in personal edition of the sense

thanks

gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 04:41:19 GMT

You can create a connection to a db e.g. SQLServer via OLEDB , just get into the Data Load editor and use create connection , select OLEDB and specify the type of connector.

Re: qlik Sense personal edition

gidon500 — Fri, 29 Jan 2016 06:12:13 GMT

Hi Paul

Tried that and got this error

The following error occurred:

CONNECTs other than LIB CONNECT are not available in this script mode

Paul I am using the personal edition just downloaded and tried

I use same command I have in my QlikView docs which work great

gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 06:18:58 GMT

Hi David,

I'm not sure what is happening to your setup.

You should be able to create a connection happily as per below. Did you have any success with actually

obtaining a connection, perhaps you can post a screen shot here.

Unless there is a problem with the install, you are running QS 2.1.1 I assume ?

Maybe de-install and re-install again, a long shot. I've not had connect issues at all.

Paul

Re: qlik Sense personal edition

gidon500 — Fri, 29 Jan 2016 06:40:25 GMT

Hi Paul

thanks for your rapid response

a new connection is working

I will try to re-install the sense and let you know

thanks

gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 06:42:07 GMT

Great

Re: qlik Sense personal edition

gidon500 — Fri, 29 Jan 2016 07:19:01 GMT

I have tried it does not work

gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 07:23:06 GMT

Ok I need to know more, step me through what you have done exactly and screen dump any errors you have had, also what is the config of the PC you are installing on.

Earlier you said "a new connection is working" so, at the risk of being confused, what is the series of events leading to the problem overall?

thanks

Paul

Re: qlik Sense personal edition

gidon500 — Fri, 29 Jan 2016 10:09:27 GMT

Ok Paul

I have a working qlikview doc , with OLEDB connect that works fine

I copied it to the sense , it does not work I get the error I sent an hour ago .

when I remove the OLEDB connect from the script . and define a new connection it works fine .

I have lots of QlikView docs with OLDDB connect statement that I want to use with sense .

this is my story

thanks

gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 10:14:52 GMT

Ok, you cannot use the connections for QlikView in QlikSense, they are different beasts as far as connection strings are concerned. As you say your new connection in QS works fine, I recommend you create new connections via the data loader. I understand you would like to preserve the QV objects, but alas you have some

re-work to do there.

Cheers

Paul

Re: qlik Sense personal edition

gidon500 — Fri, 29 Jan 2016 12:24:30 GMT

Hi Paul

thanks for your help and fast response

Gidon

Re: qlik Sense personal edition

paul_scotchford — Fri, 29 Jan 2016 20:32:55 GMT

You're welcome