Import DB schema from ODBC - lack of schema

[LUCY]

Hi
I am using EA V12 and MS SQL 2008R2

I am trying to reverse engineer tables from database  MS SQL 2008R2 (Import DB schema from ODBC) to Enterprise Architect.
I have a problem with the lack of schema on the list of schemas.

What conditions must meet the schema to be visible in the list of schemas ?

Can anyone please help me to understand this problem ?

Thanks

[skiwi]

You need permissions in the SQL database to view the schema.

Speak to your Database administrator. See also View Definition

[timestamp=1425929662] /me

[JanNilsson]

Hi
I tried the same with an Informix databasse. In the ODBC-configuration I have entered the informix user (dba with full access). It seems that EA is  somehow using my userid on my pc to filter the schemaname(owner), only 3 tables are shown and I can see wiht other tools that those three have my userid as owner. No other tables are shown. I can't log in to my computer as the user informix, that userid is only allowed by the dba on the server.

[JanNilsson]

Hi
I got it to work!
It seems that EA regards tables (and other stuff?) in an Informix database as "System objects" in they are created by the user Informix. Just check the box "Include system objects" and the schemaname Informix showed up and all the tables owned by Informix