Qlikview: DSN creation and connecting to Oracle

[parvez933]

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

[parvez933]

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]

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 · Accepted solution]

Hi All,

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