Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I am using Oracle sql developer 4.2 in my desktop . I want to setup connection details in local desktop.
can anyone please help me how to connect the tns entries in oracle and alos connect to QlikView through odbc script editor
please find the connection details of oracle
----------
Host:12345.hhk , port no:121
service name:1234.hhh
user:abs
password:123SS
schema: erer
-----------
how to connect toad with QlikView
Sahaja, here is link I found on Oracle site that should help:
https://docs.oracle.com/database/121/ADFNS/adfns_odbc.htm#ADFNS1112
Once you have a DSN configured, you can then use the following link to create the data connection in the QlikView script editor:
Then you can use the Select option:
Hopefully this gets you on the right track with things. Apologies if I have misunderstood your question.
Regards,
Brett