TrustRadius: an HG Insights company

Oracle Data Service Integrator

Score8 out of 10

17 Reviews and Ratings

What is Oracle Data Service Integrator?

Oracle Data Service Integrator provides companies the ability to develop and manage federated data services for accessing single views of disparate information. Oracle Data Service Integrator is standards based, declarative, and enables re-usability of data services.

A mature product that gets the job done

Pros

  • A greatly improved experience since the redesign of the user interface to be more flow-based
  • It integrates well with Oracle GoldenGate
  • It reduces data integration costs across heterogeneous systems

Cons

  • 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

Return on Investment

  • 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

Alternatives Considered

Denodo and TIBCO Data Virtualization

Oracle Data Service Integrator Review By a Simple Engineer

Pros

  • 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.

Cons

  • While it is very easy to use when working with other Oracle products, it is not as easy to implement with other data storage providers.
  • The price is pretty high, which is normal for an Oracle product, but it doesn't appear to have as much bang for the buck.
  • The debugging process isn't as easy as we would like. It can be hard to debug failed instances.

Return on Investment

  • Oracle Data Service Integrator is a quite expensive product, and its costs can be absorbed in some time, but it does grant stability and great flexibility, especially when we need to import huge chunks of data.
  • ODSI has helped our data scientist and engineers develop products around what our customers need and want. This is done by using ODSI to track backend data movement

Alternatives Considered

BusinessObjects Data Integrator and Centerprise Data Integrator

Other Software Used

Oracle API Manager, Amazon CloudWatch, Oracle Advanced Analytics