Author Topic: v16 Database Builder does not read VIEW COLUMNS from Oracle DB  (Read 193 times)

rmkk

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
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.

Richard Freggi

  • EA User
  • **
  • Posts: 493
  • Karma: +18/-7
    • View Profile
Re: v16 Database Builder does not read VIEW COLUMNS from Oracle DB
« Reply #1 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.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1320
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: v16 Database Builder does not read VIEW COLUMNS from Oracle DB
« Reply #2 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.
Happy to help
:)