Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
fachto76
Contributor II
Contributor II

Where to Install oracle oledb connector on multi node site

I have been trying to find an answer on this.

I have the following multi node setup:

  1. Central
  2. Proxy Engine
  3. Scheduler

I need to add the Oracle oledb connection package, but do I need to install on all 3 node or just some particluars?

1 Solution

Accepted Solutions
vunguyenq89
Creator III
Creator III

Hi, you need to install it in all nodes running Qlik Sense Engine service and handling app reloads (i.e if you have a node with Engine service but only serves front-end dashboard and not reloads, you don't need to install OLE DB driver there). It's the Engine service that actually invokes ODBC / OLE DB drivers when loading from databases.

View solution in original post

2 Replies
vunguyenq89
Creator III
Creator III

Hi, you need to install it in all nodes running Qlik Sense Engine service and handling app reloads (i.e if you have a node with Engine service but only serves front-end dashboard and not reloads, you don't need to install OLE DB driver there). It's the Engine service that actually invokes ODBC / OLE DB drivers when loading from databases.

fachto76
Contributor II
Contributor II
Author

Thank you, I will test out and provide my feedback