Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Issue with Oracle Synonym

Has anyone come across error with synonym on oracle tables? seems to time out as it thinks the table is either not there but when I run the same script in oracle or toad using the same user id and password credentials, it runs with no problem. Can anyone help with this?

4 Replies
Highlighted

Re: Issue with Oracle Synonym

Does a simple select * from tablename from QV against a simple small Oracle table work ok ?

Highlighted
Specialist
Specialist

Re: Issue with Oracle Synonym

To avoid this problem, have 3 tier architecture.. store all relevant source tables into QVDs and then use transformations, this will not have that oracle "synonym" issue.

HTH

Sreeni

Highlighted
Contributor III
Contributor III

Re: Issue with Oracle Synonym

Hi Sreeni,

thank you for your help. I tried restructuring the architecture of the table and that seems to have helped. I also, streamlined the amount of data I am pulling in. that is working also. thank you for your help.

Highlighted
Specialist
Specialist

Re: Issue with Oracle Synonym

Glad that it has worked! Please close the thread by marking correct or helpful