Bug 780811 (SOA-3256)

Summary: Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under the "Select Data Objects" screen
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: dsteigne
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GACC: mathangi.pichai
Target Milestone: ---   
Target Release: JBDS   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3256
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-30 19:50:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
Additionalschemas.doc none

Description dsteigne 2011-08-10 20:06:08 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007r11j
project_key: SOA

Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under the "Select Data Objects" screen.  If a SQL Server database has multiple schemas underneath it, the importer will not show them, so you will be unable to choose and import the tables under any other schema besides dbo.  I've attached a printscreen document explaining further.
Comment 1 dsteigne 2011-08-10 20:06:29 UTC 
Attachment: Added: Additionalschemas.doc
Comment 2 Van Halbert 2011-08-10 20:31:35 UTC 
Link: Added: This issue Cloned to SOA-3257
Comment 3 Van Halbert 2011-08-23 14:31:47 UTC 
Committed by Teiid Designer and is available via their nightly updates.  Will be in the 5.2.
Comment 4 David Le Sage 2011-08-25 23:45:11 UTC 
Release Notes Docs Status: Added: Documented as Resolved Issue
Writer: Added: dlesage
Release Notes Text: Added: https://issues.jboss.org/browse/SOA-3256

The Teiid Designer's  "Import from JDBC" for SQL Server only showed one dbo schema under the "Select Data Objects" screen.  If there were multiple schemas under a SQL Server database, the importer would not show them. As a result, the user would be  unable to choose and import the tables under any schema other than dbo. This has now been corrected so that the user can choose and import tables under alternative schemas.
Comment 5 Paul Nittel 2011-11-30 19:50:59 UTC 
Tested and closed.