Oracle Data Service Integrator vs. Presto

Since adopting Oracle Data Service Integrator (ODSI) over a year ago, we have been able to integrate multiple sources of data from multiple sources into a very robust process. This has really helped our developers and data scientists research and improve our user data. They are able to use the ODSI built-in architecture to create tools and processes that make their quality of life much better.

Incentivized

Simple stories & templates work nicely - like for our Insider program. Stories that include a lot of images may be challenging to create & have look appealing.

Incentivized

• Very easy to use. Very easy to just grab data when needed.
• Very robust and has so many features to move and transform data.
• Functionality is very easy to implement with other Oracle data products.

Incentivized

• Linking, embedding links and adding images is easy enough.
• Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
• Organizing & design is fairly simple with click & drag parameters.

Incentivized

• If not bundled with other products, the price can be prohibitively expensive
• SAP connectors tend to be a little expensive and slightly difficult to use
• The audit module had some difficulties debugging failed instances

Incentivized

• Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
• Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
• UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.

Incentivized

Denodo is great, but if you want or need local storage and/or replication, then Oracle Data Service Integrator is the way to go. ODSI allowed us to perform data aggregation and run reports against locally stored data, which was a must in our environment. Oracle is the clear winner when it comes to choosing a mature product that gets the job done.

Incentivized

I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark

Incentivized

• It provided terrific bulk data movement and data transformation services which we desperately needed
• It allowed to reduce development costs and lower the total cost of ownership among disparate architectures
• The enterprise edition's ELT allowed us to generate native code for wildly varied RDBMS

Incentivized

• Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
• Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
• Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.

Incentivized