kannappan velu
asked on
ETL Tool Comparision
I work in one of the largest health insurance company, in BI/Datawarehouse development. Currently we use Microsoft SQL Server Integration Services as ETL tool. Now we are plan to change or use the same etl. I participiate in an evalution process, where the options are to use Talend or change to Informatica 8.6 or Microsoft SQL Server Integration Services. Are there anyone out there that have had the oportunity to work with (or evaluated) two (or all) of these, and could give me some key points for consideration?
Our Databases:
MSSQL
Current ETL tools:
Microsoft SQL Server Integration Services
Front end
.Net/Salesforce
Our Databases:
MSSQL
Current ETL tools:
Microsoft SQL Server Integration Services
Front end
.Net/Salesforce
after all you'll have
SSIS (legacy), some "new" ETL SW, etc
if you have $$$ for new ETL SW and your SSIS packs can not do what you need
and you have $$$ to support this product and develop ETL packs -- maybe one of ~10 ETL tools is your goal ( see below links)
there are some extra improvements in SSIS specially sql 2014 +
The answer -- it depends on what you need\
check
https://www.gartner.com/reviews/market/data-integration-tools
https://adeptia.com/products/etl_vendor_comparison.html
http://www.etltools.net/etl-tools-comparison.html
https://www.etltool.com/etl-tools-comparison/
SSIS (legacy), some "new" ETL SW, etc
if you have $$$ for new ETL SW and your SSIS packs can not do what you need
and you have $$$ to support this product and develop ETL packs -- maybe one of ~10 ETL tools is your goal ( see below links)
there are some extra improvements in SSIS specially sql 2014 +
The answer -- it depends on what you need\
check
https://www.gartner.com/reviews/market/data-integration-tools
https://adeptia.com/products/etl_vendor_comparison.html
http://www.etltools.net/etl-tools-comparison.html
https://www.etltool.com/etl-tools-comparison/
For starters who is your client? I had three contract engagements with Optum/United Healthcare, which is a massive 'largest health insurance company', and the impression I got from that experience is you have a much better chance of throwing a butterfly in your neighbor's mailbox from a moving car with a crosswind then attempting to use new software, as they had a MASSIVE preference to software that was already in-house, tested, and approved by their lengthy approval process.
Also IBM and Informatica last I remember has a six-figure price tag.
Also IBM and Informatica last I remember has a six-figure price tag.
If any of your executives have a subscription to Garnter I'm sure they have a 'Magic Quadrant'-style assessment of ETL tools. Beyond that I'm not aware of very much out there that would be impartial.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
A Case for ETL Tools in Database Development