We use a small in-house C#/Uniobject tool which: Extracts data from U2 using DBTOXML function. Uses SQLXMLBulkLoad object to put that into a SQL "operational data store". We run classic ETL process on that and build star schemas etc
I like it because ... it's simple, quick and relatively efficient, takes advantage of U2 to clean the data before it gets to XML. Takes advantage of XML schema and transformations to get the data into SQL. Stuart -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Debster Sent: Wednesday, 29 July 2009 2:50 PM To: U2 Users List Subject: [U2] What ETL? Just takin' a survey What ETL tool do you use - Why do you like it? Ease of use "Anyone can hold the helm when the sea is calm". -Syrus Publilius _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
