Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.
N/A
Precisely Assure MIMIX
Score9.9 out of 10
N/A
Assure MIMIX from Precisely (formerly Syncsort) offers IBM i high availability (HA) and disaster recovery (DR) for companies worldwide, from small businesses to global enterprises, who can use Assure MIMIX to prevent data loss and eliminate planned and unplanned downtime. Assure MIMIX provides scalable real-time replication with options for automating administration, monitoring and alerting, customizable switch automation, and a graphical…
N/A
Pricing
Oracle Warehouse Builder
Precisely Assure MIMIX
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Oracle Warehouse Builder
Precisely Assure MIMIX
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Features
Oracle Warehouse Builder
Precisely Assure MIMIX
Data Source Connection
Comparison of Data Source Connection features of Oracle Warehouse Builder and Precisely Assure MIMIX
Feature
Oracle Warehouse Builder
9.5
5 Ratings
13% above category average
Precisely Assure MIMIX
-
Ratings
Connect to traditional data sources
10.05 Ratings
00 Ratings
Connecto to Big Data and NoSQL
9.02 Ratings
00 Ratings
Data Transformations
Comparison of Data Transformations features of Oracle Warehouse Builder and Precisely Assure MIMIX
Feature
Oracle Warehouse Builder
10.0
5 Ratings
21% above category average
Precisely Assure MIMIX
-
Ratings
Simple transformations
10.05 Ratings
00 Ratings
Complex transformations
10.04 Ratings
00 Ratings
Data Modeling
Comparison of Data Modeling features of Oracle Warehouse Builder and Precisely Assure MIMIX
Feature
Oracle Warehouse Builder
8.2
5 Ratings
3% above category average
Precisely Assure MIMIX
-
Ratings
Data model creation
10.04 Ratings
00 Ratings
Metadata management
6.04 Ratings
00 Ratings
Business rules and workflow
9.04 Ratings
00 Ratings
Collaboration
8.94 Ratings
00 Ratings
Testing and debugging
7.04 Ratings
00 Ratings
Data Governance
Comparison of Data Governance features of Oracle Warehouse Builder and Precisely Assure MIMIX
The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
MIMIX is clearly the best IBMi solution for most high availability and disaster recovery situations. It provides rock-solid replication and agile ability to switch quickly. In its earlier days, some organizations used it as a primary daily system backup method. With the advent of Ransomware, this is no longer advisable. The strength of MIMIX real-time replication becomes a weakness if IBMi data becomes infected. As in any real-time replication product, at that point, two systems are infected.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We used MIMIX for its role for iSeries high availability. We used Double Take by Vision Solutions for our production Windows environment. MIMIX is designed for iSeries, and Double Take was designed for Windows. We had VMware virtual environment, running multiple VMs for production ERP Lawson M3, now Infor. Both MIMIX and Double Take played the role well for what needed to be done. Without either MIMIX or DoubleTake, the business would have been impacted.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info