We changed our name from IT Central Station: Here's why

Oracle Data Integrator (ODI) vs SSIS comparison

Cancel
You must select at least 2 products to compare!
SSIS Logo
Read 8 SSIS reviews.
26,629 views|20,405 comparisons
Comparison Summary
Question: Which ETL tool would you recommend to populate data from OLTP to OLAP?
Answer: We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator). But OLAP exporting wasn't in our scope until now.
Featured Review
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SSIS and other solutions. Updated: January 2022.
564,643 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.""All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.""The scalability is great. It's one of the reasons we chose the solution."

More Oracle Data Integrator (ODI) Pros →

"The interface is very user-friendly.""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.""The script component is very powerful, things that you cannot normally do, is feasible through C#.""It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world.""It's a competent product.""The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.""The technical support is very good.""The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

More SSIS Pros →

Cons
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects.""The resource management aspect of the solution could be improved.""There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."

More Oracle Data Integrator (ODI) Cons →

"The solution could improve by having quicker release updates.""When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console.""I would like to see better integration with Power BI.""The solution could improve on integrating with other types of data sources.""Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion.""It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well.""It's a legacy tool, that is nearing the end of its useful life.""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."

More SSIS Cons →

Pricing and Cost Advice
  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

  • "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."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    564,643 professionals have used our research since 2012.
    Answers from the Community
    RajneeshShukla
    author avatarAThiré
    User

    There are two products I know about
    * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables
    . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs

    There are many other pure ETL tools
    * ERWIN has a nice one ,

    author avatarPhil Wilkins (Capgemini)
    Consultant

    Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution.


    The other question is how up to date do you want your OLAP DB to be? Goldengate is a good answer if you're looking to minimize latency, but it can be expensive. ODI is less expensive but better suited to bulkier data sets.  If an Oracle product wasn't the option I'd probably consider something like Informatica.

    author avatarKaroly Krokovay
    User

    Hi Rajneesh,
    yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hitachi-overview.pdf

    And a short description of the community edition: https://www.predictiveanalyticstoday.com/pentaho-community-edition/

    And the download link: https://community.hitachivantara.com/s/article/downloads

    You can ask more from the great community: https://forums.pentaho.com/

    Regards
    Károly

    author avatarStefan Schäfer
    User

    We usually use Talend.
    Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

    author avatarGaryM
    Real User

    As someone mentioned, if you're purely Oracle shop and staying that way then there's value with prioritizing Oracle tools.  However, let me contrast that with this caveat...


    Consider expectations for tool and vendor longevity. Oracle has a long history of retiring and/or replacing tools leaving customers in the cold with prior versions/tools (I've been burned multiple times by Oracle product retirements or replacements including OWB, Oracle Designer2k, Oracle Express, Oracle OEDW, their purchase of Sagent ETL which as later abandoned).


    But I would also consider these questions and relative prioritization:  


    What is your organization's plans for moving to other database technologies?  


    Where is your org going with on-prem versus cloud solutions?  How important are PaaS versus IaaS solutions?  


    Where is your current staff's expertise?  


    Prioritize mature over immature tools. 


    How many sources do you have?  What are their technologies and does the integration tool support them?


    Is it just moving data from a single ERP such as Oracle EBS to Olap? When you say Olap what do you mean by that?  Are you talking Oracle Olap product or something else?  That makes a really big difference of course - if your ETL tool doesn't support your source(s) and target(s) then it shouldn't be considered.


    Given the industry's trajectory, I myself would highly prioritize PaaS solutions over others.

    author avatarYeap Jiun Aing
    Real User

    What is the OLAP that you are using? Hosted in Cloud or on-premise? 


    The target DB should have its tool to extract data.

    author avatarEfe Dagistanli
    User

    Pentaho is a really nice tool if opensource is the only option. 


    Please think about issues such as upgrade and disaster in the future. These operations are very easy in Pentaho.


    I can only suggest one thing for replication and that is Qlik. (ex-Attunity).

    author avatarRajneeshShukla
    Real User

    Hi Karoly, Thanks for your input. community: https://forums.pentaho.com/ is not allowing new registrations for new users. I guess they accept queries from customers only and not from any one. Do you know any other forum, community, SMEs contacts who can help on queries?

    Questions from the Community
    Top Answer: 
    Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that come… more »
    Top Answer: 
    What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer: 
    I know I'm late to the party but here are my comments to this. I would ask what version of ODI are you running, but for the most part it doesn't matter. I will say that since you are saying Mapping… more »
    Top Answer: 
    SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer: 
    It comes bundled with other solutions, which makes it difficult to get the price on the specific product.
    Ranking
    5th
    Views
    20,934
    Comparisons
    14,507
    Reviews
    6
    Average Words per Review
    778
    Rating
    8.7
    4th
    Views
    26,629
    Comparisons
    20,405
    Reviews
    7
    Average Words per Review
    659
    Rating
    7.9
    Comparisons
    Also Known As
    ODI
    SQL Server Integration Services
    Learn More
    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 about SSIS
    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
    REVIEWERS
    Financial Services Firm32%
    University9%
    Hospitality Company9%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company39%
    Comms Service Provider16%
    Financial Services Firm8%
    Government5%
    REVIEWERS
    Financial Services Firm24%
    Retailer10%
    Insurance Company10%
    Comms Service Provider7%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider16%
    Financial Services Firm10%
    Government6%
    Company Size
    REVIEWERS
    Small Business32%
    Midsize Enterprise13%
    Large Enterprise55%
    REVIEWERS
    Small Business29%
    Midsize Enterprise22%
    Large Enterprise49%
    Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SSIS and other solutions. Updated: January 2022.
    564,643 professionals have used our research since 2012.

    Oracle Data Integrator (ODI) is ranked 5th in Data Integration Tools with 6 reviews while SSIS is ranked 4th in Data Integration Tools with 8 reviews. Oracle Data Integrator (ODI) is rated 8.6, while SSIS is rated 7.8. The top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, Oracle GoldenGate, Talend Open Studio and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, SAP Data Services and AWS Glue. See our Oracle Data Integrator (ODI) vs. SSIS report.

    See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

    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.