[JBoss JIRA] (TEIIDDES-1059) RFE for Teiid Designer - add a new importer similar to the Text File importer but for XML Documents
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIIDDES-1059?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1059:
----------------------------------------
Split the XML import into File and URl based import. URL version generates a different
SQL containing invokeHttp and will look like:
SELECT
A.COMMON AS COMMON, A.BOTANICAL AS BOTANICAL, A.ZONE AS ZONE, A.LIGHT AS LIGHT, A.PRICE
AS PRICE, A.AVAILABILITY AS AVAILABILITY
FROM
(EXEC PlantWSProcedures.invokeHttp('GET', null,
'http://www.w3schools.com/xml/plant_catalog.xml')) AS f,
XMLTABLE('/CATALOG/PLANT' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS COMMON
string PATH '/COMMON', BOTANICAL string PATH '/BOTANICAL', ZONE string
PATH '/ZONE', LIGHT string PATH '/LIGHT', PRICE string PATH
'/PRICE', AVAILABILITY string PATH '/AVAILABILITY') 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,
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-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
4755
days inactive
4755
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Barry LaFond (Commented) (JIRA)