Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
parvez933
Creator
Creator

Qlikview: DSN creation and connecting to Oracle

Hi All,

I had given below things to connect to Oracle

Username: ********
Password: ************

TNS Entry:

Name=
(DESCRIPTION=
(LOAD_BALANCE=yes)
(SDU=32768)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=someonw.com)
(PORT=1525)
)
(CONNECT_DATA=
(SERVICE_NAME=Name)
)
)

While referring to many posts I had found the below string

odbc CONNECT TO [Provider=OLEDB.Oracle.1;Persist Security Info=False;User ID=A_TABLES;Data Source=Name;Extended Properties=""] (XPassword is PASSWORDJHFOWNFLAM);

were Provider=OLEDB.Oracle.1 is an DSN Name

From other posts, I understand in ODBC Data Source 64 Bit of windows there should be an default DSN by the name Oracle.

But, in my case I am unable to find any details regarding to Oracle.

Can anyone help me in configuring the DSN and connecting to Oracle. Please awaiting for help as the issue raised in peak time.

Regards,

M. Parvez

1 Solution

Accepted Solutions
parvez933
Creator
Creator
Author

Hi All,

Somehow, my colleague helped me from Youtube. So marking as Resolved. 

View solution in original post

3 Replies
parvez933
Creator
Creator
Author

Hi All,

I request your help, can anyone please help in establishing connection with Oracle DB.

As said earlier, I am unable to configure DSN, when I am trying to refresh the dashboard, It is asking me to configure the DSN. Please find the attachment.

Please please help, as the requirement was supposed to taken but still I am stuck up with establishing the connections.

Regards,

M. Parvez

parvez933
Creator
Creator
Author

Hi All,

The initial request was shared on Tuesday, I request anyone help in configuration the DB as the delay is impacting the requester.

I request anyone who had worked on this scenario, please do help.

Please, please, please do help here!

Regards,

M. Parvez

parvez933
Creator
Creator
Author

Hi All,

Somehow, my colleague helped me from Youtube. So marking as Resolved.