A mature product that gets the job done
January 23, 2019

A mature product that gets the job done

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Service Integrator

Oracle Data Service Integrator was primarily used by our Finance Department for budgetary purposes.The Data Warehouse portion holds the potential to be a rich source of information for all departments across the entire organization, once we show them how powerful it can be. Federated Data Services allow users easy access to a single point of reference for disparate information across the enterprise.
  • 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
  • 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
  • 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
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.
Once Oracle Data Service Integrator is set up properly, it is quite simple to snatch data from a myriad of disparate sources and put them into a single repository. Due to cost factors, it is not for the faint of heart; however, if you can handle it, the benefits will quickly outpace the initial investment. To take full advantage of the power of ODSI, I would recommend the training that Oracle provides.