topic Re: How to make ODBC connection accessible on all nodes in Connectivity & Data Prep

How to make ODBC connection accessible on all nodes

Udo — Fri, 30 Sep 2022 12:20:26 GMT

Hi all,

This might sound like a newbie question. However...

We have a Qlik Sense Enterprise cluster setup. There are Central and Failover node, as well as two presentation nodes.
Now we have the task to set up a ODBC connection on the OS of one of the nodes and access this via an ODBC connection in Qlik. Is it necessary, to install the connection on all 4 server OS or would it be sufficient to install it on one of them? Of course the connection needs to be accessible within Qlik from all nodes.

Thanks!

Re: How to make ODBC connection accessible on all nodes

Jay_Brown — Tue, 01 Nov 2022 20:51:17 GMT

@Udo yes, it is necessary to set the ODBC connection up on all nodes that will be connecting. Hope that helps!

Re: How to make ODBC connection accessible on all nodes

RafaelBarrios — Tue, 01 Nov 2022 20:57:05 GMT

hi @Udo

you will need to create the ODBC connection in all nodes.

and your database must be reachable from all nodes.

Hope this helps.

best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