This content has been marked as final.
Show 4 replies
-
1. Re: problem with importing views from a different schema
rkishore999 Sep 22, 2009 7:36 PM (in response to rkishore999)I have noticed that internally designer is running the query like this:
select * from <view_name>
It should have been "select * from XYZ1.<view_name>"
As the logged in schema is different from the view owner, Teiid has to prefix the view with the owner.
Sorry if I'm confusing.
Regards
Ram -
2. Re: problem with importing views from a different schema
rkishore999 Sep 23, 2009 1:04 PM (in response to rkishore999)Sorry. The same problem exists for a TABLE as well.
-
3. Re: problem with importing views from a different schema
shawkins Sep 23, 2009 2:18 PM (in response to rkishore999)There should be an option on import to fully qualify the name in source property. That should use the schema name in the source query.
-
4. Re: problem with importing views from a different schema
rkishore999 Sep 24, 2009 3:09 PM (in response to rkishore999)Thanks Steve. Yes, We can use the property to use the full name of the entity. The other way is, We created a synonym for the view and imported the synonym. It worked that way too.
Regards
Ram