Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: rmkk on May 23, 2025, 05:36:42 pm

Title: v16 Database Builder does not read VIEW COLUMNS from Oracle DB
Post by: rmkk on May 23, 2025, 05:36:42 pm

Hi, I'm using DBB to read structures from Oracle. Tables are loaded well including table columns. However VIEWS are loaded without view columns. Is there a workaround for that ? I read somewhere that the is an option to "Import from DDL" but I can not find this option. Many thanks for help.

Title: Re: v16 Database Builder does not read VIEW COLUMNS from Oracle DB
Post by: Richard Freggi on May 24, 2025, 12:07:41 am

I think this is normal.  I extract the column names by querying Oracle metadata and import them into the model with the Belleken importer.

Title: Re: v16 Database Builder does not read VIEW COLUMNS from Oracle DB
Post by: Sunshine on May 24, 2025, 12:05:10 pm

Have you tried a different option to connect to Oracle DB. I have a distant memory of reverse engineering an Oracle DB which didn't import everything I was expecting and the solution was to use a different way of connecting to the DB. IIRC it was either a version of the driver or ODBC vs OLEDB.