Alooma vs. Oracle Data Integration Platform Cloud (DIPC)

Very appropriate for managing an ELT stack -- Alooma handles the 'E' and 'L' pieces very well. Due to the way transformation is setup, it is more on the lightweight side of things and thus works for this kind of stack. For more traditional ETL stacks, Alooma would probably not be the right fit.

Incentivized

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

• Transformation of data before entering the data warehouse -- allows for a consistent/understandable schema for analytics teams.
• Adding of additional data sources: Alooma has a large library of pre-built, common 3rd party vendors for which data is often needed to be ETL-ed.

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

• More tools on managing the data warehouse itself. Although great on the ingest and transformation of data, more help provided by the tool on managing the outputs would be welcome.
• Increase possibilities in the transformation step, rather than single event transformations.

Incentivized

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

Incentivized

Haven't used the alternatives, since Alooma was one of the earlier ones to the market. From a cursory viewing, however, the features seem to match relatively similarly.

Incentivized

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

• Allowing for additional data sources to more automation capability around monitoring the business is a huge ROI

Incentivized

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

Incentivized