Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Riccardo
Partner - Creator III
Partner - Creator III

Oracle DB Connection Multiple Node

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

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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.

View solution in original post

4 Replies
petter
Partner - Champion III
Partner - Champion III

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

Riccardo
Partner - Creator III
Partner - Creator III
Author

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,

R.

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
petter
Partner - Champion III
Partner - Champion III

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.

petter
Partner - Champion III
Partner - Champion III

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.