I created another schema underneath the BQT2 database on my SQL Server 2005 ,
Second schema is named BQT_SCHEMA2 and there are 2 tables in it Table2 and
If you Import from JDBC in MMX 554 using the DataDirect Driver, this is what you see
on the “Select Data Objects” screen.
Notice you see under bqt2 > BQT_SCHEMA2, dbo, INFORMATION_SCHEMA and
If I use the Native SQL Driver inside of MMX 554, you get:
Now using JBDS 4.0 (Teiid 7.1.1 update) and the same SQL Native Driver for the Import
from JDBC, this is what you see:
Notice the second Schema BQT_SCHEMA2 is missing, so you would not be able to
import any tables from this schema into Teiid Designer.