topic How to call a table with oracle dblink in QlikView

How to call a table with oracle dblink

Mon, 10 Jan 2011 12:34:50 GMT

Hi, I need to select data from a table in Oracle which is linked by dblink:

SELECT *

FROM "MYSCHEMA"."VIEW01@OTHER_SCHEMA";

When I try to reload script, it throws an Oracle error:

SQL Error:[Oracle][ODBC][Ora]ORA-00942: table or view doesn't exist

I'm trying to avoid the creation of more views inside MYSCHEMA.

Is that possible?

Thank you!

Mon, 10 Jan 2011 12:56:53 GMT

first u make dsn then you could call that dsn in qvw file.

then connection string is generated.

now you can

SELECT *

Regards

Ashish

Tue, 11 Jan 2011 09:23:52 GMT

Done, It worked. Thank you!