Devart Excel Add-ins vs. Oracle Data Service Integrator

Devart Excel Add-ins is really good for data comparison of one database table against another database table. There are plenty of times where the business users need help understanding with their Power BI data models are not connecting correctly and I use this tool to break down the differences between the tables they are trying to connect.

Incentivized

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

• Devart Excel Add-in supports connectivity with various databases - which really helps to customize and massage data.
• Since data is available in cloud, it is easily accessible everywhere.
• It can also be integrated with SSIS components making it possible to resolve complex problems.

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

• The data pump feature breaks sometimes
• The profile usage monitoring is slow
• The event profiler is delayed

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

Devart Excel stacks up very well against its alternatives. It has significant advantages as it keeps getting an update. Features are very much suitable for smaller organizations. For larger organizations the features cannot be used directly because of the size of the company and more native requirements of IT software requirements.

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

• The data compare option saves our dev team a lot of time
• The documenter feature is nice to use for explaining table definitions
• The event profiler is great for usage metrics

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