Any Open Source / free ETL out there?

Question

I was using Pentaho Data Integration even before Pentaho bought it and call it that. I have the last free version.

I went on their website recently to see if they had released another version only to find out my favorite open source etl is not much open anymore and not quite free.

Does any of you know of alternatives in affordable, easy to use ETL tools?

This is actually a duplicate of question Open Source Business Intelligence/DWH solutions. You will find there your answers. — Marian, Apr 05 '11 at 12:53
@Marian > The accepted answer in the question you are referring is Pentaho Data Integration.
I do ask for open source but also free and alternative to PDI.

I don't think that this question is a duplicate. — Nicolas de Fontenay, Apr 05 '11 at 14:09
The tools are free. THe linked question was asked by me. There are professional versions (with features like 24/7 support and so on) and the community edition that the professional version is based on. So the version if completely free and you still have the features you would expect. — DrColossos, Apr 05 '11 at 14:27

score 17 · Accepted Answer · edited Jul 31 '13 at 19:35

17

Isn't Kettle (Pentaho Data Integration Community Edition) still available without licensing fees?

Kettle 4.1 was released to the community as a stable release in fourth quarter of 2010. The community is currently working on a minor patch release to 4.1. Kettle continues to be a community supported product. Kettle may be a more appropriate tool in your sandbox or development environments.

However, in a production environment you may find that PDI Enterprise Edition with technical support from Pentaho more appropriate for your mission critical systems.

After discussion in comments below: Pentaho Data Integration (PDI - ak "Kettle") is still maintained (4.4 was release 2012-09) and Open Source. It can be downloaded from here: http://sourceforge.net/projects/pentaho/files/Data%20Integration

edited Jul 31 '13 at 19:35

Nicolas de Fontenay

1,873
2
18
36

answered Apr 05 '11 at 14:21

RobPaller

1,041
7
12

Hi @RobPaller ~ Can you give any more information about why this would be an appropriate tool? Linking is nice, but giving concrete explanations is better ;) – jcolebrand Apr 05 '11 at 17:09
the version I use is Kettle - Spoon Community Edition - 4.0.1.
I checked on Pentaho's website and what I see is PDI (aka Kettle) 30 days trial only.

That's what triggered my question. My concern is that Kettle is not maintained anymore and therefore I need to look for something else.
– Nicolas de Fontenay Apr 06 '11 at 09:22
@ndefontenay (a bit late, but...) Pentaho Data Integration (PDI - ak "Kettle") is still maintained (4.4 was release 2012-09) and Open Source. It can be downloaded from here: http://sourceforge.net/projects/pentaho/files/Data%20Integration/ – Jul 30 '13 at 19:48
This is great news! I wonder if I can change the correct answer actually... Let's see. – Nicolas de Fontenay Jul 31 '13 at 18:47
Yup. That works. – Nicolas de Fontenay Jul 31 '13 at 18:47

N West · Answer 2 · 2013-04-30T12:35:54.223

17

You could take a look at Talend Open Studio. The development environment runs inside of Eclipse, and there are many different kinds of database connectors & transformations. Also, given that it is an open source project, you can build your own connectors & transformations to share with other users (even commercial users) of Talend.

edited Apr 30 '13 at 12:35

answered Apr 05 '11 at 15:18

N West

330
1
8

1

Hi @NWest ~ Can you give any more information about why this would be an appropriate tool? Linking is nice, but giving concrete explanations is better ;) – jcolebrand Apr 05 '11 at 17:08
1

I found Talend a little difficult to learn and slow against huge datasets, but, pretty helpful overall. – randomx Apr 05 '11 at 18:31
I knew there was another player in this arena. Talend slipped my mind. – RobPaller Apr 05 '11 at 18:46
I will definitely have a look :) – Nicolas de Fontenay Apr 06 '11 at 09:24
Btw, what is the scripting language used by talend open studio ? – Steam Jan 14 '14 at 22:34

score 6 · Answer 3 · answered Apr 05 '11 at 20:54

6

This is more developer-centric than DBA centric, but I've heard good things about Rhino ETL. https://github.com/ayende/rhino-etl

answered Apr 05 '11 at 20:54

Jason v.

61
1

score 5 · Answer 4 · edited Jul 30 '13 at 19:10

I haven't used it because I use SSIS for my ETL needs, but have you checked out expressor Studio?

You could also check out ReactiveETL which is a rewrite of RhinoETL on CodePlex

If you are in an environment that is using SQL Server, you should have access to SSIS which is included with SQL Server and is able to attach to other databases using OLEDB or ODBC connections, so it doesn't have to be connecting to SQL Server in order to use it.

There have even been some presentations on using Powershell for ETL, one such presentation was put on by the App Dev Virtual Chapter of PASS.

For more details on that presentation check out the following link:

http://sev17.com/2010/06/22/powershell-etl-presentation/

score 1 · Answer 5 · edited May 31 '12 at 12:31

1

A few more...

edited May 31 '12 at 12:31

Leigh Riffel

23,854
16
78
152

answered May 31 '12 at 05:50

JustBeingHelpful

2,082
18
45
60

4

MacGyver - Do you have experience with any of these? Can you update the answer with some pros and cons? – Leigh Riffel May 31 '12 at 12:32
I haven't yet. I'm researching the tools out there for data warehousing and trying to choose one, so I'll include some more details once I have them organized. – JustBeingHelpful May 31 '12 at 15:23

score 1 · Answer 6 · answered Apr 05 '11 at 20:33

1

I played with Aptar a bit a number of years ago. I can't say how well they've stood the test of time, though.

answered Apr 05 '11 at 20:33

D. Lambert

1,057
1
8
8

score 0 · Answer 7 · answered Aug 01 '13 at 15:49

0

Depending on what you're trying to do Mirth Connect might be suitable, though it is more of a messaging engine than an ETL tool.

answered Aug 01 '13 at 15:49

George

101
1

Are you affiliated with them in any way? – András Váczi Aug 01 '13 at 16:41
I'm not, I've just been looking at it for Health XML Messaging and it seemed as if it might have wider applications. It certainly feels more polished than Pentaho. – George Aug 02 '13 at 13:43
Ah, OK. Usually, when recommending commercial tools, it is advisable to make your (non)-affiliation clear, this is why I asked. – András Váczi Aug 02 '13 at 14:23
Just to point out, Mirth Connect is open source. – JP. Dec 11 '14 at 19:31

Any Open Source / free ETL out there?

7 Answers7