TrustRadius: an HG Insights company

Oracle Cloud Infrastructure vs. Oracle Data Integrator (ODI)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    OCI

    Score8.3 out of 10
    N/AOracle Cloud Infrastructure (OCI) is Oracles's infrastructure-as-a-service (IaaS) platform which combines the utility of public cloud with the granular control, security, and predictability of on-premises infrastructure.N/A

    Oracle Data Integrator (ODI)

    Score8.8 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
    Pricing
    OCIOracle Data Integrator (ODI)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    OCIOracle Data Integrator (ODI)
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    OCIOracle Data Integrator (ODI)
    Considered Both Products
    Oracle
    No answer on this topic
    Oracle
    No answer on this topic
    Key User Insights
    Would buy again
    93%
    Would buy again
    119 Answers
    90%
    Would buy again
    9 Answers
    Delivers good value for the price
    97%
    Delivers good value for the price
    111 Answers
    88%
    Delivers good value for the price
    7 Answers
    Happy with the feature set
    91%
    Happy with the feature set
    117 Answers
    100%
    Happy with the feature set
    10 Answers
    Lived up to sales and marketing promises
    90%
    Lived up to sales and marketing promises
    76 Answers
    100%
    Lived up to sales and marketing promises
    7 Answers
    Implementation went as expected
    90%
    Implementation went as expected
    104 Answers
    100%
    Implementation went as expected
    8 Answers
    Features
    OCIOracle Data Integrator (ODI)
    Infrastructure-as-a-Service (IaaS)
    Comparison of Infrastructure-as-a-Service (IaaS) features of Oracle Cloud Infrastructure and Oracle Data Integrator (ODI)
    Feature
    Oracle Cloud Infrastructure
    7.9
    138 Ratings
    4% below category average
    Oracle Data Integrator (ODI)
    -
    Ratings
    Service-level Agreement (SLA) uptime8.6133 Ratings00 Ratings
    Dynamic scaling8.4133 Ratings00 Ratings
    Elastic load balancing8.2122 Ratings00 Ratings
    Pre-configured templates6.9122 Ratings00 Ratings
    Monitoring tools7.3133 Ratings00 Ratings
    Pre-defined machine images7.6120 Ratings00 Ratings
    Operating system support7.4132 Ratings00 Ratings
    Security controls8.3134 Ratings00 Ratings
    Automation7.996 Ratings00 Ratings
    Data Source Connection
    Comparison of Data Source Connection features of Oracle Cloud Infrastructure and Oracle Data Integrator (ODI)
    Feature
    Oracle Cloud Infrastructure
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.6
    11 Ratings
    14% above category average
    Connect to traditional data sources00 Ratings9.911 Ratings
    Connecto to Big Data and NoSQL00 Ratings9.39 Ratings
    Data Transformations
    Comparison of Data Transformations features of Oracle Cloud Infrastructure and Oracle Data Integrator (ODI)
    Feature
    Oracle Cloud Infrastructure
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.9
    11 Ratings
    20% above category average
    Simple transformations00 Ratings9.911 Ratings
    Complex transformations00 Ratings9.911 Ratings
    Data Modeling
    Comparison of Data Modeling features of Oracle Cloud Infrastructure and Oracle Data Integrator (ODI)
    Feature
    Oracle Cloud Infrastructure
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.2
    11 Ratings
    15% above category average
    Data model creation00 Ratings9.310 Ratings
    Metadata management00 Ratings9.510 Ratings
    Business rules and workflow00 Ratings9.111 Ratings
    Collaboration00 Ratings8.510 Ratings
    Testing and debugging00 Ratings9.311 Ratings
    Data Governance
    Comparison of Data Governance features of Oracle Cloud Infrastructure and Oracle Data Integrator (ODI)
    Feature
    Oracle Cloud Infrastructure
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.1
    9 Ratings
    12% above category average
    Integration with data quality tools00 Ratings9.59 Ratings
    Integration with MDM tools00 Ratings8.77 Ratings
    Best Alternatives
    OCIOracle Data Integrator (ODI)
    Small Businesses
    IBM Cloud Object Storage
    Score9 out of 10
    Skyvia
    Score10 out of 10
    Medium-sized Companies
    IBM Cloud Bare Metal Servers
    Score8.7 out of 10
    IBM InfoSphere Information Server
    Score10 out of 10
    Enterprises
    SAP on IBM Cloud
    Score9 out of 10
    SolarWinds Task Factory
    Score8.3 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    OCIOracle Data Integrator (ODI)
    Likelihood to Recommend
    8.2
    (150 ratings)
    8.0
    (29 ratings)
    Likelihood to Renew
    9.2
    (7 ratings)
    10.0
    (4 ratings)
    Usability
    8.7
    (15 ratings)
    -
    (0 ratings)
    Availability
    8.8
    (4 ratings)
    -
    (0 ratings)
    Performance
    8.7
    (28 ratings)
    -
    (0 ratings)
    Support Rating
    9.0
    (20 ratings)
    -
    (0 ratings)
    In-Person Training
    9.0
    (3 ratings)
    -
    (0 ratings)
    Online Training
    9.0
    (3 ratings)
    -
    (0 ratings)
    Implementation Rating
    9.2
    (4 ratings)
    7.0
    (1 ratings)
    Configurability
    9.2
    (3 ratings)
    -
    (0 ratings)
    Contract Terms and Pricing Model
    8.3
    (11 ratings)
    -
    (0 ratings)
    Ease of integration
    9.2
    (3 ratings)
    -
    (0 ratings)
    Product Scalability
    9.2
    (4 ratings)
    -
    (0 ratings)
    Professional Services
    10.0
    (6 ratings)
    -
    (0 ratings)
    Vendor post-sale
    10.0
    (2 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    10.0
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    OCIOracle Data Integrator (ODI)
    Likelihood to Recommend
    Oracle
    As per our usage Oracle Cloud Infrastructure for almost 6 years hosting 500 + customers I can say its well suited application for any small scale to larger scale application as it can handle that capacity and provide more reliable cloud service only if you need any messaging service like pub/sub or sqs better to consider other services.
    Incentivized
    Read full review
    Oracle
    Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on). I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good. It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
    Incentivized
    Read full review
    Pros
    Oracle
    • Oracle Cloud Infrastructure has a generous free tier, moreso than other hyperscalers, with an always-free tier that guarantees certain products are always free
    • Oracle Cloud Infrastructure allows you to size VMs with differing combinations of CPU and RAM, which is contrary to other hyperscalers that have specific pre-defined combinations only
    • Oracle Cloud Infrastructure regularly provides free certification exam offers
    Incentivized
    Read full review
    Oracle
    • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
    • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
    • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
    • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
    Incentivized
    Read full review
    Cons
    Oracle
    • Navigating the UI takes lots of getting used to. It reminds me of older GCP (just to get used to where everything is).
    • Permission for different things always seemed to be more difficult than it really needed to be. Once you got them set up you were good but updating anything or creating new permissions for just about anything took longer than I thought it should.
    • Based on how the buttons were laid out, it was pretty easy to delete all of your DNS records, and backing them up was not as intuitive as I'd like with the UI, but it was easy to do using a script.
    Incentivized
    Read full review
    Oracle
    • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
    • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
    • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
    Incentivized
    Read full review
    Likelihood to Renew
    Oracle
    Reliability: Very dependable and stable OCI services have been for the business operations.Performance: The speed and efficiency of OCI in meeting their computing and storage needs.Scalability: The ease and effectiveness of scaling resources up or down to accommodate changing demands.Security: The robustness and effectiveness of OCI's security features in protecting their data and applications.
    Incentivized
    Read full review
    Oracle
    It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
    Read full review
    Usability
    Oracle
    The services & products in Oracle Cloud Infrastructure needs more improvement to beat other Cloud service providers. The price is good & Security processes are good. We are requiring to put more effort in supporting this Oracle Cloud Infrastructure than other Cloud service providers. Probably better ways are there but is not super easy to find or not super available
    Read full review
    Oracle
    No answers on this topic
    Reliability and Availability
    Oracle
    Yeah sometimes we had to face unplanned outages due to underlying infrastructure issues, so not every time,e but once in a while we face issues with availability. But the good thing is we have redundancy with DR setup and multi region so we can manage.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Performance
    Oracle
    From the start, I was surprised by response times and image quality accessing windows VMs with RDP. GCP, Azure and -many offerings in AWS- don't perform this speed. Also, that's evident in the quality of Infrastructure Management Team, because I just received one warning regarding a region failure, what confirms that's a mature platform.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Support Rating
    Oracle
    Overall it is amazing, there is always room for improvement. We have weekly updates that tend to slow the program used more and more. We had to change some reports within Oracle because the others wouldn’t load. This is tied to our payroll and the delays are causing many time constraint issues and panic. We have to create a new report when one breaks. Otherwise awesome!
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    In-Person Training
    Oracle
    Effective training provided, much data productivity while doing training
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Online Training
    Oracle
    detailed and easy to understand.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Implementation Rating
    Oracle
    Very much satisifed with the Oracle Support team during the implementation and Migration of applications
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Alternatives Considered
    Oracle
    We used Microsoft Azure and Docker earlier and faced some difficulties like Microsoft Azure and Docker. Occasionally, the generation of large images can delay deployment. It is also necessary for me to admit that Microsoft Azure and Docker have a somewhat steep learning curve. Proper paperwork needs to be there. Docker has issues with performance on a number of platforms. On the other hand, OCI is easy to deploy and easy to understand.
    Incentivized
    Read full review
    Oracle
    I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
    Incentivized
    Read full review
    Contract Terms and Pricing Model
    Oracle
    was not part of initial purchase team. Anyways, i think unit pricing and billing frequency is good compared to other Cloud service providers, when it comes to Cloud Capital expenditure & Operational expenditure. Would be more interested in exploring more options where customers can get more cost relaxations on trying out new cloud services in Oracle Cloud Infrastructure for example a new App or a feature
    Read full review
    Oracle
    No answers on this topic
    Scalability
    Oracle
    We have hosted around 500 + customers on this cloud so till day not faced any major issues, so we can use it for any kind of products and it can hold the load and easily scale based on need.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Professional Services
    Oracle
    Services & Infra wise is ok to use & host applications & services. Security wise also good for a Cloud service provider. It is a interesting area to explore & using it for day to day needs can be further improvised in future probably. Modern day Services like AI and Machine learning could be improved
    Read full review
    Oracle
    No answers on this topic
    Return on Investment
    Oracle
    • Oracle Cloud helps us build and deploy apps quickly, getting our products out the door faster.
    • With real-time insights from Oracle Cloud, we can give customers personalized experiences that boost satisfaction.
    • Migrating to Oracle saves us cash on hardware and maintenance, which we can use for innovation and growth.
    Incentivized
    Read full review
    Oracle
    • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
    • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
    • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
    Incentivized
    Read full review
    ScreenShots

    OCI Screenshots

    Screenshot of Oracle Cloud Infrastructure Global FootprintScreenshot of 2-5x Faster Performance vs On-premises and Other Clouds (Storage Review)Screenshot of One Cloud for the Most Intensive Enterprise and Infra-heavy WorkloadsScreenshot of Gen 1 vs Gen 2 Cloud AdvantageScreenshot of Always Free Services