Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aj0031724
Contributor

DIRECT QUERY ORACLE OLEDB CONNECTION AND SYSTEM REQUIREMENTS

DEar Team,

I am getting connected with Oracle insome machine from Qlikview with below connection:

OLEDB CONNECT32 TO [Provider=MSDAORA.1;Password=ido;User ID=ido;Data Source="HOSTNAME/SERVICENAME"];

AND IN SOME MACHINE WITH ONLY:

OLEDB CONNECT32 TO [Provider=MSDAORA.1;Password=ido;User ID=ido;Data Source=""SERVICENAME""];

In client environment we are truing to generatereport WITH direct query.

Can you please advise what are the requirements to set up OLEDB CONNECTION SUCCESSFULLY and which string should I use?

Do we really nned to have ORACLE CLIENT ON QLIKVIEW SERVER MACHINE?

Please guide.

3 Replies
Chanty4u
Esteemed Contributor III

Re: DIRECT QUERY ORACLE OLEDB CONNECTION AND SYSTEM REQUIREMENTS

buzzy996
Honored Contributor II

Re: DIRECT QUERY ORACLE OLEDB CONNECTION AND SYSTEM REQUIREMENTS

Can you please advise what are the requirements to set up OLEDB CONNECTION SUCCESSFULLY and which string should I use? --pls see the above suggested link.

Do we really nned to have ORACLE CLIENT ON QLIKVIEW SERVER MACHINE? -- Not required.

check ur ora.tns file is updated with ur oracle server data base details or not.

if required check ur system environment variable setup.

Re: DIRECT QUERY ORACLE OLEDB CONNECTION AND SYSTEM REQUIREMENTS

If you are having the Connection string in some machine and it's working fine then you can use the Direct Query in qlikview without need of oracle client.

Community Browser