When I choose Oracle as my data source in the Business Object Mapper, I can see Oracle tables but I can not see any Oracle views.  In searching the forum posts, it looks like that this was previously possible but may have changed with the last update.  I downloaded the Strataframe software for a trail in December ... so I am assuming that I have the latest version.  I read in a post from the "Issues" forum about the same problem, but no one had replied to that post.

Any ideas or suggestions?

Am I also correct in my understanding that the DDT works ONLY with MS SQL databases and NOT Oracle databases?

Thanks for any help you can offer ....

The BOMapper can map to a table in any data source (Oracle, SQL, DDT, OLE DB), however, it can only map to views that are created in SQL (actually on SQL Server, not just within the DDT).  The BOMapper cannot map to views within the DDT because regexing the view syntax became too troublesome to capture every possible field within the view.  So, we left it to mapping to SQL Server views, because SQL Server parses the columns that belong to the view for us.

So, you would still need to create a pseudo table within the DDT that has same structure as your view in Oracle and then, you can map to that.