Looking for suggestions on ETL tools for DW/BI Project

View previous topic View next topic Go down

Looking for suggestions on ETL tools for DW/BI Project

Post  GregDC on Tue Mar 03, 2015 4:54 pm

Greeting again,

I am back with a very basic question: Given a DW with conformed dimensions, currently 4 factless fact tables, and Dimensions with a few SCD 1 and 2 attributes, is there a good set of tools to help in the ETL for the Warehouse on the market today? We are currently looking to build the DW on a Microsoft Server in the cloud somewhere with the Operational Data Stores possibly on local machines.

GregDC

Posts : 17
Join date : 2015-01-09

View user profile

Back to top Go down

Re: Looking for suggestions on ETL tools for DW/BI Project

Post  ngalemmo on Tue Mar 03, 2015 7:52 pm

You could certainly use what MSFT provides with SQL server (SSIS), its not a bad tool. Tools such as Informatica and Data Stage are very good but expensive compared to SSIS. There are also various open source solutions, but SSIS is free and there are plenty of people around who know the tool.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Thanks for the suggestion

Post  GregDC on Wed Mar 04, 2015 7:40 am

Thank you for suggesting SSIS. I am already looking at that one. I was just hoping that there was something "better" than "not bad"

GregDC

Posts : 17
Join date : 2015-01-09

View user profile

Back to top Go down

Re: Looking for suggestions on ETL tools for DW/BI Project

Post  TheNJDevil on Wed Mar 04, 2015 10:53 am

I've been using Pentaho Data Integrator (Kettle) and have been pleased with it's ease of use and cost.
But, if you already have SSIS, it is a great tool to do ETL in a Microsoft environment.

TheNJDevil

Posts : 68
Join date : 2011-03-01

View user profile

Back to top Go down

Again Thanks for the information

Post  GregDC on Wed Mar 04, 2015 11:21 am

Thanks for that plug for Pentaho. I had just sent off a note to our sales rep to see what he has to say about our situation. While we are building on MS SQL, I do not think they have installed the full SSXX package on the servers since we would be the first to seriously use them.

GregDC

Posts : 17
Join date : 2015-01-09

View user profile

Back to top Go down

Re: Looking for suggestions on ETL tools for DW/BI Project

Post  nick_white on Wed Mar 04, 2015 12:57 pm

SSIS is pretty good and given that you have already got a license for it it is effectively free (ignoring costs of hardware to run it on, etc.!)
Unless you have a specific requirement that SSIS won't meet then I can't imagine any other ETL tool would stack up against it in any business case you could put together - so I wouldn't waste time looking at other options, all they will give you is different ways of doing the same thing and the time you spend on product comparisons could be more productively spent building stuff with SSIS.

BTW - my background is in Informatica but I wouldn't recommend that given the limited scope of your ETL requirements. On the other hand, if you were going for a company wide data integration, DQ, and data lineage strategy with large numbers of heterogeneous sources and targets (and no budget constraints) then I'd definitely go for Informatica

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

SSIS is a ggod option

Post  juanvg1972 on Tue May 05, 2015 4:01 pm

I have used SSIS and other tools like PowerCenter or Oracle Data integartor, and in my experience SSIS is a good ETL tool, and you noly notice differences with PowerCenter or ODI when you work in a very large datawarehouse with performance problems and with a vast variety of source tables.

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

View user profile

Back to top Go down

Well, we finally made a decision

Post  GregDC on Thu May 07, 2015 7:46 am

After doing our testing, we decided to go with Wherescape for our ETL Tool, and Tableau for UI interface.

Thanks for all of your input.

GregDC

Posts : 17
Join date : 2015-01-09

View user profile

Back to top Go down

Re: Looking for suggestions on ETL tools for DW/BI Project

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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