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

ETL Tools please

4 posters

Go down

ETL Tools please Empty ETL Tools please

Post  TheNJDevil Thu Dec 05, 2013 1:12 pm

Are their any ETL tools that will provide the most flexibility with the least amount of custom coding (as in little to none) out of the box?  I'm just looking for a list of tools that others have used that didn't require a lot of custom programming to get enterprise quality ETL processes (a large variety of sources, audit capability, possibly data lineage, ect).

Any assistance would be great.  Thanks.

TheNJDevil

Posts : 68
Join date : 2011-03-01

Back to top Go down

ETL Tools please Empty Re: ETL Tools please

Post  tgrady Thu Dec 05, 2013 3:19 pm

Hi,

I have worked with Information Builders and am currently developing with Talend.  Both are pretty solid etl development tools and most likely will provide you with what you are looking for.  

There is going to be some high level coding (i.e. using visual components) involved along with some coding at the lower level be it in the Focus language for the Information Builders tool or java for the Talend.  That said, the coding at the Focus/java language level was not all that much and each tool provides for a very easy way to incorporate the code.

Hope this helps and good luck on your search.

TG

tgrady

Posts : 7
Join date : 2011-06-22

Back to top Go down

ETL Tools please Empty Different ETL solutions options

Post  juanvg1972 Tue May 05, 2015 12:29 pm

It depends on what you can invest:

Expensive and good tools I know:

- Informatica PowerCenter
- Oracle Data Integrator (ELT)

Econmic options:

- Pentaho Data Integration
- Talend.

I like vwey much Pentaho DI , it has a lot of predefoned steps and it's turning well to big data

Some criteria to evaluate ETL tools (in spanish language):

http://blog.mbitschool.com/2015/03/consideraciones-en-la-seleccion-de-una.html

juanvg1972

Posts : 25
Join date : 2015-05-05

Back to top Go down

ETL Tools please Empty Re: ETL Tools please

Post  ron.dunn Tue May 05, 2015 10:10 pm

Have you considered Data Warehouse Automation, rather than generic ETL?

There is a comprehensive list of products, as well as a set of evaluation criteria for dimensional modelling automation, on our web site:

http://ajilius.com/competitors/

ron.dunn

Posts : 55
Join date : 2015-01-06
Location : Australia

http://ajilius.com

Back to top Go down

ETL Tools please Empty Re: ETL Tools please

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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