HVR Software vs Informatica PowerCenter comparison

Cancel
You must select at least 2 products to compare!
StreamSets Logo
5,913 views|3,583 comparisons
HVR Software Logo
4,410 views|3,154 comparisons
Informatica Logo
36,752 views|31,106 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between HVR Software and Informatica PowerCenter based on real PeerSpot user reviews.

Find out in this report how the two Data Integration Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed HVR Software vs. Informatica PowerCenter Report (Updated: November 2022).
657,397 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved.""It is a very powerful, modern data analytics solution, in which you can integrate a large volume of data from different sources. It integrates all of the data and you can design, create, and monitor pipelines according to your requirements. It is an all-in-one day data ops solution.""StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes.""In StreamSets, everything is in one place.""I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

More StreamSets Pros →

"It is not like a traditional ETL, but it gives quite a lot of flexibility.""The compare feature is the most valuable piece of it.""Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."

More HVR Software Pros →

"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.""What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly.""The number of docs has been reduced drastically, which is very good.""The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.""The interface is very clean and clear.""Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology.""Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured.""The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."

More Informatica PowerCenter Pros →

Cons
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful.""Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using.""We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back.""The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time.""If you use JDBC Lookup, for example, it generally takes a long time to process data."

More StreamSets Cons →

"It should have a few more monitoring functionalities.""The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results.""HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."

More HVR Software Cons →

"The performance of Informatica PowerCenter could improve.""There is some room for improvement in terms of pricing.""What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved.""The UI is a little outdated.""Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside.""Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud.""Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version.""There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."

More Informatica PowerCenter Cons →

