I've used Scriptella for some simple ETL tasks, straightforward table-to-delimited text sorts of things. Now I have a more complex task, and I'm not certain how to attack it with Scriptella.
1. Data is in a few different tables in an RDBMS, and I need to pull the data together into XML files.
2. For any given record, it might have a single row in table1, and 0-N rows in table2, and table3
3. The keys are all the same in tables1-3, but the keys for table4 are in a column in table2
In a nutshell, the data in the RDBMS has a hierarchy to it, but that hierarchy makes the relations in the RDBMS rather complex, and export will require some business logic, likely non-trivial.
Does this sound like something I should even contemplate attacking with Scriptella, or should I just to straight to a custom export program?
Thank you for any input.
Tod Olson <t...@uchicago.edu>
University of Chicago Library