SSIS vs Open Source ETL
-
Hi guys,
I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the developers have been using open source. My boss is from Paris and he is trying to get all 3 cities to standardise on open source ETL as he thinks it is better.
I don't think this is a good idea and think SSIS is the best as it is specially designed to work with SQL Server. However could you guys please help me put some good arguments together to give to my boss so I can persuade him open source is not the best idea.
thanks very much in advance
-
_nzrdb6 (4/3/2012)
Hi guys,I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the developers have been using open source. My boss is from Paris and he is trying to get all 3 cities to standardise on open source ETL as he thinks it is better.
I don't think this is a good idea and think SSIS is the best as it is specially designed to work with SQL Server. However could you guys please help me put some good arguments together to give to my boss so I can persuade him open source is not the best idea.
thanks very much in advance
It will help if you mention the open source ETL.
-
_nzrdb6 (4/3/2012)
Hi guys,I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the developers have been using open source. My boss is from Paris and he is trying to get all 3 cities to standardise on open source ETL as he thinks it is better.
I don't think this is a good idea and think SSIS is the best as it is specially designed to work with SQL Server. However could you guys please help me put some good arguments together to give to my boss so I can persuade him open source is not the best idea.
thanks very much in advance
Do you have any solid argument to say that SSIS is better than the French solution?
SSIS is a great product but in my personal experience nothing beats a customized, well designed, well coded ETL solution.
My suggestion would be to familiarize yourself with the French solution then decide by yourself which one performns better and is allows for easier maintenance and further development.
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
_nzrdb6 (4/3/2012)
Hi guys,I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the developers have been using open source. My boss is from Paris and he is trying to get all 3 cities to standardise on open source ETL as he thinks it is better.
I don't think this is a good idea and think SSIS is the best as it is specially designed to work with SQL Server. However could you guys please help me put some good arguments together to give to my boss so I can persuade him open source is not the best idea.
thanks very much in advance
I suspect the Open Source ETL is Talend. It's a good product, I would not underestimate it.
Moreover, "best" means a lot of things:
* SSIS definitely has a learning curve: did you account for that?
* If your company has a lot of ETL procedures written with the OS tool, the conversion has its own cost.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply