How to Import Oracle DB to EA

[Raghuram]

Hi, I am new to this EA could you please help in imporitng the Orcale DB to EA. we are using the Oracle DB and wanted to import all the Tables and Procs to EA for documentation.

[Luis J. Lobo]

Select in EA the package where you can the schema to be imported.

Optionally, you can create a class (or data modelling) diagram in order to draw automatically the DB objects when imported.

Right click on the package, and select "Code Engineering | Import DB Schema from ODBC..." option.

Set the ODBC connection and the other options, and press OK. The DB objects should appear (tables, views, procedures, functions, triggers...). Select the desired ones and finish the import process.

[Dermot]

Note: it is necessary to use the Oracle supplied ODBC /OLE driver: "Oracle Provider for OLE DB" see: http://www.sparxsystems.com/uml_tool_guide/uml_model_management/connecttoaoracle9idatarep.html

[Raghuram]

I have oracle installed on my system and then performed the actions to export the content to the EA with the Code Engineering.
Thankyou for the information I got it done. Success!!!!!!!!!!!

But i am facing problem in impoting the Procs, when i imported only the packages and tables were copied to EA. is there any way to import procs also.

[Dermot]

Procedures can be stored in two possible locations: as an Element or as a Class Operation:
see:
http://www.sparxsystems.com/uml_tool_guide/data_modeling/importdatabaseschemafromod.html
&
http://www.sparxsystems.com/uml_tool_guide/data_modeling/storedprocedureindividualclass.html

[Raghuram]

Thank you!!!!!!!
I got it Solved.

[k2901]

When you say you solved it? I wonder if you could clarify how the Procs where stored in the Oracle DB.

I've been trying to get Stored Proc's (Stored in Oracle Packages) imported without much luck.

[RoyC]

See the following procedure:

http://www.sparxsystems.com/uml_tool_guide/data_modeling/importdatabaseschemafromod.html

For stored procedures, you need to select the Include User Stored Procedures checkbox, and the Import as individual classes radio button.  We now recommend that you don't import stored procedures as class operations.

At the end of the procedure - step 9 - a dialog displays from which you specifically select the stored procedures (and tables) to import.

If this procedure is not working, could you please submit a bug report stating the steps you have performed and the point at which things do not happen as expected?  Thanks.