DB Import - No Columns for Views

[NuWood Tech, Andrew]

Hi

I am in need of importing a small schema of views (used for reports) into a stand alone project in EA. I wish to document the view structure and the relationships and then use the HTML documentation to give to the client.

I can import views ok but not the columns of the views. Is there a particluar reason for this and is there a way to make this happen?

I have tried tables and the columns come over but views they are blank.

I am running v7 build 815 and the db is ORACLE (if that makes any difference).

[Martin Terreni]

I don't think EA does it...

[Paolo F Cantoni]

Surprisingly, if you enter "view column" (without the quotes) into the search function (at the top of this page), you may find the answers you are seeking...  

[Martin Terreni]

Always good to have a "guru" around

[NuWood Tech, Andrew]

So basically it doesn't support it.

OK, well I will go to plan B and get them into EA another way. The HTML documentation is to good not to use.

[Pawel Zubkiewicz]

Same problem 9 years later....

Using EA12.1 I've imported subset of Views from Sybase DB. I didn't imported any tables though as they are not human readable ( great design and architecture ;-( 

In result of such import I don't have any columns on VIEW elements.

Is it normal behavior?
Is is possible to import in a way to have columns on views?

[Geert Bellekens]

I think a view only imports the SQL query that defines the view, not the columns it returns.

Geert

[Pawel Zubkiewicz]

That's correct. I've got the sql query in view element. Well, that would be all folks ;-(

[Guillaume]

I came across the same issue and submitted it as a feature request.
According to the latest Sparx update I got, it could not be planned for the near future.

Best option is probably to define a script that extracts columns from the SQL query associated with the view.