Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Tarzan on May 27, 2025, 11:23:52 pm
-
Hi everyone,
I have tables modeled using the EAUML::table stereotype in Enterprise Architect, and I have a CSV export from an Oracle database with columns like:
Column_Name
Mandatory
Computed
Formula
Check_Constraint_Name
Default_Value
Use_Domain_Constraint
Uses_Default
Engineer
Table_Name
PK_Flag
FK_Flag
Native_Type
Sequence
I understand that you can customize the CSV import specification in EA, but what I don’t know is which exact values should be used in the CSV to correctly map fields to the stereotypes and attributes in the tables. For example, how should I represent a primary key checkbox (PK_Flag), or other flags like FK_Flag, Mandatory, etc., so that EA correctly interprets them as stereotypes or tagged values?
I want to import the columns into the correct tables based on the Table_Name field and have these attributes correctly set in EA.
If anyone has experience with this, or can share the correct way to format these values in the CSV for EA to recognize and map them properly, that would be a huge help!
Thanks in advance for any tips or examples.
-
You can't import attributes with the CSV import/export.
I wrote an excel import/export tool to do that type of stuff: https://bellekens.com/product/ea-excel-import-export/ (https://bellekens.com/product/ea-excel-import-export/)
Geert
-
If I've understood correctly you want to model the oracle database so why don't you just reverse engineer the oracle database
using functionality built into Sparx EA?
https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_domains/importdatabaseschemafromod.html (https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_domains/importdatabaseschemafromod.html)