Devart Excel Add-ins vs. IBM InfoSphere Information Server vs. Oracle Data Integration Platform Cloud (discontinued)

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

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

For daily transactional information and customer data needs it has been an extremely fast and reliable system. Several thousand users are able to connect many third party tools and run a large number of extracts while still experiencing great performance. For smaller systems in use with limited user accounts this system is less appropriate due to maintenance resources required.

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

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• ODI uses ELT architecture, which enhances the load performance and is very scalable.
• ODI is platform independent. It supports all platforms, hardware and operating systems.
• It comes with pre-built integration, allowing immediate data replication, transformation, and data governance while ensuring data quality.

Incentivized

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

Incentivized

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Training and ramping up to learn all the Oracle specific intricacies.
• Security concerns with administering some of the tools to end users.

Incentivized

• Scale of implementation
• IBM techsupport

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

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

We are longtime ODI on-premise users. So, it was easy for us to migrate to the ODI cloud rather than implementing another solution.

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

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.

• Ability to setup reliable disaster recovery.
• Upgrades and performance monitoring tools are readily available.

Incentivized