reverse engineer of PL/SQL

[az]

hello,
how can i do subj in EA ?
thank you.
Andrew

[«Midnight»]

Hi Andrew,

In the EA help file index, look up Import, with the subtopic Database Schema from ODBC. You will need to play around a bit with the various options on the resulting dialog.

Until you are used to how this works, I suggest you only import to an empty diagram in an otherwise empty package. Choose the Import To Diagram & Package option (which should be the default). Once you get the hang of things you can try other settings.

David

[az]

thank you.
It does NOT (?) seemed to remove objects from the diagram once they there imported and, later, removed from the DB...

[az]

also i would be interested to see the calls from one functions/procedure to another. similar to the graphs that are created from views.
is it possible ?

[«Midnight»]

Sorry, I didn't quite get what you were trying to do.

When you reverse engineer to a previously created model you'll have to do quite a bit more work. I don't believe incremental changes are handled as yet. We've been waiting - not very patiently of late - quite a while for this to be handled.

All I can suggest is importing to a new package each time.

Also, when forward engineering (back to the database) play around with some of the dialog settings; some are specific to PL/SQL.

Sorry that this is not yet what you want. I among many other users know just how you feel.

David

[az]

thank you David.

Let me try to elaborate better:

1. I have a bunch of pl/sql code.
2. I need to build a digram that ( at minimum ) would show me the relations - what procedure was called from what function/package.
3. i hoped to create ( based on the diagram from the step 2 ) a sequence and communication diagrams.
4. i need to generate documentation - sort of what is this function/procedure do
5. hopefully build a high level workflow.

[«Midnight»]

I don't know - not meaning I doubt it, just that I have no idea at all - if EA will do the cross reference for you. If it will, my guess is that you might have to intervene with a few steps before you'll get there. [I gather from your last post that this would be OK.]

Anyone else have any idea how this could be accomplished?

[az]

the more i try to make it work the less satisfied i become.
It's a nice product to make a clean first release top-down, but for my purposes apparently, i have to look somewhere else.