Database Engineering

[Eamonn John Casey]

Hi! I have a few questions about database engineering (Database Builder) in EA.

1. Is it possible to generate DDL without having a active database connection? How?

2. Can I import DDL into the Database Builder package?

3. I am having problems creating views. Is there anyone that has blogged or written any instructions on how to do this? I am thinking drag-and-drop database classes from the repository and link them together graphically. Is that possible.

Eamonn J.

[qwerty]

1. EA creates DDL from a transformation as a file. So no DB required except that where the repository is held.
2. No. You only can import from a DB/ODBC source
3. No idea

q.

[Geert Bellekens]

3. Creating a diagram like that will work just fine. Create a database view like that won't. You'll have to do it the "hard" way I'm afraid (manual SQL).

Geert

[qwerty]

I guess he's talking about SQL views, not UML views?

q.

[Glassboy]

I guess he's talking about SQL views, not UML views?

Yes.  Clue was in "database engineering" :-)

[hd]

1. Is it possible to generate DDL without having a active database connection? How?

Yes.  http://sparxsystems.com/enterprise_architect_user_guide/12.1/database_engineering/ddl_generation.html

2. Can I import DDL into the Database Builder package?.

No.

3. I am having problems creating views. Is there anyone that has blogged or written any instructions on how to do this? I am thinking drag-and-drop database classes from the repository and link them together graphically. Is that possible.

http://sparxsystems.com/enterprise_architect_user_guide/12.1/database_engineering/views.html