Oracle Data Integrator (ODI) and Matillion Data Productivity Cloud compete in the data integration solutions category. Oracle Data Integrator seems to have the upper hand with its versatile EL-T architecture, which optimizes processing and integration across a wide range of data sources like SQL Server, Hadoop, and cloud services.
Features: Oracle Data Integrator leverages its EL-T architecture for efficient data processing without staging areas, utilizing the database's processing capabilities. It offers customizable and reusable integration strategies through its Knowledge Module system, making it robust for complex enterprise environments. It excels in integrating diverse data sources and supports various databases and cloud services. Matillion Data Productivity Cloud is noted for its user-friendly, GUI-based design that facilitates ease of use for less technical users, streamlining orchestration of data integration processes with a visual interface and drag-and-drop functionality.
Room for Improvement: Oracle Data Integrator could benefit from enhanced integration with version control tools beyond SVN, improved error messaging, and streamlined setup for new users. Its performance could improve in multiuser and data catalog integrations. Matillion's concurrent workload processing and backend integration require refinement. Its competitive pricing, integration with governance tools, and scalability for large environments need attention. Enhanced data streaming capabilities would also be advantageous.
Ease of Deployment and Customer Service: Oracle Data Integrator focuses on on-premises deployments but offers hybrid and cloud options. Its technical support is inconsistent, with complex integrations posing challenges. Matillion is primarily a public cloud solution, praised for its ease of setup and user-friendly interface. Its customer service is efficient and responsive, facilitated by accessibility through AWS Marketplace, leading to high user satisfaction.
Pricing and ROI: Oracle Data Integrator's pricing may be high for smaller companies, offering various licensing models with cost-effectiveness for complex integrations in large enterprises when bundled with other Oracle products. Matillion's consumption-based pricing can quickly increase with larger virtual machines, yet it provides flexibility. While both solutions offer significant ROI, Matillion's pricing model is more aligned with dynamic cloud operations.
Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.
They communicate effectively and respond quickly to all inquiries.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
Depending on the nature of data sets, volume, and mixture of different data, the scalability could be improved as manual code writing is still required.
The autoscale process works well, allowing the system to start another node automatically if the first machine reaches 80% capacity.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
The main areas for improvement are AI features and scalability.
Connections to BigQuery for extracting information are complex.
Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing clients in specific regions, like Spain.
The pricing is moderate, neither expensive nor cheap.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
The predefined connectors eliminate the need to write code for connectivity.
Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations.
The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.
Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 10 |
| Large Enterprise | 11 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 44 |
Matillion Data Productivity Cloud offers a user-friendly platform for seamless integration and dynamic data handling, favored for simplifying ETL processes with minimal coding and ensuring robust performance in complex data tasks.
Matillion Data Productivity Cloud integrates effortlessly with platforms like AWS, Snowflake, and SQL databases, providing tools for efficient data migration, transformation, and cloud warehousing. It supports large datasets with swift management, making it valued for its graphical interface that eases ETL processes for non-technical users. Automation features ensure scalability and dynamic data handling across diverse sources, while security and cost-effectiveness enhance its appeal. Enhancements in database connectivity, interface design, and multi-environment support would refine user experience, with growing demands for real-time data capture, SAP connectivity, and frequent API updates.
What are the most important features?In industries like finance, healthcare, and retail, Matillion Data Productivity Cloud is implemented for transforming data operations. Companies leverage it for its speed in data processing and integration capability, facilitating rapid adaptation to data-driven insights crucial in these sectors.
Oracle Data Integrator offers flexible EL-T architecture, optimizing processing with database capabilities. It supports diverse data sources, automates deployment, and provides efficient data transformations, making it suitable for data warehousing and complex data environments.
Oracle Data Integrator leverages EL-T architecture to enhance processing by utilizing database strengths. It integrates with a wide array of technologies, including RDBMS, cloud, and big data. The software's Knowledge Modules enable customizable integration strategies, accelerating development. With a user-friendly interface and automation features, it simplifies metadata management and supports real-time data warehousing. Key areas such as UI performance, integration, and real-time data capabilities require enhancements. Challenges include error handling, initial setup, and compatibility with platforms like Git, Azure, and IoT services. Improvements in metadata management, scalability, and user-friendliness are needed.
What are the most important features of Oracle Data Integrator?Organizations utilize Oracle Data Integrator primarily in data warehousing, handling data from ERP systems, EBS, Fusion, and cloud databases. It aids in creating data lakes, OLTP migrations, digital health initiatives, and automation tasks, ensuring seamless integration with databases like MySQL and SQL Server.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
