Import Oracle View into Data Model

[welfert]

How do I import a Database View into my Data Model? I am using Oracle 8.1.6 as the database.

[CJ]

I don't think EA supports view imports.  If it does   , my apologies and please, someone, correct me.

[kelly_sumrall]

Nope, It doesn't appear to see the views.  I tried with the Microsoft for Oracle ODBC driver and the Oracle ODBC driver.  I only got a list of tables, no views.  I am able to see the View trhough my Data Connections in Visual Studio .NET using Microsoft OLE DB Provider for Oracle.  I can't tell if it is an ODBC issue or an EA issue.  Maybe this can be an enhancement to future versions of EA.

[CJ]

Looking at view definitions is just a matter of selecting from Oracle system tables (sys.dba_views or sys.all_views) ... I doubt that it's an ODBC issue.

Before saying that it's a feature that EA doesn't support, can anybody explain how to model database views in UML?

A database view is like a table in that you can select from it and it has columns, but I find it is more like code (it is a select statement).  So how do you model that?