Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vijay_reddy
New Contributor

Accessing Oracle EBS views, Functions and Procedures

We are new to qlik can some one help us on the following 

How to access the views from oracle which contain data only after setting the environment variable to 'AR' or 'AP' etc.

How do we call oracle database stored procedures and functions from qlik sense during data load.

Thanks

Vijay

3 Replies
rohitk1609
Valued Contributor II

Re: Accessing Oracle EBS views, Functions and Procedures

Hi Vijaya,

First of all, you need to create an data connection with oracle data base through your machine ODBC or OLEDB. Download oracle ODBC or OLEDB drivers and installed  it to your machine and then go to administrator tools and create a system DSN and then test connection.

Now,

Open you Qlik Sense ,Create new OLEDB connection and select the same system DSN and you will have access to your database , select the owner and database and select your required table and insert the script.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

vijay_reddy
New Contributor

Re: Accessing Oracle EBS views, Functions and Procedures

Thanks for the reply .

yes we had already configured the ODBC connection and we are able to access the database .

But we have the problem with accessing views in oracle EBS .

we are able to get the records with < 50 record condition during data load .

With out condition we are getting the following error .

QVX_UNEXPECTED_END_OF_DATA: ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired.

ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired.

The following is the Query am trying to reload

LIB CONNECT TO 'OMTST (oicqlik_oicuser)';

Test:

SQL CALL Apps.MO_GLOBAL.set_policy_context('S',448);

SELECT *

FROM APPS.AR_CASH_RECEIPTS_V;

//

rohitk1609
Valued Contributor II

Re: Accessing Oracle EBS views, Functions and Procedures

Hi Vijaya,

I think i found the root cause, It has more to do with the Database server being unable to process the request due to high utilization. Qliksense just relay's the error it receives from the DB end.