Re: Data Migration / ETL Tools

Check out: http://www.databee.com/

Adar Yechiel
Rechovot, Israel

John Bossert wrote:
>
> I'm supporting two environments, Integration and Production.
> Typically, our client services folks implement a "configuration" (set
> of records in a set of tables) in Integration, perform their
> acceptance tests and then "migrate" the configuration to Production.
> Migration, however, largely consists of manually re-typing the
> information. Obviously, this results in a lot of duplicated effort
> and potential errors due to fat fingering the keyboard...
>
>
>
> I'm looking for some sort of ETL tool that would allow me to 1)
> extract a set of records from Integration; 2) put them in some sort of
> "scratchpad" area where they can be reviewed/modified by an analyst
> (not a database person, ergo XML or the like would be a win); and then
> 3) load the modified scratchpad into production.
>
>
>
> Many of the tables' primary keys are sequence-based, so there would
> also need to be a means of mapping the PKs on Integration records to
> the PKs in Production (retained, so a once-mapped PK doesn't need to
> be remapped for each migration). And, there needs to be a way to
> identify/skip previously migrated (parent) records.
>
>
>
> Additionally, the customer would like to be able to "clone" existing
> configurations, modify, and import back into the same environment.
>
>
>
> Are there any (preferably open source or low-cost) tools that would
> support this kind of process? All comments/suggestions/pointers welcomed.
>
>
>
> --
>
> John Bossert
>
> Data Architect
>
> Hubspan, Inc.
>
> 206.838.5400 x1218
>
>
>

--
http://www.freelists.org/webpage/oracle-l