How to make ODBC connection accessible on all nodes

[Udo]

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!

[Jay_Brown · Accepted solution]

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

[RafaelBarrios · Accepted solution]

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! 🙂