Import tables into database builder

[arnwik]

Hi,

if I missed the post addressing this issue I am sorry.
So I created a high level model as a conceptual model, not entirly sure if I was going to use a relational database. After a while a created a relational logical datamodel, not targeting any particular database system (except relational and sql).
Now I want to target a particular DBMS system, say MySQL using the database builder. Is there a way to build in the structure I already have created? It seems like the only option I have to to through a starter model. It creates alot of stuff I don't need, and I can't find a way to import my current tables.

Br
Arnwik

[Modesto Vega]

Writing a model transform should do it - please see https://sparxsystems.com/enterprise_architect_user_guide/15.1/model_domains/transformationtemplates.html. It may look a bit intimidating at first glance, but once you have a transform written it should work for any model. I have used them in the past to transform conceptual to logical and logical to physical.

[arnwik]

Thanks for the reply.

Maybe I should be a bit more specific.
Here is a link where I describe issue a bit more in detail.
https://youtu.be/ykLX4q_f5tw

Br
arnwik

[arnwik]

Ok, so I found a way to copy the tables over. But for them to show you have to remove right click on the pane flick and press "reload 'database builder'". This feature should have been on the root of the database itself - not very intuitive.

Br
arnwik

[Paolo F Cantoni]

Ok, so I found a way to copy the tables over. But for them to show you have to remove right click on the pane flick and press "reload 'database builder'". This feature should have been on the root of the database itself - not very intuitive.

Br
arnwik

There are a number of aspects of the DBB UI that are "Less than optimal".  Please submit a formal bug report using the links below.

Paolo

[Modesto Vega]

[SNIP]
Ok, so I found a way to copy the tables over.

Could you please expand on the above quote? How have you copied the tables into database builder? The database builder is just showing you a project on the tree browser organised differently. If you have used project browser to copy the tables, in version 15.1.1527 right click/refresh will display any tables I have manually added through the project browser.

Just a a number of random comments:

• the EAUML::table stereotype is a stereotype for physical tables and not for logical and conceptual tables. I highly recommend not to use the <<table>> stereotype for logical and physical tables. After all both logical and conceptual data models are supposed to be technology independent and the <<table>> ties you to an RDBMS - i.e., to a technology.
• the video shows the Tables Model Transformation being used. This transformation is intended to transform classes - i.e., elements of Class base type - into tables - elements of a Class base type with a stereotype EAUML::table. Data types are transformed by the CONVERT_DB_TYPE() function using a mapping table, I'll try to find it out.

 

[Modesto Vega]

Just a follow up to the previous post.

The mapping between database types and common types can be viewed and changed for a specific product - aka RDBMS - through the Configure ribbon tab Settings\Database Types. With the common type with the common type field showing you how a physical data type maps against a common data type.