I'm trying to load data into Qlikview (using ODBC connection) from the oracle database(views) but the query is executing fine and not getting any records.
If i query the same view in the SQL Developer IDE, i can see the data.
Please let me know if anybody have faced similar issue.
view_name is a view.
The connection sting looks like below.
ODBC CONNECT TO [newebs;DBQ=EBS ] (XUserId is HFVUIcBPFDeKGZBOZE, XPassword is eQaMHcBPFDeKGZBOSA);
select * from apps.xxegc_QV_sales_order_v;
One more thing is, i can query some other tables but not the above view.
The same query select * from view_name just works fine and fetches the data. In this case my back end database (Oracle EBS) and Qlikview desktop are on the same domain.
I am facing issue while connecting the Qlikview desktop from other domain.
Is that causing the issue?