Sugession on oracle source

[Tool_Tip]

Dear all,

We have "ORACLE" as our database source. I need to understand what is best practice to create the connection from the following highlighted list and why :

[mpc]

Hi, 

OleDB is an old way to gather data, last time I've used it was in... 2016 I think with QlikView 11.2 with Oracle, due to performance issues this the ODBC connector. 

But things evole, and now it's recommanded to use ODBC connectors due to performance, Security and easy to maintant approach. 

But what's the differente between the Qlik ODBC and the one you install.

QLik ODBC is produced by a company, and it's optimized. Moreover, you do not have any installation or maintenance with this one. Migration to another server is more easiest too. 

ODBC Native driver are managed by you, then you should install, update and fine tuning it. One advantage to it, you can patch it if any security issue or perfomance one. 

My personal preference is to use ODBC Qlik's one

Kind regards

[Tool_Tip]

Hi Mpc,

Thanks for your valuable suggestion. 

What do you thing about the third one I have highlighted " Oracle", what makes it different than the other two OLE DB & ODBC ?

[mpc]

My bad the Oracle highlighted one (the third one) is called QLik ODBC in my previous anwser 🙂 

[Tool_Tip]

Okay. so you have suggested to use ORACLE instead of OLE DB or ODBC, correct?

[mpc]

Exact !

[TauseefKhan]

@Tool_Tip 

The ODBC connector is generally the best practice due to its superior performance, security, and ease of maintenance. It streamlines the connection process, reducing manual overhead.

[Tool_Tip]

Thank you Mpc and Tauaseef. But I also want to have some comments on your below suggestion :

Even though I am using Qlik ODBC (ORACLE), I am facing performance issue. I have also posted the separated question for the issue. The data fetch from table/view is fine but I am facing issue when I am fetching the data from oracle package with function used passing single parameter. for more detail you can refer below my post :

https://community.qlik.com/t5/App-Development/function-with-single-parameter/m-p/2481306#M100817

[mpc]

In this peculiar case, I think the Oracle (Qlik ODBC Driver) is not the one to use. It's optmized for "standard" bulk load. You may use ODBC managed by yourself. 

[Tool_Tip]

What you mean by 'optmized for "standard" bulk load.'