Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connect to Oracle DB

Hi,

I want to connect Qlikview with my Oracle DB.

Can any one please provide me that link from which I can download the OLEDB.

1 Solution

Accepted Solutions
qlikpahadi07
Specialist
Specialist

you need to simply create a Connection String by Selecting OLE DB or ODBC in edit Script.

  1. before you should install same Oracle Client on your machine.
  2. make sure your system is connected in LAN.
  3. create a Connection String by Selecting OLE DB or ODBC drop box in edit Script and then click connect.
  4. you will find a simple wizard just select client driver go next and put proper Server ID/Database name/Pass and press okay.
  5. A connection String will get generate automatically then click Select and find all the tables.

View solution in original post

2 Replies
qlikpahadi07
Specialist
Specialist

you need to simply create a Connection String by Selecting OLE DB or ODBC in edit Script.

  1. before you should install same Oracle Client on your machine.
  2. make sure your system is connected in LAN.
  3. create a Connection String by Selecting OLE DB or ODBC drop box in edit Script and then click connect.
  4. you will find a simple wizard just select client driver go next and put proper Server ID/Database name/Pass and press okay.
  5. A connection String will get generate automatically then click Select and find all the tables.
Not applicable
Author

Great.......

Thank you for your quick reply