Oracle Data Integrator (ODI) vs SSIS

Oracle Data Integrator (ODI) is ranked 1st in Data Integration Tools with 30 reviews vs SSIS which is ranked 3rd in Data Integration Tools with 3 reviews. The top reviewer of Oracle Data Integrator (ODI) writes "ODI is a flexible tool that can adapt to fit your business, not the other way around". The top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS and Oracle GoldenGate. SSIS is most compared with Informatica PowerCenter, Talend Integration Suite and Oracle Data Integrator (ODI). See our Oracle Data Integrator (ODI) vs SSIS report.

Oracle Data Integrator (ODI)

SSIS

17870

Oracle Data Integrator (ODI)

Based on 30 reviews.

18482

SSIS

Based on 3 reviews.

Most Helpful Review

Rob Naastepad

Architect (Datawarehouse / BI) at a financial services firm

The topology gives me total freedom in switching between technologies / ETL agents.

The speed in which we create/generate our ETL mappings has increased by at least a factor of four as compared to Oracle Warehouse Builder.

RajeshHegde

Assistant Manager at a tech services company

In addition to the ETL challenges, it allows us to do DBA activitities, scripting and many other tasks.

For the full version of the SQL Server, SSIS, SSAS and SSRS will come as additional features for free. Hence, my organization need not spend extra... Read more »

Oracle data integrator %28odi%29 vs. ssis report from it central station 2018 05 04 thumbnail

Download Free Report

Find out what your peers are saying about Oracle Data Integrator (ODI) vs SSIS and others in Data Integration Tools.

Download now

269,560 professionals have used our research since 2012.

Quotes From Members Comparing Oracle Data Integrator (ODI) vs SSIS

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.The installation of the client ODI Studio is easy.Besides loading data, we do most of our transformations in ODI.In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases.It is an ETL tool, which does the extract, transform, and load. Read more »	Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.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. Read more »
Cons
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasonsThe stability of the software could be improved. Sometimes, the software just crashes. If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value.I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.Technical Support could be better.It needs easier security.I would only point out some minor bugs or glitches in the development interface (ODI studio).The GUI is a very old-fashioned, fat client that should be renewed. Read more »	You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price.SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Read more »

Pricing and Cost Advice
Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good.It is very expensive (after bargaining). Read more »	t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base. Read more »

Download Free Report Find out what your peers are saying about Oracle Data Integrator (ODI) vs SSIS and others in Data Integration Tools. Download now 269,560 professionals have used our research since 2012.
Ranking
RANKING	1st out of 59 In Data Integration Tools Views 32,057 Comparisons 11,970 Reviews 34 Followers 1,435 Avg. Rating 8.1	3rd out of 59 In Data Integration Tools Views 24,514 Comparisons 17,374 Reviews 3 Followers 1,536 Avg. Rating 7.0
Top Comparisons
Top Comparisons	Informatica PowerCenter vs. Oracle Data Integrator (ODI) Compared 23% of the time. SSIS vs. Oracle Data Integrator (ODI) Compared 19% of the time. Oracle GoldenGate vs. Oracle Data Integrator (ODI) Compared 17% of the time. See more Oracle Data Integrator (ODI) competitors »	Informatica PowerCenter vs. SSIS Compared 26% of the time. Talend Integration Suite vs. SSIS Compared 14% of the time. Oracle Data Integrator (ODI) vs. SSIS Compared 13% of the time. See more SSIS competitors »

Also Known As
Also Known As	ODI	SQL Server Integration Services
Website/Video
Website/Video	Oracle	Microsoft
Overview
Overview	Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.	SSIS is a package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations, that you assemble using either the graphical design tools that SQL Server Integration Services provides, or build programmatically. You then save the completed package to SQL Server, the SSIS Package Store, or the file system, or you can deploy the ssISnoversion project to the SSIS server. The package is the unit of work that is retrieved, executed, and saved.
OFFER
Learn more about Oracle Data Integrator (ODI) Learn More	Learn more about SSIS Learn More
Sample Customers
Sample Customers	Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University	PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
Top Industries
Top Industries	REVIEWERS Financial Services Firm 24% Retailer 12% University 12% Hospitality Company 12% VISITORS READING REVIEWS Financial Services Firm 17% Comms Service Provider 10% Energy/Utilities Company 7% Healthcare Company 6%	VISITORS READING REVIEWS Financial Services Firm 18% Healthcare Company 10% Government 8% Insurance Company 8%
Company Size
Company Size	REVIEWERS Small Business 32% Midsize Enterprise 10% Large Enterprise 59% VISITORS READING REVIEWS Small Business 16% Midsize Enterprise 11% Large Enterprise 73%	REVIEWERS Small Business 45% Midsize Enterprise 9% Large Enterprise 45% VISITORS READING REVIEWS Small Business 14% Midsize Enterprise 16% Large Enterprise 70%

Download Free Report

Find out what your peers are saying about Oracle Data Integrator (ODI) vs SSIS and others in Data Integration Tools.

Download now

269,560 professionals have used our research since 2012.

We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.