Book a Demo

Author Topic: Importing DB Schema from ODBC  (Read 2763 times)

jmcjq2

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Importing DB Schema from ODBC
« on: May 15, 2013, 04:12:03 pm »
Hi,

I'm trying to import a db schema from a database view but it imports the view without any attributes.  Is this possible and if so, how?  I'm using v10 professional edition

Cheers
John

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Importing DB Schema from ODBC
« Reply #1 on: May 16, 2013, 10:14:58 am »
I've never seen it work differently.

I think this would be a great feature request.
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.

Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 591
  • Karma: +7/-0
    • View Profile
Re: Importing DB Schema from ODBC
« Reply #2 on: May 16, 2013, 03:25:01 pm »
Attriabutes for Views are not shown in the model see: http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/create_view.html
With a View possibly being a very complex SQL statement it is not reasonable to expect it can be simply parsed to return a simple set of attributes.