IT Central Station is now PeerSpot: Here's why

Oracle Data Integrator Cloud Service vs Oracle Integration Cloud Service comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
Oracle Data Integrator Cloud Service vs. Oracle Integration Cloud Service
May 2020
Find out what your peers are saying about Oracle Data Integrator Cloud Service vs. Oracle Integration Cloud Service and other solutions. Updated: May 2020.
610,229 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
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved.""It is really easy to set up and the interface is easy to use.""In StreamSets, everything is in one place.""StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."

More StreamSets Pros →

"It's on the cloud, so it's scalable and quite easy to work with."

More Oracle Data Integrator Cloud Service Pros →

"The initial setup is easy.""In general, there were a lot of great utilities for working with files.""The out-of-box integration between Oracle and SAP is really beneficial""OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces.""The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive.""The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects.""The most valuable features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better.""Technical support responds quickly."

More Oracle Integration Cloud Service Pros →

Cons
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time.""If you use JDBC Lookup, for example, it generally takes a long time to process data.""We've seen a couple of cases where it appears to have a memory leak or a similar problem.""Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."

More StreamSets Cons →

"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."

More Oracle Data Integrator Cloud Service Cons →

"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release.""The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful.""There are a few features that we noticed are not in the cloud. There are some improvements needed. One example is the graphical user interface that needs to improve, it could be easier to use.""Oracle Integration Cloud Service can improve the downloading and uploading of files. I've submitted this issue to the Oracle Idea Labs. The issue is from the front end of Oracle Integration Cloud, we cannot download or upload a file directly or drag and drop it.""The solution is expensive.""It lacks configurable time-outs on connections. Configurable time-outs is an important nonfunctional property that it is currently missing. I have also written about it in an article, and I have also submitted some enhancement requests. Its visual designer could be a bit more responsive. It would also be good to get more XSLT editing capabilities.""The solution doesn't currently have a fully fledged workflow feature like they have in OIM.""The support and resources were lacking — they weren't there."

More Oracle Integration Cloud Service Cons →

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."
  • More StreamSets Pricing and Cost Advice →

    Information Not Available
  • "It has different licensing models. The most upfront and most transparent is the pay-as-you-go model. It also has a certain messages-per-hour limit. There is a certain amount that is charged per hour, and a certain number of messages are included in it, which you can scale up as you go. Its licensing is very competent and easy."
  • "In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."
  • "It specifies how much data you use and how much storage you require, among other things."
  • "The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."
  • More Oracle Integration Cloud Service Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    610,229 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or… more »
    Top Answer:It has a CPU core-based licensing, which works for us and is quite good.
    Top Answer:One room for improvement is probably the GUI. It is pretty basic and a lot of improvement is required there. In terms of… more »
    Top Answer:It's on the cloud, so it's scalable and quite easy to work with.
    Top Answer:It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot. When it comes to mapping… more »
    Top Answer:We use this solution to integrate ERP SCM cloud services with different applications. We are integrating all those… more »
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… more »
    Top Answer:The price could be better and they need to work on their licensing model to make it easier for users.
    Comparisons
    Also Known As
    Oracle ICS
    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 Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.

    Oracle Integration Cloud Service (ICS) delivers best in class “Hybrid” Integration. ICS is a simple and powerful integration platform in the cloud to maximize the value of your investments in SaaS and on-premises applications. It includes an intuitive web based integration designer for point and click integration between applications and a rich monitoring dashboard that provides real-time insight into the transactions, all running on a mature runtime platform on Oracle Public Cloud. ICS will help accelerate integration projects and significantly shorten the time-to-market through it's intuitive and simplified designer, an intelligent data mapper, and a library of adapters to connect to various applications.

    Offer
    Learn more about StreamSets
    Learn more about Oracle Data Integrator Cloud Service
    Learn more about Oracle Integration Cloud Service
    Sample Customers
    Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
    Amplifon
    Calix, Avaya, Land Lakes, Leader, PWC, Vale
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company28%
    Insurance Company10%
    Financial Services Firm10%
    Comms Service Provider9%
    VISITORS READING REVIEWS
    Computer Software Company39%
    Comms Service Provider21%
    University4%
    Retailer4%
    REVIEWERS
    Financial Services Firm43%
    Computer Software Company29%
    Recruiting/Hr Firm14%
    Pharma/Biotech Company14%
    VISITORS READING REVIEWS
    Computer Software Company45%
    Comms Service Provider10%
    Financial Services Firm7%
    Energy/Utilities Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise14%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise17%
    Large Enterprise56%
    REVIEWERS
    Small Business23%
    Midsize Enterprise18%
    Large Enterprise59%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise11%
    Large Enterprise75%
    Buyer's Guide
    Oracle Data Integrator Cloud Service vs. Oracle Integration Cloud Service
    May 2020
    Find out what your peers are saying about Oracle Data Integrator Cloud Service vs. Oracle Integration Cloud Service and other solutions. Updated: May 2020.
    610,229 professionals have used our research since 2012.

    Oracle Data Integrator Cloud Service is ranked 21st in Cloud Data Integration with 1 review while Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 11 reviews. Oracle Data Integrator Cloud Service is rated 7.0, while Oracle Integration Cloud Service is rated 8.0. The top reviewer of Oracle Data Integrator Cloud Service writes "Allows us to integrate different cloud services with different applications". On the other hand, the top reviewer of Oracle Integration Cloud Service writes "Good performance, easy integration, user-friendly, and helpful technical support". Oracle Data Integrator Cloud Service is most compared with Azure Data Factory, Informatica Cloud Data Integration, BMC Data Management for IMS and DB2 on zOS, SEEBURGER Business Integration Suite and IBM InfoSphere DataStage, whereas Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), Mule Anypoint Platform, Boomi AtomSphere Integration, Oracle GoldenGate and AWS Glue. See our Oracle Data Integrator Cloud Service vs. Oracle Integration Cloud Service report.

    See our list of best Data Integration Tools 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.