Oracle Data Service Integrator vs. SAP Replication Server

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.

Incentivized

I asked questions about a warm standby and multicast replication. We ended up using bi-directional replication and a warm standby db. Having 3 or more live OLTP DB's where each was read-write was going to be difficult to manage for contention if the same table was being updated. We stuck with an easier solution to have only two OLTP's, and then used additional DB's as read-only DW's.

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

• guaranteed delivery
• high availability
• scalable
• low latency
• data transformation

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

• Data Reconciliation Functionality.

Incentivized

SAP support has been outstanding. They have quick response times and always meet their SLAs. Any time we have an issue that needs to be researched they are able to get back to us quickly with resolution.

Incentivized

While we tested and evaluated multiple data service providers, we came to choose Oracle Data Service Integrator since our infrastructure was so heavily dependent on Oracle software. The implementation would be easier and the difference in the number of features and performance wasn't enough to sway us in another direction.

Incentivized

Hands down Sybase has the best replication

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

• A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.

Incentivized