I created another schema underneath the BQT2 database on my SQL Server 2005 , gssntdb07.mmx.gss.redhat.com:1433 Second schema is named BQT_SCHEMA2 and there are 2 tables in it Table2 and Table3. 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 sys. 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.
Pages to are hidden for
"I created another schema underneath the BQT2 database on my "Please download to view full document