The nature Tony of code 8sharing8 between users of this group, is Free. I share my code, others share their code. No one puts everything they've written on pickwiki So it's entirely possible someone has written a general purpose ETL to go into Universe
I'm confused about your mention of Dict items because I don't see how you use Dict items for Uploading. I see how you use them for Downloading. Maybe you could give an example of why you would read the Dict for an upload. -----Original Message----- From: Tony Gravagno <[email protected]> To: u2-users <[email protected]> Sent: Fri, Oct 26, 2012 4:13 pm Subject: Re: [U2] UPLOAD not DOWNLOAD > From: Wjhonson > 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. A "solution" starts with a good definition of a "problem" - and that means something a little more specific than "data". Are you looking for a general purpose import from SQL Server? Oracle? MySQL? CSV? Outlook? Excel? A web service? Your cell phone contacts? I've written import/export routines for all of these and more. But they're all a little different. What's common is that I pull the data from a source into a middle tier and then push the data to whatever the target is. That's your ETL concept. Most people think of data movement to/from MV in terms of direct access between environments, the Extraction and Loading part with little consideration for Transformation. To me, the U2 box is just one end of the equation, it's not the middle tier. The U2 side of things uses just grunt code or dict items that any of us here can write. The only thing new about any such ETL project is the "other" side, which just requires some knowledge about how to integrate with whatever that "other" side is. Once someone internalizes that, the rest is fairly easy with Any remote endpoint - and most of these "how do I ETL with 'ProductX' questions become unnecessary. You probably also want to clarify that you want something free. There are commercial offerings from FusionWare, BlueFinity, and others. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms/about _______________________________________________ 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
