ETL module for Servicemix.

["Rally, Varun" <va...@fiserv.com>]

Hello All,

 

I want to achieve ETL (Extract Transformation Load) functionality with
ServiceMix. Can somebody let me know any module that let us achieve this
functionality?

 

Regards,

Varun Rally

 

Re: ETL module for Servicemix.

[Gert Vanthienen <ge...@skynet.be>]

Varun,

... or you could have a look at 
http://activemq.apache.org/camel/etl.html and related page to build 
something similar with the servicemix-camel component.

Gert

Bruce Snyder wrote:
> On Tue, Apr 22, 2008 at 11:43 PM, Rally, Varun <va...@fiserv.com> wrote:
>   
>> Hello All,
>>
>>
>>
>>  I want to achieve ETL (Extract Transformation Load) functionality with
>>  ServiceMix. Can somebody let me know any module that let us achieve this
>>  functionality?
>>     
>
> The best way to achieve this currently is probably using the
> servicemix-bean component. The servicemix-bean component is not
> designed for ETL specifically, but it allows you to write POJOs to do
> anything you like and to intercept message exchanges to work with
> messages. Inside of your POJOs you could extract data from a
> datasource, transform it and reload it all using Java.
>
> Bruce
>   

Re: ETL module for Servicemix.

[Bruce Snyder <br...@gmail.com>]

On Tue, Apr 22, 2008 at 11:43 PM, Rally, Varun <va...@fiserv.com> wrote:
> Hello All,
>
>
>
>  I want to achieve ETL (Extract Transformation Load) functionality with
>  ServiceMix. Can somebody let me know any module that let us achieve this
>  functionality?

The best way to achieve this currently is probably using the
servicemix-bean component. The servicemix-bean component is not
designed for ETL specifically, but it allows you to write POJOs to do
anything you like and to intercept message exchanges to work with
messages. Inside of your POJOs you could extract data from a
datasource, transform it and reload it all using Java.

Bruce
-- 
perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'

Apache ActiveMQ - http://activemq.org/
Apache Camel - http://activemq.org/camel/
Apache ServiceMix - http://servicemix.org/
Apache Geronimo - http://geronimo.apache.org/

Blog: http://bruceblog.org/