Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Oracle SQL Developer Connection

Hi,

I need to setup sql connection to qlikview, I have oracle sql developer on my system. I have been told that I don't have Oracle plugin to make the connection. Can anybody please guide me of a way to do that? I have added the screenshot of the OLE DB Connect,

Also I have made an odbc connection and I am trying to run the following query but I keep getting an error "ODBC read failed" I am guessing it's the syntax. Can anybody please correct the query?

ODBC CONNECT TO [alpcisdd.corporate.com;DBQ=GSCMDMD] (XUserId is bZBOSGRINaXGVKBKMSUeFJdJcB, XPassword is MQMTCTWJdAWF);

GSL:

LOAD *;

SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6';

Thanks

9 Replies
petter
Partner - Champion III
Partner - Champion III

It looks like your Oracle SQL has a lonely quotation mark:

SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6';

Shouldn't i be without the '  

Or a beginning quote after the equal sign?

buzzy996
Master II
Master II

1. I have been told that I don't have Oracle plugin to make the connection. Can anybody please guide me of a way to do that?--ask admin team to help on this,they suppose to download and install.

U have to create ODBC connection from SYSTEM TAB not on USER TAB,hope tht's creating this issue and make sure abt ur machine is either 32/64 bit,accordingly u have to select ur drivers!

Anonymous
Not applicable
Author

ODBC read failed

SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6

Hi Petter, I tried without that too, didnt work

jonathandienst
Partner - Champion III
Partner - Champion III

Not sure if this is the problem, but you have mixed the case of the S & L table aliases:

SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE S.GSL6=L.GSL6

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Still didn't work Jonathan, good observation though

ODBC read failed

SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE S.GSL6=L.GSL6

petter
Partner - Champion III
Partner - Champion III

This is the driver you need most probably:

64-bit Oracle ODBC Driver 12.1.0.2.0

If you Google this:

    oracle odac odbc 64-bit

You will come to Oracle Technology Network where you will find several different release of packages ~300 MB download containing the ODBC driver. To be able to do the download you will have to register there - but that is for

free.

buzzy996
Master II
Master II

are u tried the above suggested solution by me?

petter
Partner - Champion III
Partner - Champion III

If you want to make sure that you are connected to Oracle you could just write this SQL and see if you get a result:

select sysdate from dual;

This should work on any Oracle database that you connect to since it only returns the sysdate (a function call) and referencing a dummy table called DUAL...

Anonymous
Not applicable
Author

I am using Oracle 11.02.00.01, Oracle in OraClient11g_home1