topic Oracle DB Connection Multiple Node in Connectivity & Data Prep

Oracle DB Connection Multiple Node

Riccardo — Thu, 23 Nov 2017 16:35:04 GMT

Hi all,

I have to create a new connection to Oracle DB.

My DB has multiple host and one service name. How can I configure it into Connection into Qlik Sense?

Thank you,

Riccardo

Re: Oracle DB Connection Multiple Node

petter — Thu, 23 Nov 2017 16:39:17 GMT

Oracle should be able to resolve that with the their client software. Are you using either Oracle ODBC or OLEDB client?

Re: Oracle DB Connection Multiple Node

Riccardo — Thu, 23 Nov 2017 16:47:49 GMT

with OLE DB I can use my tnsnames client, that inside it is written the connection string.

But ODBC how can I do that?

thank you,

Re: Oracle DB Connection Multiple Node

petter — Thu, 23 Nov 2017 21:51:34 GMT

Oracle recommend that you use OLEDB. But Oracle also have and ODBC client often installed together with the OLEDB installation in a single installation package.

Re: Oracle DB Connection Multiple Node

petter — Thu, 23 Nov 2017 21:53:06 GMT

An alternative could be to use the Qlik ODBC Connector Pack where you can find a sub-connector for Oracle. It is often much speedier than Oracle's own driver. It is much simpler to setup and connect with.