Pentaho Data Integration and Analytics and Teradata compete in the data transformation and analytics sector. Pentaho has the edge with its ease of use and open-source model, whereas Teradata excels in handling large data volumes with high performance.
Features: Pentaho offers robust data transformation capabilities, an intuitive graphical interface, and extensive support for databases and files. Users benefit from its open-source nature and strong community support. Teradata is renowned for its superior data warehousing and analytics features, fast query execution, and parallel processing capabilities, making it ideal for enterprises requiring high scalability and concurrency.
Room for Improvement: Pentaho can refine its administration, logging, and support for additional connectors. Challenges with user-defined classes, backward compatibility, and documentation are noted. Teradata is seen as expensive, with a need to enhance cloud integration, scalability, and ease of use in specific features. Addressing unstructured data processing and improving training and documentation are potential areas for growth.
Ease of Deployment and Customer Service: Pentaho offers deployment flexibility for on-premises and hybrid environments, supported by a helpful community. Users mention limited technical support for non-enterprise editions. Teradata demonstrates strength in enterprise-level deployments, with comprehensive technical support praised for problem-solving, though agility and clearer documentation are requested.
Pricing and ROI: Pentaho's open-source model presents a cost-effective, flexible data integration tool, offering savings in ETL development time and positive ROI, though enterprise licenses can become expensive. Teradata's high price reflects its advanced performance capabilities, appealing to large enterprises that fully utilize its features. Users seek more affordable cloud options to complement Teradata's expensive offerings.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
Communication with the vendor is challenging
The customer support for Teradata has been great.
The technical support from Teradata is quite advanced.
Customer support is very good, rated eight out of ten under our essential agreement.
Pentaho Data Integration handles larger datasets better.
This expansion can occur without incurring downtime or taking systems offline.
Scalability is complex as you need to purchase a license and coordinate with Teradata for additional disk space and CPU.
Teradata's scalability is great; it's been awesome.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
The workload management and software maturity provide a reliable system.
I find the stability to be almost a ten out of ten.
Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
We spent roughly $295,000 on setup costs.
I find the drag and drop feature in Pentaho Data Integration very useful for integration.
Teradata's security helps our organization meet compliance requirements such as GDPR and IFRS, and it is particularly essential for revenue contracting or revenue recognition.
The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems.
| Product | Market Share (%) |
|---|---|
| Teradata | 0.8% |
| Pentaho Data Integration and Analytics | 1.7% |
| Other | 97.5% |
| Company Size | Count |
|---|---|
| Small Business | 17 |
| Midsize Enterprise | 16 |
| Large Enterprise | 25 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 49 |
Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
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.
