2018-07-11 08:32:00 UTC

Oracle Data Integrator (ODI) vs SSIS, which is better?


One of the most popular comparisons on IT Central Station is Oracle Data Integrator (ODI) vs SSIS.

One user says about Oracle Data Integrator (ODI), "It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."

Another user says about SSIS, "In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."

In your experience, which is better and why?

Guest
77 Answers
Vendor

I believe SSIS is only working with Microsoft SQL server but it's free.

Anyway, the best ETL tools on the market are Informatica and Oracle ODI. The distinction about these two products are:
For Informatica: It's been there for a long time. However it is architect as Extract, Transform, and Load. You need separate server for the tool.
For Oracle: It is Extract, Load, and Transform -> You can run everything on the database servers. This setup is more current (same as Hadoop).

2018-07-11 20:32:50 UTC11 July 18
Real UserTOP 5

If you are new in ETL/ELT tools, ODI can be quite complicated when you do exercises or implementation while it's very easy for you to create a package in SSIS tool in my point of view.

SSIS is ETL tool (Extract, Transform and Load)
ODI is ELT tool (Extract, Load and Transform)

Some factors you can consider to determine which tool is suitable to you
- Your environment: OS, database engine and which technologies your team is using. If you use SQL Engine and .NET, SSIS might be the choice. But you use Oracle or other open sources, ODI is the candidate.
- What kind of data sources do you usually proceed? If SQL Database, CSV file, Excel... go ahead with SSIS....
- Licensing cost although SSIS are ODI IDE are free but they are costed when you deploy them to PRODUCTION.

2018-07-20 04:45:23 UTC20 July 18
User

We are a SSIS shop, however currently we are implementing Oracle Fusion and during the implementation process it came to light that SSIS will not meet all our requirements. Some of the key once that I could remember from the top of my head are:
SSIS was not supporting event-based application integration
SSIS was not able to support UCM service as required to manage integration with Oracle Fusion.

The option was to use JCS, which required heavy custom coding, so we finally ended up using JCS-SX (was a cloud-based service as compared to JCS) and Dell Boomi to balance custom development and easy management of integration interfaces.

Hope this helps!

2018-07-14 17:56:22 UTC14 July 18
Vendor

I’d like to say to choose Pentaho as it not only allows you to do the Data Integration in various language environments but also Data Visualization in one platform.

2018-07-12 07:58:41 UTC12 July 18
Real UserTOP 20

the best tool I have found is Pentaho.

For the price, it meets everything Informatica does the learning curve to start is about 3 weeks

2018-07-11 19:29:43 UTC11 July 18
User

The answer is: it depends on your needs.

2018-07-11 15:33:11 UTC11 July 18
User

1 Oracle Data Integrator (ODI)
32,140 views 11,762 comparisons 32SOLUTION VIEWS

2 SSIS
23,943 views 16,245 comparisons 3 reviews 1,562 followers 6.0 average rating

2018-07-11 13:06:46 UTC11 July 18
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SSIS and other solutions. Updated: November 2019.
378,397 professionals have used our research since 2012.
Sign Up with Email