

Oracle Data Integrator (ODI) and Alteryx are prominent contenders in the data integration and analytical processing software category. Alteryx has the edge due to its user-friendly interface and expansive data preparation tools.
Features: Oracle Data Integrator boasts powerful integration capabilities, ELT architecture, and scalability. It supports extensive data transformation and offers rich customization options. Alteryx is praised for its ease of use, drag-and-drop functionality, and robust data preparation tools. It integrates data blending, spatial, and predictive analytics.
Room for Improvement: ODI could improve real-time integration features, simplify interface setup, and expand ETL tool support. Alteryx needs enhancements in data visualization, pricing strategies, and server stability to offer better integration features.
Ease of Deployment and Customer Service: ODI primarily offers on-premises deployment with responsive but variable technical support. Alteryx provides flexible deployment across on-premises and cloud environments and straightforward setups, yet its customer service requires improvement in handling complex deployments.
Pricing and ROI: ODI is moderately priced, offering good value, especially when combined with Oracle systems. While Alteryx is considered expensive, impacting scalability for small businesses, both products deliver substantial ROI due to their automation effectiveness and data handling efficiency.
Tasks that earlier took hours in Excel or SQL are now completed in minutes.
From a time-saving perspective, we saved 60 to 75 percent of the human workforce needed and eliminated other disparate ETL tools, ultimately saving us over 600,000 dollars.
Alteryx helps familiarize managers with artificial intelligence-driven possibilities.
Customer support from Alteryx has been amazing.
they do have a website for resolving doubts and accessing helpful resources, including various tools and filters.
I contacted customer support once or twice, and they were quick to respond.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
Alteryx is scalable for most enterprise analytics and data preparation workloads.
Suggestions for improvements in Alteryx include areas for increasing efficiency, particularly in processing telemetry data, which involves dealing with large volumes of unstructured data.
Alteryx is scalable, and I would give it eight out of ten.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
I have not encountered any lagging, crashing, or instability in the system during these three months of usage.
Alteryx is a reliable tool, but it is also very heavy, requiring good laptop configurations, a minimum of 8GB RAM, and a recent processor such as i10.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections.
The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system.
The additional features that Alteryx needs to work on to make it more competitive include better collaboration and easier integration through API.
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.
It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame.
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
The price is very high, with licensing typically starting around five thousand dollars plus user per year.
We found excellent use cases for automation through Alteryx, which provided the means to reduce operational costs and streamline the build of ETL pipelines without extensive coding.
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
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.
Alteryx not only represents data but also supports decision-making by suggesting the next steps.
Analysts who do not have any coding experience can still work on the transformation and preparation of data, which is quite useful.
Alteryx includes built-in tools such as drive time analysis and linear regression, which are much harder to achieve in standard BI tools such as Power BI or Tableau.
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) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly.
| Product | Mindshare (%) |
|---|---|
| Alteryx | 1.2% |
| Oracle Data Integrator (ODI) | 2.9% |
| Other | 95.9% |


| Company Size | Count |
|---|---|
| Small Business | 46 |
| Midsize Enterprise | 20 |
| Large Enterprise | 73 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 44 |
Alteryx enhances efficiency by automating data preparation and transformation through a user-friendly drag-and-drop interface, catering to non-technical users and business professionals. It supports data blending, predictive analytics, and diverse data integration capabilities.
Alteryx streamlines data manipulation and complex transformations, benefiting industries such as finance and marketing with its ability to connect to multiple data sources and automate workflows. The platform supports analytics and machine learning model building, reducing manual efforts in ETL processes. Despite its capabilities, improvements are needed in database connectivity, pricing flexibility, and cloud service integration. Users desire enhancements in reporting features, visualization, and technical support to optimize its full potential. Machine learning and predictive analytics features require advancements to improve user experience and broaden accessibility through better connectors and reduced licensing costs.
What are Alteryx's key features?
What benefits and ROI should be looked for in reviews?
In finance and marketing, organizations leverage Alteryx to automate data tasks, connect diverse sources, and generate analytics models and dashboards efficiently. Its no-code approach aids in rapid data preparation, cleansing, and analysis, empowering business users to engage in predictive and prescriptive analytics effectively.
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 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.