It's not free, but take a look at Pervasive Data Integrator - it can connect to / translate XML, RBase, SQL Server..... There's a 30-day free trial.
http://ww2.pervasive.com/Integration/Products/Pages/PervasiveDataIntegrator.aspx Dawn Hast [email protected] wrote on 05/01/2009 10:05:21 AM: > Does anyone have any experience, tips, etc., about importing XML > files containing data from different but related record structures? > > IOW, each XML data file contains various levels of One-To-Many > (Parent-To-Child, if you will) related records. > > This is part of an ETL (Extraction, Translation, Load) process, > wherein RBase will be the intermediate tool, i.e. XML => RBase => > SQL Server/web-based vertical app?. > > > I have found various free/free-to-try tools, but nothing that suits > my needs to a ?T?. I can get the XML data into a big flat > file/spreadsheet and one tool even splits the different (Parent, > Child) record structures into CSV files, but doesn?t preserve a > common linking, PK/FK value. > > If I can?t find a free, easy-to-use tool, that does everything I > want - don?t suppose I?m asking for too much, there! - I?m thinking > about importing the denormalized flat file with all its nulls and > doing something with GROUP BY?s and/or DELETE DUPLICATES. > > I?d appreciate any information anyone might have.I find > > > Thanks, > Steve in Memphis > DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
