3 Replies Latest reply: Sep 27, 2016 2:06 PM by Rohit Kumar RSS

    Accessing Oracle EBS views, Functions and Procedures

    Vijayabhaskara Reddy

      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

        • Re: Accessing Oracle EBS views, Functions and Procedures
          Rohit Kumar

          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

            • Re: Accessing Oracle EBS views, Functions and Procedures
              Vijayabhaskara Reddy

              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;

              //