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.
Ok. are you using any filter (with where condition)? May be it doesn't met the criteria.
Can you try to remove the filter and execute that?
Are you really sure do you have the data for the table view_name? (view_name is a view or table)
if it is view name, can you try load any other table name?
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?
I have added sql alter session set nls_language = 'AMERICAN'; statement after connection string and able to load the data.