Oracle SOA Suite vs. Oracle Data Integrator (ODI)

In comparison to Open source products like Apache Camel and Mule ESB, Oracle ESB is more robust and offers better enterprise capabilities. However, the licensing costs are fairly prohibitive and are preventing widespread product adoption. At our university, we had already purchased the Oracle Campus Solutions ERP suite and hence had little problems integrating their OSB as well.

Incentivized

I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write

Incentivized

• It is lightweight and one can easily integrate with different applications, databases, JMS, or Web services through different protocols.
• It helps in building reusable, well-defined services.

Incentivized

• Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
• Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
• Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.

Incentivized

• Service implementation is not agile like microservices.
• The architecture is so complex and could result in higher latency with so many layers to traverse.
• Deployment of multiple web services in one session

Incentivized

• Oracle support is not the best when needing help with the system
• The documentation is also very poor and takes very long to generate
• Some parts of it are not intuitive to use and get hard to troubleshoot
• Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
• Like all Oracle products, cost is high

Incentivized

We have had not many issues with Oracle Service Bus and it's very stable for our requirements. It's highly available and helps us implement Tier1 applications on it.

Incentivized

It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.

It's an excellent enterprise service bus and has very stable features. We have been using it since 2008. We did hit into some issues. But, recreating the service helped fix many issues. Also, deployment to various environments was easy. Also, the plugin on Eclipse helps to build proxy and business services quick and easy.

Incentivized

We had some issues with MQ connectivity through OSB and our experience was poor with the support team. They do respond. But, it felt like we are ignored and we had bad support. We had to escalate and things used to get dragged for weeks before we get more quality questions on how to pursue investigation.

Incentivized

Mule ESB is an open source tool and would definitely cost less, however is not as sophisticated a product for the business functionality we need at US Cellular.. I have reviewed IBM WebSphere Message Broker, is very cumbersome and not very user friendly. Despite some of the license cost concerns, Oracle Service Bus stands out as an ideal Enterprise Service Bus solution at US Cellular

Incentivized

Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.

Incentivized

• We were able to increase efficiency in our lead generation process.
• Improved data driven decisions.
• Reduction in processing time by aligning resources on time.

Incentivized

• Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
• Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
• Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.

Incentivized