Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

tns connection details

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

 

-----------

 

 

 

 

 

 

 

 

 

 

2 Replies
qlikapple
Creator
Creator
Author

 how to connect toad with QlikView

Brett_Bleess
Former Employee
Former Employee

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:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Connect_to_Data...

Then you can use the Select option:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Create_Select_S...

Hopefully this gets you on the right track with things.  Apologies if I have misunderstood your question.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.