topic Where to Install oracle oledb connector on multi node site in Connectivity & Data Prep

Where to Install oracle oledb connector on multi node site

fachto76 — Mon, 18 Nov 2019 09:34:18 GMT

I have been trying to find an answer on this.

I have the following multi node setup:

Central
Proxy Engine
Scheduler

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

Re: Where to Install oracle oledb connector on multi node site

vunguyenq89 — Wed, 20 Nov 2019 08:07:55 GMT

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.

Re: Where to Install oracle oledb connector on multi node site

fachto76 — Thu, 21 Nov 2019 09:22:03 GMT

Thank you, I will test out and provide my feedback