TrustRadius: an HG Insights company

Oracle Data Integrator (ODI) vs. SQL Server Integration Services

Save this comparison

Save this comparison

Oracle Data Integrator (ODI)

126 Reviews and Ratings

SQL Server Integration Services

259 Reviews and Ratings

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Oracle Data Integrator (ODI)

    Score6.2 out of 10
    		N/AOracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.N/A

    SSIS

    Score6.5 out of 10
    		N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
    Pricing
    Oracle Data Integrator (ODI)SSIS
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Oracle Data Integrator (ODI)SSIS
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Oracle Data Integrator (ODI)SSIS
    Considered Both Products
    Oracle
    zahit bogus
    Business Intelligence Consultant in Information Technology at EMO A.Ş (Information Technology & Services, 501-1000 employees)
    Chose Oracle Data Integrator (ODI)
    I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user …
    Incentivized
    Gurcan Orhan
    Senior Solutions Architect in Information Technology at Ekol Logistics (Information Technology and Services, 51-200 employees)
    Chose Oracle Data Integrator (ODI)
    Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
    • Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler.
    Incentivized
    Samir Patel, PMP
    SQL Development Team Lead in Information Technology at Allianz Asset Management (Investment Management, 1001-5000 employees)
    Chose Oracle Data Integrator (ODI)
    Oracle Data Integrator is a superior tool when dealing with Hyperion Planning and Essbase cubes and applications. The native connectors allow for easy data movement and transformations from one environment to the other. I do believe that Oracle Data Integrator is a very complex …
    Incentivized
    Microsoft
    Samir Patel, PMP
    SQL Development Team Lead in Information Technology at Allianz Asset Management (Investment Management, 1001-5000 employees)
    Chose SSIS
    SQL Server Integration Services is simpler to use and implement than Oracle Data Integrator. When it comes to resolving issues and getting community help SSIS is far superior. ODI has more complex functionality but would require more expert level staff for maintaining and …
    Incentivized
    zahit bogus
    Business Intelligence Consultant in Information Technology at EMO A.Ş (Information Technology & Services, 501-1000 employees)
    Chose SSIS
    I used the Pentaho Data Integration (PDI) ETL tool. The PDI ETL tool does not have a public user collection like the SQL Server Integration Services(SSIS) ETL tool. Therefore, you may not be able to find instant solutions for your problems. But it has advantages over the SSIS …
    Incentivized
    Verified User
    Chose SSIS
    Selection was done because of: 1. Lower Cost, 2. RDBMS was SQL Server and SSIS is tightly coupled for optimal performance
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Oracle Data Integrator (ODI)SSIS
    Data Source Connection
    Comparison of Data Source Connection features of Oracle Data Integrator (ODI) and SQL Server Integration Services
    Feature
    Oracle Data Integrator (ODI)
    9.6
    11 Ratings
    SQL Server Integration Services
    7.5
    53 Ratings
    Connect to traditional data sources9.911 Ratings8.853 Ratings
    Connecto to Big Data and NoSQL9.39 Ratings6.240 Ratings
    Data Transformations
    Comparison of Data Transformations features of Oracle Data Integrator (ODI) and SQL Server Integration Services
    Feature
    Oracle Data Integrator (ODI)
    9.9
    11 Ratings
    SQL Server Integration Services
    8.1
    53 Ratings
    Simple transformations9.911 Ratings8.553 Ratings
    Complex transformations9.911 Ratings7.752 Ratings
    Data Modeling
    Comparison of Data Modeling features of Oracle Data Integrator (ODI) and SQL Server Integration Services
    Feature
    Oracle Data Integrator (ODI)
    9.2
    11 Ratings
    SQL Server Integration Services
    7.4
    51 Ratings
    Data model creation9.310 Ratings8.627 Ratings
    Metadata management9.510 Ratings7.133 Ratings
    Business rules and workflow9.111 Ratings8.242 Ratings
    Collaboration8.510 Ratings7.338 Ratings
    Testing and debugging9.311 Ratings6.148 Ratings
    Data Governance
    Comparison of Data Governance features of Oracle Data Integrator (ODI) and SQL Server Integration Services
    Feature
    Oracle Data Integrator (ODI)
    9.1
    9 Ratings
    SQL Server Integration Services
    6.9
    41 Ratings
    Integration with data quality tools9.59 Ratings7.436 Ratings
    Integration with MDM tools8.77 Ratings6.436 Ratings
    User Ratings
    Oracle Data Integrator (ODI)SSIS
    Likelihood to Recommend
    8.0
    (29 ratings)
    8.0
    (53 ratings)
    Likelihood to Renew
    10.0
    (4 ratings)
    10.0
    (3 ratings)
    Usability
    -
    (0 ratings)
    9.3
    (8 ratings)
    Performance
    -
    (0 ratings)
    8.8
    (6 ratings)
    Support Rating
    -
    (0 ratings)
    8.2
    (7 ratings)
    Implementation Rating
    7.0
    (1 ratings)
    10.0
    (1 ratings)