Oracle Data Integrator (ODI) vs. Precisely Assure MIMIX

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

MIMIX is well suited when the organization requires a PLANNED Switch. MIMX will also work for any unplanned switches. However, this is not the most ideal situation and we have had to perform at least once when the older iSeries hardware failed, and the business transactions were on hold, impacting the business. MIMIX support was required to be called upon to assist. We were able to get the new iSeries online within an hour, so thankfully the outage to the business was miminal. It is important that any organization utilizing MIMIX schedule, prepare, and plan for the PLANNED Switch, at least once per year, if not twice per year.

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

• Redundancy - needs to be available at a moment's notice.
• Protection - the business would be greatly impacted, therefore protection of production systems is key to the business succeeding.
• Usability - needs to be user-friendly, easy to navigate and operate, as it will be required at any given time.

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

• Possible false sense of security for ransomware attacks.

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.

MIMIX is software built for availability. By its nature it is must be available. As long as the underlying system and communication network are available MIMIX is working. And if there are failures in either of those, MIMIX is designed to allow for a quick and resilient recovery once underly systems or communications are restored

Incentivized

I have never seen MIMIX itself be a performance bottleneck. However it is important to consider the network in overall performance of any remotely replicated systems. MIMIX can only replicate as fast as the network allows. But a strong capability of MIMIX is its ability to "buffer" its replication, so it can be sent without error as the network allows

Incentivized

Support is available and efficient. Response time is good and likelyhood of a quick resolutiion is high. However the mature solid product and proactive management tools, fortunately make support requirements relatively rare. The support for version upgrades is also strong, but again the basic upgrade process is usually straightforward and well documented.

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

Iterra is a less capable "little brother" product to MIMIX. Iterra like MIMIX was acquired by Vision, then subsequent owning organizations, now Precisely. Most of the original core Iterra functionality has been rolled into MIMIX. The Iterra product still exists but in a very limited role. Precisely and the previous owner has been very clear in their recommendation to standardize on MIMIX.

Incentivized

MIMIX works to its intended functionality. It provides real time data replication across multiple partitions and systems as defined. I have never witnessed any problems with MIMIX in scaling to larger systems or adding new data groups. In conjunction with the inherent scalability of IBMi scalability and configuration flexibillity are rather quick and easy.

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

• Successfully providing its intended use - HA/DR.
• Provides industry audit approval.
• Having an HA/DR solution in place is viewed as a positive by customers and potential customers for the marketing of the organization's core products and services.

Incentivized