topic Creating a SQL connection without access in Connectivity & Data Prep

Creating a SQL connection without access

sebacascardo — Wed, 05 Sep 2018 18:57:08 GMT

Hi,

I need to create a SQL connection but there's one big issue: on my computer I don't have access to the database and therefore I can't create the connection.

I was able to do it in QlikView because you don't have to create a data connection like in Sense, you just write the SQL query and that's it........but in QlikSense I'm not sure if I can do the same thing somehow.

Any thoughts? Please let me know if you don't understand my issue.

Re: Creating a SQL connection without access

swuehl — Wed, 05 Sep 2018 19:31:31 GMT

You should be able to write the statement in editor just like in QV, but you won't be able to execute, just like in QV.

Re: Creating a SQL connection without access

sebacascardo — Wed, 05 Sep 2018 20:26:16 GMT

I can write the connect statement but when I get to the part where I have to write SQL SELECT it makes the SQL word red like if there's an error there.

The syntax I used in QlikView is something like this:

OLEDB CONNECT TO [XXX];

LOAD

FieldA;

SQL SELECT

FieldA

FROM XXX

Re: Creating a SQL connection without access

vunguyenq89 — Wed, 05 Sep 2018 20:31:27 GMT

Don't use Data Manager, use Data Load Editor instead. You should be able to write the SQL query without having to create a connection beforehand.

Re: Creating a SQL connection without access

sebacascardo — Wed, 05 Sep 2018 20:55:39 GMT

I'm using the data load editor but I'm having issues with the SQL Select part, as I stated above

Re: Creating a SQL connection without access

vunguyenq89 — Thu, 06 Sep 2018 06:29:30 GMT

SQL keyword seems to be highlighted correctly in Qlik Sense June 2018 even without any CONNECT statement. Maybe a script editor bug in your QS version?