Oracle Connectivity in Qlikview Server

[manideep78]

Hi All,

I am developing a qlikview application where i connect to Oracle database via ODBC.

I am not sure how this connection works if I deploy this app in the Qlikview sever.

FYI, I do not have  access to QMC and was give a  folder in remote machine where i have to place my application.

If I connect to oracle using DSN created my system,  Does qlikview admin need to  set up the same in the sever machine where Qlikview is hosted?

Thanks in advance

[lblumenfeld]

Have the admin set up a Data Source to the Oracle database. You should be given read access to the data source via a security rule. Then, in your app, code the connect statement to reference the connection.

LIB CONNECT TO 'DataSourceName';

I hope this helps.

[manideep78]

Hi @lblumenfeld 

Thank you for reply.

I tried connecting to ODBC to pull the records from oracle and to my surprise it took more than 90 mins to load the 20k records.

So, I have dropped the idea of ODBC and tried with Oracle OLEDB provider which I installed from ODAC.

i set up everything correct and could able to pull the records. Now, I can see only 1900 records out of 20k. There is no error as well.

I could not understand what went wrong.

[Brett_Bleess]

What I would recommend is configuring the Document/Script log in that case, so you can review that as that will tell you exactly how many rows are being fetched etc., so you can better confirm what may be occurring during the load:

How to enable Script/Document Log 

Hopefully this gets you some further information that will help you move things forward.  That should help us further assist you too if you cannot figure something out once you have that.

Regarding your initial question, you were correct, would need the DSN configured on the server too.  One reason things can be slower is the fact running things from a service account very often get assigned a lower priority by the database backend, so might be worth talking to the DBAs regarding that and if there is something you can do in the connection string etc. to change that to improve the time to reload.  About the best I have at the moment.

Regards,
Brett