Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Open source ETL vs commercial ETL

Go down

Open source ETL vs commercial ETL Empty Open source ETL vs commercial ETL

Post  dellsters Thu Jul 16, 2009 12:56 am

Anybody have experience with open source etl like Talend or Pentaho? They are becoming more popular, and I was wondering what advantages/ disadvantages of open source vs commercial etl tools. Any downsides of using open source for SOX or HIPAA?

dellsters

Posts : 39
Join date : 2009-02-11

Back to top Go down

Open source ETL vs commercial ETL Empty Re: Open source ETL vs commercial ETL

Post  ngalemmo Thu Jul 16, 2009 1:38 am

I don't see how open source or not has any bearing on SOX or HIPAA. (I mean, so called 'SOX compliant' organizations do a lot of reporting from spreadsheets...).

Open source is usually less expensive, but one thing to understand is that ETL tools, on the whole, is a small market and the talent pool of knowlegedable developers is even smaller (relative to other application development skill sets). So even if you find an open source tool that will do the job that you need, you will probably be faced with having to train people to use it and burn a lot of time reworking processes as you become more skilled with the tool.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Open source ETL vs commercial ETL Empty Re: Open source ETL vs commercial ETL

Post  coombsj Tue Oct 13, 2009 2:26 pm

I'm also curious about peoples experience with TalenD or Pentaho? We are looking into providing a SaaS environment, would TalenD be a good candidate? I ask because of the lack of API to manipulate the definition of the jobs before they are run.

Thanks,
Jonathan

coombsj

Posts : 2
Join date : 2009-10-13

Back to top Go down

Open source ETL vs commercial ETL Empty Re: Open source ETL vs commercial ETL

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum