[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1078) Create a Web Service or XML Source Importer
[
https://issues.jboss.org/browse/TEIIDDES-1078?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1078:
----------------------------------------
Included screen shots of what I've got so far.
- Piggybacked the "Flat File Source >> Source and View Models" import
option
- Inserted a page for user to select CSV or XML format
- Re-used the Source Selection (connection profile) page but filtered for *.xml files
- The Import Settings dialog includes a sample of the Generated SQL Statement for the View
that will be generated on FINISH
This SQL is based on the format defined in the Teiid docs:
- XMLTABLE([<NSP>,] xquery-expression [<PASSING>] [COLUMNS <COLUMN>,
... )] AS name
- COLUMN := name (FOR ORDINALITY | (datatype [DEFAULT expression] [PATH string]))
Create a Web Service or XML Source Importer
-------------------------------------------
Key: TEIIDDES-1078
URL: https://issues.jboss.org/browse/TEIIDDES-1078
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export, Web Services Support
Affects Versions: 7.5
Reporter: Barry LaFond
Assignee: Barry LaFond
Priority: Critical
Fix For: 7.6
Attachments: teiid-flat-file-type-selection-page.png,
teiid-xml-data-file-import-settings.png, teiid-xml-data-file-import-source-page.png
The Web Services Source use-case is still cumbersome due to the nature of explaining how
users should write SQL statements for view tables using the "invokeHTTP()"
methods generated in the New Model Wizard.
Would be nice to package a new imported that simplifies this process as much as the
"Flat File Source" importer did.
--
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