Reverse Engineering Database Views

[dave]

Is it possible to import a database view into EA?  I need to document a number of our views and EA already has a lot of the business rules defined.

[thomaskilian]

Why not just try what happens?

[dave]

I did and it didn't work, hence the question.  I thought there may be another way.

[thomaskilian]

Obviously views are not supported (just tried it myself). That means you have to handle these manually. I don't know what you could alternatively use - maybe an artifact containing the SQL statement? Probably someone else has a better idea  

[dave]

I would life to set up something along the lines of a data dictionary for a view and as EA already had a lot of the business rules it seemed like the logical place.  It could be a useful enhancement.

[bu66le]

EA has no direct support for view, nor <<view>> is available as a built-in stereotype. Well, what I did is create the stereotype <<view>> based on <<class>>, drag and drop the class symbol and stereotype it as <<view>>. After that, fire up ur favourite text editor and write CREATE OR REPLACE VIEW...  

I hope EA will add support for view modeling *cross fingers*

[SamJolly]

I would totally support that. Full DB functionality covering Tables, Views, Triggers - Have a look at some other products like Computer Associates Allfusion ER/WIN or Sysbase PowerDesigner for ideas.

Incidentally can stored procedures and functions be modelled. They must be like methods against a table class....?

Keep the good work up.

Sam

[hd]

We are in the process of adding support for modelling stored procedures and views.