hi John, Depending what you are looking for, - a generic "ETL" tool where you define 1) Extract data from a defineable source (remote sql, csv-xls-dbf-xml-json files, webservice result , ...) with extendable method 2) Transform the received clob to internal UV data representation (iconv, mv'ed representation, build multi-part unique key, ...) 3) Load into U2 files (update one or more uvfiles into a Transaction (db transaction + application transaction))
That's not a "routine" that's complex tool with a lot of params and subroutines :-p I have it, writen in SB+, require SB+ at runtime, but it's not free. Please let me know if you can be interested. ----------------- - Anyway, If you search routines to import, write one record on one uvfile per "received record", from some specific data source I'm ready to share my experience (sql, dbf, csv, mdb, xls, xml, ...). Please put some detail of the source. regards Manu Wjhonson <[email protected]> a écrit : Does anyone have a robust ETL routine for loading data *into* Universe (not out from it). Something like Cedarville's DOWNLOAD but in reverse ? Before I roll my own. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
