Actian Pervasive Data Integrator [EOL] vs Informatica PowerCenter vs webMethods Integration Server comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, and webMethods Integration Server based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
768,857 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
"There were no concerns with the stability. This product is very good from a stability perspective."

More Actian Pervasive Data Integrator [EOL] Pros →

"The technical support for Informatica PowerCenter is good.""The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.""Good interface, reasonable documentation.""Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical.""It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use.""The most valuable features are the metadata repository and the data warehouse application console.""The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth.""It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."

More Informatica PowerCenter Pros →

"The tool is very powerful and user-friendly.""It is a bundled product stack for A2A and B2B usage. It is one of the best products which I have used during my integration career.""Ease of implementation and flexibility to hold the business logic are the most valuable features.""The most valuable feature of the webMethods Integration Server is the built-in monitoring, auditing, RETS, and SOAP services.""The solution has a very comprehensive and versatile set of connectors. I've been able to utilize it for multiple, different mechanisms. We do a lot of SaaS and we do have IoT devices and the solution is comprehensive in those areas.""One [of the most valuable features] is the webMethods Designer. That helps our developers develop on their own. It's very intuitive for design. It helps our developers to speed the development of services for the integrations.""The comprehensiveness and depth of Integration Servers' connectors to packaged apps and custom apps is unlimited. They have a connector for everything. If they don't, you can build it yourself. Or oftentimes, if there is value for other customers as well, you can talk with webMethods about creating a new adapter for you.""The ease of mapping... is the single largest feature. It gives us the ability to craft anything. A lot of single-purpose technologies, like Mirth, are good for healthcare messages, but we use webMethods not only for healthcare messages but for other business-related purposes, like integrations to Salesforce or integrations to Office 365. It's multi-purpose nature is very strong."

More webMethods Integration Server Pros →

Cons
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."

More Actian Pervasive Data Integrator [EOL] Cons →

"The pricing could be improved.""Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help.""The performance of Informatica PowerCenter could improve.""Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers.""The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica.""Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together.""This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources.""The initial setup is not straightforward. You need expertise to do it."

More Informatica PowerCenter Cons →

"The orchestration is not as good as it should be.""The logging capability has room for improvement. That way, we could keep a history of all the transactions. It would be helpful to be able to get to that without having to build a standalone solution to do so.""webMethods Integration Server could improve on the version control. I'm not sure if Web Method has some kind of inbuilt integration with Bitbucket or GitHub or some kind of version control system. However, that's one area where they can improve.""It could be more user-friendly.""The UI for the admin console is very old. It hasn't been updated for years and is pretty much the same one that we started with. This is something that could be refreshed and made more modern.""The certifications and learning resources are not exposed openly enough. For instance, they have a trial version which comes with only a few basic features, and I think that community-wise they need to offer more free or open spaces where developers can feel encouraged to experiment.""When migration happens from the one release to an upgraded release from Software AG, many of the existing services are deprecated and developers have to put in effort testing and redeveloping some of the services. It would be better that upgrade releases took care to support the lower-level versions of webMethods.""The price should be reduced to make it more affordable."

More webMethods Integration Server Cons →

