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.
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.
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)';
SQL CALL Apps.MO_GLOBAL.set_policy_context('S',448);