Informatica PowerExchange and Teradata are leading products in data integration and warehousing, each catering to distinct user needs. While Informatica PowerExchange is favored for its straightforward pricing and support capabilities, Teradata stands out for its powerful features and performance, offering high value even with a higher cost.
Features: Informatica PowerExchange specializes in real-time data integration and connectivity to various data sources, leveraging native transformation capabilities for efficient data management. Teradata excels with its advanced parallel processing and querying capabilities, ideal for handling large-scale data efficiently. Its architecture supports high-speed data management, ensuring optimized performance.
Room for Improvement: Informatica PowerExchange users seek enhancements in real-time features and less complexity in integration processes, along with more accessible pricing. Teradata users call for improved cloud services and better handling of unstructured data, alongside more competitive pricing options.
Ease of Deployment and Customer Service: Informatica PowerExchange provides versatile deployment options, both on-premises and cloud-based, generally receiving positive feedback for customer service, although availability could be improved. Teradata supports diverse deployment models, though optimal performance often requires proprietary hardware. Customer service feedback is average, with some reporting delayed responses.
Pricing and ROI: Informatica PowerExchange maintains a straightforward pricing approach but is perceived as costly, with users justifying expenses through optimized processes and reduced operational costs. Despite its higher price, Teradata is noted for delivering substantial returns in large-scale environments, balancing the cost with performance and efficiency benefits.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
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%.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
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.
This expansion can occur without incurring downtime or taking systems offline.
Teradata's scalability is great; it's been awesome.
Scalability is complex as you need to purchase a license and coordinate with Teradata for additional disk space and CPU.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
The workload management and software maturity provide a reliable system.
I find the stability to be almost a ten out of ten.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
If Teradata could provide a list of certified experts, that would be fantastic.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
We spent roughly $295,000 on setup costs.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
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 (%) |
---|---|
Informatica PowerExchange | 1.2% |
Teradata | 0.8% |
Other | 98.0% |
Company Size | Count |
---|---|
Small Business | 8 |
Midsize Enterprise | 3 |
Large Enterprise | 12 |
Company Size | Count |
---|---|
Small Business | 26 |
Midsize Enterprise | 12 |
Large Enterprise | 49 |
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
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.