reverse engineering

[wjcasperson]

This is my first experience using EA to reverse engineer architecture diagrams from code.  I could use some help on how to:
  Generate Package Dependency diagrams.
  Generate the Logical Data Model from the SQL, DDL, and Stored Procedures.

[«Midnight»]

Logical data model:

You need to connect to the database - you could use an empty schema if you don't have data - via OLEDB or ODBC. EA will want you to create a data source for this, but will walk you through the Windows dialogs for doing so. Make sure you have the necessary privileges to access the schema information. [This part trips people up. Oracle seems to be particularly strict about this, but other DBMS engines can be tricky too.]

You can start the process by creating an empty package. Create a diagram in the package and ensure that it is open. From the main menu choose Project | Database Engineering | Import DB Schema from ODBC.

You can figure out the various entries in the resulting dialog. One caution though. Make sure you choose Create as New the first time, or you might get nothing...

I'm not sure whether EA will create a package dependency model for you automatically. Anyone have the current (version 7.1) answer?

HTH, David