Subject | Re: [firebird-support] Tool to Transfer Data From ERP DB to FB DB |
---|---|
Author | Nando Dessena |
Post date | 2007-02-19T08:50:52Z |
Dan,
D> I want to to start testing a proto-type data-warehouse based on FB and
D> was wondering if there is a pre-existing tool that can be configured
D> and scripted to transfer data for a Progress DB using OBDC to
D> Firebird. This tool would have be able to maintain and keep up to
D> date static DW tables such as customers and then do incremental adds
D> for invoiced sales that does not change. It would have to support
D> WHERE for source data and have a scripting language to decompose array
D> fields in the Progress db. It would have to run as a service in
D> Windows or Linux and create a report log of exceptions. Anything like
D> this?
you might want to take a look at our EDW
(http://www.ethea.it/eng_edw.asp), go through the docs and maybe play
with the demo. Doesn't run on Linux, though.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
D> I want to to start testing a proto-type data-warehouse based on FB and
D> was wondering if there is a pre-existing tool that can be configured
D> and scripted to transfer data for a Progress DB using OBDC to
D> Firebird. This tool would have be able to maintain and keep up to
D> date static DW tables such as customers and then do incremental adds
D> for invoiced sales that does not change. It would have to support
D> WHERE for source data and have a scripting language to decompose array
D> fields in the Progress db. It would have to run as a service in
D> Windows or Linux and create a report log of exceptions. Anything like
D> this?
you might want to take a look at our EDW
(http://www.ethea.it/eng_edw.asp), go through the docs and maybe play
with the demo. Doesn't run on Linux, though.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================