A mature product that gets the job done
Rating: 6 out of 10
IncentivizedUse Cases and Deployment Scope
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.
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
Likelihood to Recommend
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.