SSIS vs. Oracle Data Integrator

Question

Currently I am a Data Engineer that works mainly with SSIS. While reading about the ETL tools available in the market, i found that Oracle has its own ETL tool called ODI (Oracle Data integrator). I searched for an unbiased comparison between the Oracle Data Integrator and SSIS. I didn't find any article about that. There are some biased article such as :

• ETL Tools Comparison of Oracle ODI & Microsoft SSIS Tool -Dec 2014
• Competitive Comparison of SQL Server 2008 Integration Services

Based on Stackoverflow questions, there are about 16000 questions about SSIS while ODI has about 200 questions. Which mean that SSIS is more popular.

Is there any unbiased comparison between both technologies? And what are the services that ODI provides and that are not found in SSIS?

Please I am not looking for personal opinions, I need an unbiased answer

Answer 1

If you are looking for an unbiased comparison of SSIS and ODI, you can refer to the following research paper published in 2017. It contains a comparison of five popular ETL tools including SSIS and ODI.

Comparison is in terms of performance optimisation, metadata management, cost, supported language, real time updates and other criterias.

• A Comparative Review of Data Warehousing ETL Tools with New Trends and Industry Insight