Coming October 25: PeerSpot Awards will be announced! Learn more

Oracle Data Integrator (ODI) vs Perspectium DataSync comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Data Integrator (ODI) and Perspectium DataSync based on real PeerSpot user reviews.

Find out in this report how the two Data Integration Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Oracle Data Integrator (ODI) vs. Perspectium DataSync report (Updated: September 2022).
633,952 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pricing and Cost Advice
  • "We are running the community version right now, which can be used free of charge."
  • "StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."
  • "It has a CPU core-based licensing, which works for us and is quite good."
  • "There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."
  • "The pricing is good, but not the best. They have some customized plans you can opt for."
  • More StreamSets Pricing and Cost Advice →

  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • "ODI comes included when buying the cloud version of the Oracle database license."
  • "There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    633,952 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is really easy to set up and the interface is easy to use.
    Top Answer:We've seen a couple of cases where it appears to have a memory leak or a similar problem. It grows for a bit and then… more »
    Top Answer:We typically use it to transport our Oracle raw datasets up to Microsoft Azure, and then into SQL databases there.
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… 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… more »
    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… more »
    Ask a question

    Earn 20 points

    Comparisons
    Also Known As
    ODI
    Learn More
    StreamSets
    Video Not Available
    Overview

    StreamSets offers an end-to-end data integration platform to build, run, monitor and manage smart data pipelines that deliver continuous data for DataOps, and power the modern data ecosystem and hybrid integration.

    Only StreamSets provides a single design experience for all design patterns for 10x greater developer productivity; smart data pipelines that are resilient to change for 80% less breakages; and a single pane of glass for managing and monitoring all pipelines across hybrid and cloud architectures to eliminate blind spots and control gaps.

    With StreamSets, you can deliver the continuous data that drives the connected enterprise.

    Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine. 

    Oracle Data Integrator Features

    ODI has many valuable key features. Some of the most useful ones include:

    • Automatic documentation generation
    • Visualization of data flows in the interfaces
    • Customization of generated code
    • Automatic reverse-engineering of existing applications or databases
    • Graphical development and maintenance of transformation and integration interfaces
    • Robust data integrity control features, assuring the consistency and correctness of data
    • Powerful core differentiators
    • Heterogeneous ELT, declarative design and knowledge modules
    • Flexibility and modularity
    • Oracle Data Integrator repository
    • Topology navigator
    • Operator Navigator
    • Security Navigator
    • Integrator Console
    • ODI domains

    Oracle Data Integrator Benefits

    There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:

    • Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.
    • Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.
    • Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.
    • Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.
    • Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance. 
    • Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.

    Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”

    Ashok S., Applications Support Manager at a marketing services firm, mentions, "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."

    Perspectium DataSync is delivered as a comprehensive application in ServiceNow that allows sophisticated data synchronization scenarios to be created without coding. Your data is secure and private due to end-to-end and at-rest encryption, and the performance of your application instances are minimally impacted due to “push” data streaming. By utilizing a message queue, DataSync removes the need for data endpoints to be up and functional all the time, eliminating risk of data loss during intermittent outages at the endpoints. Additionally, due to our use of message brokering, your data stream can be flexibly re-configured without any change to the source - allowing you to flow your data to different targets with minimal impact, and automatic schema creation and maintenance of your data lake means data appears as soon as the schema changes.

    Offer
    Learn more about StreamSets
    Learn more about Oracle Data Integrator (ODI)
    Learn more about Perspectium DataSync
    Sample Customers
    Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Aetna, Blue Cross Blue Shield, GE, Rogers, Zurich
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company15%
    Insurance Company8%
    Government7%
    REVIEWERS
    Financial Services Firm29%
    Computer Software Company11%
    Retailer7%
    University7%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider13%
    Financial Services Firm13%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm24%
    Computer Software Company21%
    Energy/Utilities Company11%
    Comms Service Provider8%
    Company Size
    REVIEWERS
    Small Business14%
    Midsize Enterprise29%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business32%
    Midsize Enterprise13%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise5%
    Large Enterprise77%
    Buyer's Guide
    Data Integration Tools
    September 2022
    Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: September 2022.
    633,952 professionals have used our research since 2012.

    Oracle Data Integrator (ODI) is ranked 6th in Data Integration Tools with 11 reviews while Perspectium DataSync is ranked 29th in Cloud Data Integration. Oracle Data Integrator (ODI) is rated 8.2, while Perspectium DataSync is rated 0.0. The top reviewer of Oracle Data Integrator (ODI) writes "We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools". On the other hand, Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Oracle GoldenGate and Azure Data Factory, whereas Perspectium DataSync is most compared with AWS Database Migration Service and AWS Glue.

    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.