Pricing and Cost Advice
Information Not Available
  • "We have found the pricing very cost-effective. The licensing is CPU and data source-based."
  • "Cost could be improved."
  • "Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
  • "Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis."
  • "Its maintenance is expensive."
  • "It's much more expensive, almost three times more expensive than most other solutions."
  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • More Informatica PowerCenter Pricing and Cost Advice →

  • "Initialy good pricing and good, if it comes to Enterprise license agreements."
  • "It is worth the cost."
  • "Always plan five years ahead and don’t jeopardize the quality of your project by dropping items from the bill of materials."
  • "Pricing has to be negotiated with the local Software AG representative. SAG can always prepare an appropriate pricing model for every client."
  • "Some of the licensing is "component-ized," which is confusing to new users/customers."
  • "It is expensive, but we reached a good agreement with the company. It is still a little bit expensive, but we got a better deal than the previous one."
  • "The pricing and licensing costs for webMethods are very high, which is the only reason that we might switch to another product."
  • "The vendor is flexible with respect to pricing."
  • More webMethods Integration Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,857 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Ask a question

    Earn 20 points

    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 »
    Top Answer:The synchronous and asynchronous messaging system the solution provides is very good.
    Top Answer:Other products have been using AI and cloud enhancements, but webMethods Integration Server is still lagging in that key… more »
    Ranking
    Unranked
    In Data Integration
    3rd
    out of 100 in Data Integration
    Views
    19,928
    Comparisons
    16,697
    Reviews
    29
    Average Words per Review
    471
    Rating
    7.6
    Views
    3,421
    Comparisons
    2,391
    Reviews
    21
    Average Words per Review
    668
    Rating
    8.0
    Comparisons
    Also Known As
    Pervasive Data Integrator, PDI
    PowerCenter
    Learn More
    Overview
    Pervasive's Data Integrator platform is a robust enterprise data integration software solution that enables you to quickly build powerful and frictionless connections between any kind of data source and application.

    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.

    webMethods Integration Server is widely considered to be the best integration server available in the marketplace today. The solution can help users integrate everything and anything.

    webMethods Integration Server allows organizations to display and integrate existing and new business activities. The solution offers components that help users create, test, and install new services. webMethods Integration Server can automate, organize, and construct various gathered services and traditional legacy systems into productive value-added processes. webMethods Integration Server works as a secure platform for distributing and running services. The solution obtains and translates user requests, recognizes and records the requested service, translates and moves the data in the necessary format, receives the information back, and returns the information to the user in the appropriate original format. webMethods is the primary solution used by enterprise organizations for integrating functional coordination with application servers, custom applications, and databases. webMethods makes it easy for enterprise organizations to share electronic documents seamlessly.

    Users have several options to audit webMethods Integration Server processes using some of the component metrics below:

    • Adapters: Using the SOA extension for webMethods, users can easily monitor the performance of every adapter users have deployed. Available metrics include Adapter Services, Adapter Connection Pools, and Adapter Notifications nodes.

    • Business Processes: A business process is a process that uses a specific set of rules to perform tasks in a prescribed order. Many business processes depend on the successful integration of numerous systems, involving many people in varying roles. With the SOA extension for webMethods, users can easily monitor that workflow, ensuring that processes are being performed as defined.

    • Java Services: This includes services created in Java or in languages coordinated with Java.

    • WebServices: This includes services regarding webserver endpoints and performance.

    • XSLT Services: This service will allow users to transform XML data into other formats and includes the transformation to other services.

    • Thread Pools: This metric uses threads to conduct services, gather documents from the webMethods Broker, and initiate triggers. Documents can be published locally on the server or to the broker that will send the document out. A JMS trigger receives inbound messages and then processes those messages accordingly.

    Reviews from Real Users:

    “There are a few things about this product that we definitely like. It is very robust. If you build it nicely, you can't go wrong with it. It's rock solid. The development is very fast. If you know what you're doing, you can develop something very easy and very fast.” - Rohit S., Integration Lead at a wellness & fitness company

    “One of the most important features is that it gives you the possibility to do low-level integration. We can meet any requirements through customizations, transformations, or the logic that needs to be put in. When clients come to me with any problem, in about 99% of cases, I say, "Yes, it is feasible to do through webMethods." It has reached such a level of flexibility and maturity. Most of the things are available out of the box, and even if something is not available out of the box, we can customize it and deliver it for a client's requirements.” - Sushant D., IT specialist at Accenture

    Sample Customers
    Pediatrix Medical Group
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Fujitsu, Coca Cola, ING, Credit Suisse, Electrolux, GTA, CosmosDirekt
    Top Industries
    No Data Available
    REVIEWERS
    Computer Software Company22%
    Financial Services Firm20%
    Retailer7%
    Insurance Company7%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Manufacturing Company8%
    Insurance Company8%
    REVIEWERS
    Computer Software Company28%
    Manufacturing Company18%
    Financial Services Firm10%
    Comms Service Provider8%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company13%
    Manufacturing Company10%
    Retailer7%
    Company Size
    REVIEWERS
    Small Business43%
    Large Enterprise57%
    REVIEWERS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business21%
    Midsize Enterprise9%
    Large Enterprise70%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    768,857 professionals have used our research since 2012.