Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thank you.
Regards,
Viresh
can you check your log file? Is that showing any records read?
Hi, It says 37 fields found , 0 lines fetched.
Regards,
Viresh
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?
Hi, I am not using any filter. The query looks like select * from view_name;
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?
Hi,
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.
Regards,
VK
ok. Can you check this. Extracting views from Oracle
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?
Hello,
I have added sql alter session set nls_language = 'AMERICAN'; statement after connection string and able to load the data.
Regards,
Viresh