topic Re: Sugession on oracle source in App Development

Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 05:17:30 GMT

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 :

Re: Sugession on oracle source

mpc — Thu, 19 Sep 2024 06:33:37 GMT

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

Re: Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 06:46:50 GMT

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 ?

Re: Sugession on oracle source

mpc — Thu, 19 Sep 2024 07:04:57 GMT

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

Re: Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 07:16:00 GMT

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

Re: Sugession on oracle source

mpc — Thu, 19 Sep 2024 07:26:02 GMT

Exact !

Re: Sugession on oracle source

TauseefKhan — Thu, 19 Sep 2024 07:31:49 GMT

@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.

Re: Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 07:37:37 GMT

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

Re: Sugession on oracle source

mpc — Thu, 19 Sep 2024 07:47:21 GMT

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.

Re: Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 07:51:09 GMT

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

Re: Sugession on oracle source

mpc — Thu, 19 Sep 2024 07:53:07 GMT

I mean using more classic load, without use of functions, package load and so on

Re: Sugession on oracle source

Tool_Tip — Thu, 19 Sep 2024 07:58:13 GMT

Ah okay. Thank you so much for your input.