import from sql into existing model gives error saying 'not authorized' when I click on 'parse and import'.

I am selecting option 'add to current model'. Could you please help?

Can we create the logical model in this tool (to add entity and attributes) and then convert to physical by having some naming standard?

I assume currently we have only physical model where we add the tables and colums.

Hi!

The proposed data model image is not shown here!

https://www.vertabelo.com/blog/again-and-again-managing-recurring-events-in-a-data-model/

Hi, I have just signed up to using Vertabelo and I am looking to use the reverse engineering tool to bring in all my tables from my database.

My Java is all setup and I have downloaded the latest version of the reverse engineering files version 19.4.0.

I have put all my files in one folder with the ojdbc6.jar and reverse-engineering.jar files.

When I run the following command in cmd:

java -cp .;reverse-engineering.jar;ojdbc6.jar com.vertabelo.reverse.Main -url "jdbc:oracle:thin:@//localhost:1521/xe" -user USERNAME -password password1234 -o localhost_file

I get the error:

Error: Unable to initialize main class com.vertabelo.reverse.Main
Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException

I have tried to search the forums, but I haven't found anyone coming up with this issue, so would really appreciate if any one could advise on how I could resolve this issue.

Hi,

Starting v12c of Oracle, we can add identity column to tables, here is an explanation:

https://www.oracletutorial.com/oracle-basics/oracle-identity-column/#:~:text=Introduction%20to%20Oracle%20identity%20column,the%20surrogate%20primary%20key%20column.

How can I add this to the ERD definition in vertabelo ?

I have imported a large database into Vertabelo and would like to group tables in subject areas. I can see the options in Subject area we have are only for creating new tables. I am trying a tedious process of dragging tables into subject area in the workspace section manually but because the database has a lot of tables, it is geting more time consuming. Am I missing an easy way to add tables to Subject area during reverse engineering?

Any plans of implementing this ?

Its common approach for modelling subtypes. It does not influence generated table structures, but are a great help in understanding the model.

Descriminator.PNG

My java version is : openjdk version "11.0.2" 2019-01-15

and when I run the command

java --add-modules java.xml.bind -cp .;reverse-engineering.jar;ojdbc6.jar com.vertabelo.reverse.Main -url "jdbc:oracle:thin:@//localhost:1521/xe" -user USERNAME -password 
password1234 -o localhost_file

I get error : Error occurred during initialization of boot layer
java.lang.module.FindException: Module java.xml.bind not found

Is my java version not comaptible?