Pricing and Cost Advice
  • "StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."
  • "It has a CPU core-based licensing, which works for us and is quite good."
  • "There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."
  • "The pricing is good, but not the best. They have some customized plans you can opt for."
  • More StreamSets Pricing and Cost Advice →

  • "I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing. We're always open to doing things cheaper, so we might potentially implement a different solution."
  • "I've heard that the license for HVR is a bit costly compared to its competitors, but since it's reliable and efficient, I think the customer shouldn't be bothered about the cost."
  • More HVR Software Pricing and Cost Advice →

  • "I consider this to be an expensive product."
  • "It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
  • "The price of this solution is high."
  • "The solution is in the middle price range compared to other solutions."
  • "Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
  • "Our customers pay a licensing fee yearly."
  • "The price is mostly reasonable."
  • "According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
  • More Informatica PowerCenter Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    657,397 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is really easy to set up and the interface is easy to use.
    Top Answer:We've seen a couple of cases where it appears to have a memory leak or a similar problem. It grows for a bit and then… more »
    Top Answer:We typically use it to transport our Oracle raw datasets up to Microsoft Azure, and then into SQL databases there.
    Top Answer:As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector… more »
    Top Answer: I honestly can't think of another data replication software that can give you better statistics and insight than HVR… more »
    Top Answer:As someone who works at a company where a high volume of information is replicated and has tried several data… more »
    Top Answer:Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… more »
    Top Answer:Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a… more »
    Comparisons
    Also Known As
    HVR, PSB HVR
    PowerCenter
    Learn More
    Overview

    StreamSets offers an end-to-end data integration platform to build, run, monitor and manage smart data pipelines that deliver continuous data for DataOps, and power the modern data ecosystem and hybrid integration.

    Only StreamSets provides a single design experience for all design patterns for 10x greater developer productivity; smart data pipelines that are resilient to change for 80% less breakages; and a single pane of glass for managing and monitoring all pipelines across hybrid and cloud architectures to eliminate blind spots and control gaps.

    With StreamSets, you can deliver the continuous data that drives the connected enterprise.

    HVR is a high-ranking data replication software providing real-time data replication with high volume. One of the biggest advantages of this software is that it offers data replication from a variety of data management systems into data warehouses. They provide high-volume hybrid cloud data integration for Microsoft, Google Cloud, and Amazon Web Services, as well as data integration for Azure, AWS, Google Cloud, Enterprise Data Lake, and Snowflake. Additionally, HVR software offers SAP data replication as well as database replication.

    HVR software works as an all-in-one solution for everything necessary for data replication. The data replication software they provide allows organizations to plan, predict, and respond with the most up-to-date available data. The solutions for data replication that HVR provides helps businesses improve their customer service, reduce margins, and resource plan. HVR Software provides real-time reporting and analytics, distributed architecture and manageability and support for various platforms, and enhanced scalability.

    HVR Software Features

    HRV Software offers many features for its customers, including:

    • Table creation and initial load: This HVR feature allows full control over changes between source and target. It features automatic mapping, table creation, and initial load, which contribute to the fast replication and integration of data. HVR includes the Sliced Refresh feature, which can reduce the loading time for massive tables even further. The migration of schema or database changes made on the source to the replicated target is fully automated, providing further convenience for users.

    • Change data capture: The CDC feature allows for the replication of data in real time with minimal impact. Through this feature, the changes in the data are discovered as they're being implemented, and the data replicas are synchronized with the original so the changes appear simultaneously on the copies as well.

    • Data validation and live comparison: This feature allows users to validate the synchronization of their data, providing timely alerts for any arising issues. As it supports various database management systems, it manages the differences between data types automatically. This feature also comes with a file compare option, allowing direct reading of files instead of relying on external tables to retrieve the data, which gives users quick access to their data.

    • Visual statistics for insights: This HVR feature has two capabilities - topology and statistics - through which users can receive performance metrics on their data as well as information on data flows between sources. Topology provides visual elements to illustrate every data flow in an overflow and through statistics. Users can monitor the data flow in real time.

    HVR Software Benefits

    The benefits of using HVR Software include:

    • Training for customers and timely support
    • Supports multi- and bi-directional data movement
    • Over 1,000 transfer types, allowing data replication over various platforms and topologies
    • Low-impact data movement available for high volumes as well
    • API-automated workflow

    Reviews from Real Users

    HVR Software is one of the highest-rated data replication software by clients. Some of the customer feedback includes:

    A Database Administrator at a manufacturing company, who is responsible for data replication, says using HVR Software allows you to sit back and let the software do the job for you while doing nothing other than looking at monitoring reports.

    A Lead Infrastructure Engineer at a tech vendor points out that the biggest benefit of HVR Software is that it's a user-friendly solution that can handle heavy traffic.

    HVR Software provides a lot of flexibility and serves as a stable data replication software, according to a Solution Delivery Lead and MDM lead at a consultancy.

    Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.

    The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.

    The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.

    Informatica PowerCenter Features

    The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:

    • Collaboration: Informatica PowerCenter offers role-based tools and processes which enable business self-service while benefiting from high-quality IT resources.

    • Automation: Through various automations and easy-to-use software, users can utilize graphical and codeless tools and initiate effective data integration without additional knowledge.

    • Scalability: The tool provides high scalability to users, which ensures seamless performance and minimum downtime. PowerCenter also has adaptive load balancing, pushdown optimization, and dynamic partitioning.

    • Monitoring: Through the extensive monitoring feature, the operations and governance of the solution are easily overseen by users. The tool also provides alerts that can prevent damage to the system.

    • Real-time data: Through real-time data, users can monitor applications and analytics, ensuring their efficient operation.

    • Prototyping: Informatica lets its users collaborate with information technology to prototype, profile, and validate results in a timely manner.

    • Connectivity: Users can access and integrate data from different types of sources through high-performance connectors.

    • Automated data validation testing: The product offers script-free automated and repeatable audit and validation of data.

    • Data transformation: This feature allows users to use comprehensive parsing of JSON, PDF, XML, Microsoft Office, and the Internet of Things (IoT) for non-relation data.

    • Cloud applications connectivity: The product allows for seamless connection to cloud application sources and targets.

    Informatica PowerCenter Benefits

    The benefits of using Informatica PowerCenter include:

    • The tool can work over a wide range of systems and platforms and also allows for lean integration.

    • It enhances the quality and speed of performance and optimizes the cost of the process for your organization.

    • PowerCenter supports multiple databases, including TPump, Parallel Transporter Fastload, and Teradata MLoad.

    • The tool is very easy to monitor and maintain, which simplifies the data integration process for companies.

    • The centralized error logging system allows users to locate errors in a timely manner and correct them.

    • The tool can convert data from an application to another format, as it serves as one of the most powerful data transformation solutions.

    • PowerCenter can also serve as middleware between two applications.

    • The solution offers both parallel processing and load balancing.

    • PowerCenter is a tool with a high level of security, which also minimizes essential administration activities.

    • The solution ensures the quality of information, as it does not allow invalid or unwanted data to be uploaded to the source.

    Reviews from Real Users

    Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.

    Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.

    Offer
    Learn more about StreamSets
    Learn more about HVR Software
    Learn more about Informatica PowerCenter
    Sample Customers
    Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
    Aspen Marketing Services, CACI, Federal Inland Revenue Service, GlobalCollect, Lufthansa Systems, PostNl, US Coast Guard
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company14%
    Manufacturing Company7%
    Insurance Company7%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm12%
    Manufacturing Company12%
    Comms Service Provider6%
    REVIEWERS
    Computer Software Company28%
    Financial Services Firm15%
    Manufacturing Company9%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company18%
    Financial Services Firm14%
    Insurance Company8%
    Comms Service Provider7%
    Company Size
    REVIEWERS
    Small Business22%
    Midsize Enterprise33%
    Large Enterprise44%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Large Enterprise100%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise11%
    Large Enterprise76%
    REVIEWERS
    Small Business19%
    Midsize Enterprise10%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    Buyer's Guide
    HVR Software vs. Informatica PowerCenter
    November 2022
    Find out what your peers are saying about HVR Software vs. Informatica PowerCenter and other solutions. Updated: November 2022.
    657,397 professionals have used our research since 2012.

    HVR Software is ranked 23rd in Data Integration Tools with 3 reviews while Informatica PowerCenter is ranked 2nd in Data Integration Tools with 39 reviews. HVR Software is rated 8.6, while Informatica PowerCenter is rated 7.8. The top reviewer of HVR Software writes "Good stability and scalability, easy setup, and valuable compare feature". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". HVR Software is most compared with Oracle GoldenGate, Qlik Replicate, AWS Database Migration Service, Matillion ETL and Fivetran, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, AWS Glue and Informatica PowerExchange. See our HVR Software vs. Informatica PowerCenter report.

    See our list of best Data Integration Tools vendors.

    We monitor all Data Integration Tools 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.