topic Re: Oracle SQL Developer Connection in QlikView

Oracle SQL Developer Connection

Anonymous — Wed, 13 May 2015 11:30:16 GMT

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

Re: Oracle SQL Developer Connection

petter — Wed, 13 May 2015 11:40:08 GMT

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?

Re: Oracle SQL Developer Connection

buzzy996 — Wed, 13 May 2015 11:42:00 GMT

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!

Re: Oracle SQL Developer Connection

Anonymous — Wed, 13 May 2015 11:42:16 GMT

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

Re: Oracle SQL Developer Connection

jonathandienst — Wed, 13 May 2015 11:50:30 GMT

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

Re: Oracle SQL Developer Connection

Anonymous — Wed, 13 May 2015 11:53:18 GMT

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

Re: Oracle SQL Developer Connection

petter — Wed, 13 May 2015 11:54:44 GMT

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.

Re: Oracle SQL Developer Connection

buzzy996 — Wed, 13 May 2015 11:55:42 GMT

are u tried the above suggested solution by me?

Re: Oracle SQL Developer Connection

petter — Wed, 13 May 2015 11:57:45 GMT

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...

Re: Oracle SQL Developer Connection

Anonymous — Wed, 13 May 2015 12:37:54 GMT

I am using Oracle 11.02.00.01, Oracle in OraClient11g_home1