[JBoss JIRA] (TEIIDDES-1327) Issues with "Create Relational View Model From Schema"
by Steven Hawkins (JIRA)
Steven Hawkins created TEIIDDES-1327:
----------------------------------------
Summary: Issues with "Create Relational View Model From Schema"
Key: TEIIDDES-1327
URL: https://issues.jboss.org/browse/TEIIDDES-1327
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.6
Reporter: Steven Hawkins
Right clicking on an .xsd and selecting "Create Relational View Model From Schema" presented a dialog where the select all option was not selectable by default. I had to first click on a global element and then hit select all. After running selecting all elements I got an error dialog with the detail "Create Virtual Tables from Global Entities
Unexpected content type : org.eclipse.xsd.impl.XSDModelGroupImpl
Unexpected content type : org.eclipse.xsd.impl.XSDModelGroupImpl"
See the attached xsd.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 1 month
[JBoss JIRA] (TEIIDDES-319) Request for single table import option in Web Service As Relational web service
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-319?page=com.atlassian.jira.plug... ]
Barry LaFond resolved TEIIDDES-319.
-----------------------------------
Resolution: Duplicate Issue
This was completed in 7.7 Teiid Designer release as part of the WSDL to Relational Source & View models importer.
Basically REQUEST & RESPONSE procedures are created and then used in a Wrapper procedure containing the input parameters AND the output result se.
> Request for single table import option in Web Service As Relational web service
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-319
> URL: https://issues.jboss.org/browse/TEIIDDES-319
> Project: Teiid Designer
> Issue Type: Feature Request
> Affects Versions: Future
> Environment: 5.5.3 GA on Linux
> Reporter: Greg Haber
> Assignee: Barry LaFond
> Fix For: 7.7.1
>
>
> This is a longer term feature request - not expecting any near term resolution.
> It would be great if the web service as relational importer could have an option to model a web service with a single table representing both the request and response, instead of as separate tables as today. Not sure if it makes sense to allow this for heirarchical response web services, or only simple ones returning a flat schema.
> Whenever possible I always manually model web service connections this way because of the pros - but would be much better if the importer would do it for me.
> Pros:
> -Would avoid multiple queries to web service connector for a single web service call (since XML-Relational connectors don't support join pushdown) - simpler query plans
> -With that single call it lessens use/paves way for disabling the XML-Relational connector internal doc cache (which, at least in 5.0SP2, was a _big_ bottleneck in the field with concurrent calls to the same web service, if the web service takes more than a few seconds to respond - I believe because the whole doc cache is locked on both read and write, effectively resulting in single threaded and blocking behavior. Anyway, just speculating on the cause, but it is established that in 5.0SP2 that single-table web services were much faster than multi-table ones).
> -Would work in preview
> Cons:
> -Does not logically represent the way web services actually work
> -Confusing as it jumbles together elements from two XML docs in a single relational base table
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 1 month
[JBoss JIRA] (TEIIDDES-1111) Create a model(s) (view/source) based on the schema and type of data source provided
by Ramesh Reddy (Created) (JIRA)
Create a model(s) (view/source) based on the schema and type of data source provided
------------------------------------------------------------------------------------
Key: TEIIDDES-1111
URL: https://issues.jboss.org/browse/TEIIDDES-1111
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Reporter: Ramesh Reddy
There have been many requests from users in the recent past to auto-generate source and view models that can consume the XML coming in the specified in a schema file. The current XML document model, take in a XSD and maps the relational data into XML data. This request is exact opposite of it in the consuming side. The data is coming in as XML, need to expose them as relational.
I strongly believe that this needs to be done as part of TEIIDDES-1078, not create separate importers to minimize the user experience with modelling any XML data.
The data sources can File, SOAP service or Rest service currently, but may not be restricted to those.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 1 month