[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1059) RFE for Teiid Designer - add a new importer similar to the Text File importer but for XML Documents
[
https://issues.jboss.org/browse/TEIIDDES-1059?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1059:
----------------------------------------
if XML file contains custom Namespace Prefixes, an XMLNAMESPACES('uri' AS prefix,
...) method is inserted in the XMLTABLE() function call as an initial parameter.
Example:
EXEC SampleSource.getTextFiles('sample.xml')) AS f,
XMLTABLE(XMLNAMESPACES('http://www.kaptest.com/schema/1.0/party' AS pty),
'/pty:students/student' PASSING XMLPARSE(DOCUMENT f.file)
COLUMNS firstName string PATH '/firstName', middleName string PATH
'/middleName', lastName string PATH '/lastName') AS A
RFE for Teiid Designer - add a new importer similar to the Text File
importer but for XML Documents
---------------------------------------------------------------------------------------------------
Key: TEIIDDES-1059
URL: https://issues.jboss.org/browse/TEIIDDES-1059
Project: Teiid Designer
Issue Type: Sub-task
Components: Import/Export
Affects Versions: 7.5
Reporter: Debbie Steigner
Assignee: Barry LaFond
Fix For: 7.6
Attachments: employee_info.xml, medsamp2011.xml, sample.xml,
teiid-connection-profile-type-dialog.png, teiid-data-file-import-options.png,
teiid-flat-file-source-page-1.png, teiid-flat-file-source-page-2_delimited.png,
teiid-flat-file-source-page-2_fixed.png, teiid-flat-file-source-page-3.png,
teiid-local-xml-file-connection-profile-wizard-page.png,
teiid-url-xml-file-connection-profile-wizard-page.png, teiid-xml-file-source-page-1.png,
teiid-xml-file-source-page-2.png, teiid-xml-file-source-page-3.png,
teiid-xml-file-source-page-4.png
Can an Importer similar to the text file importer be added to Teiid Designer. One that
would produce the same results as if it was manually done.
--
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