Hi Matt,
I am not sure the structure of your XML file properly. As per previous comments you need XML map and that can be created using XML mapper very easily and also you can move the data in the tags into another table.
In short, you need XML map to register XML library for your XML file. If you have three tables properly placed in the XML file then you are able to register three tables into metadata easily. I have done this using 4.7 DI studio and used XML V2 type template. I am not sure about limitations with 4.2 DI Studio. Sure it will work.
Below link gives the some information around XML structure and XML map.
https://blogs.sas.com/content/sgf/2016/06/24/tips-for-reading-xml-files-into-sas-software/
Kind Regards,
Rama
I didn't write any code at all. XML Mapper auto generates the XML Map file for your XML file, as along structure is same there is no need to touch the XML map.
DI Studio represents that XML file as table in metadata and use Table loader to load into SQL Server directly. No code.
I do not have experience in Talend but I believe it is similar except Map file is generated inside the Talend tool. when XML file structure changes then you still need readjust the XML Map transformation according to new structure in Talend .
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.