[JBoss JIRA] (TEIIDDES-1059) RFE for Teiid Designer - add a new importer similar to the Text File importer but for XML Documents
by Barry LaFond (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1059?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1059:
----------------------------------------
For the attached medsamp2001.xml file the following SQL should be generated if "/MedlineCitationSet/MedlineCitation" is entered as the XQuery expression and pmid, journal and title columns are defined with corresponding PATH values
SELECT
title.pmid AS pmid, title.journal AS journal, title.title AS title
FROM
(EXEC getMeds.getTextFiles('medsamp2011.xml')) AS f,
XMLTABLE('/MedlineCitationSet/MedlineCitation' PASSING
XMLPARSE(DOCUMENT f.file)
COLUMNS pmid biginteger PATH 'PMID', journal string PATH 'Article/Journal/Title', title string PATH 'Article/ArticleTitle') AS title
> 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, teiid-flat-file-source-target-page.png, teiid-flat-file-type-selection-page.png, teiid-xml-data-file-import-settings.png, teiid-xml-data-file-import-source-page.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