

Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.
I have seen a return on investment as the company has been renewing the product for the entire 19 months we have been using it, which indicates that trust is high and they likely see value and advantage in using the system.
It has even eliminated a position on our team because that person was no longer needed once we started the automations.
The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.
I like the technical support provided by Informatica.
I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.
I have never used the customer support for Tray.io because the software is very easy to use and we never needed to contact support.
In the cloud, scaling up and down becomes easy when working with cloud providers.
The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.
We can easily scale the memory and also the workflows.
We were able to deploy it from a small company within Tata with 200 people to what is now a multinational company with 92,000 people globally.
The benefits of it being no-code or low-code started to pale in comparison to the cost of making everything slightly more complicated.
Tray.io's scalability is very good.
We are getting 100% uptime every day.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
In my experience, Tray.io is stable, as we have never experienced issues with it failing or being unavailable.
The biggest issue we have with Tray.io is that it runs out of memory space and does not process all of our workflows.
Tray.io is stable, considering the number of workflows we automate.
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
When an automation fails, it usually provides the JSON format, and if Tray.io could include a summary of what the actual error entails, that would be quite beneficial.
I believe Tray.io can be improved by offering integration with Tableau, which is still not available.
There is a steep learning curve in user accessibility; the builder is highly developer-centric, making it difficult for a non-technical team member to modify or troubleshoot workflows.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
We haven't paid for it; our client had paid for this tool.
No one has complained in the finance department, and it is very rare for Tata Motors to refrain from complaining about pricing.
The system supports real-time integration, which is essential for many of my tasks.
Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.
Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.
The connector SDK is also very nice; it has a large library of pre-built connectors that can connect a lot of proprietary internal tools directly into Tray.io, allowing the developer to build, test, and deploy custom connectors using Node.js and integrate the data directly into Tray.io.
The logging and debugging features in Tray.io have helped us considerably, especially when dealing with APIs that return errors sometimes.
Tray.io is low-code automation, meaning you do not have to be an expert in JSON to understand the components and create automations.


| Company Size | Count |
|---|---|
| Small Business | 15 |
| Midsize Enterprise | 11 |
| Large Enterprise | 75 |
| Company Size | Count |
|---|---|
| Small Business | 4 |
| Large Enterprise | 4 |
Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.
Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.
What are the key features of Informatica PowerCenter?Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.
Tray.io is an advanced integration platform that allows seamless connectivity between applications, designed to automate workflows and streamline business processes.
Tray.io provides an extensive library of pre-built connectors and powerful automation tools, making it easy for businesses to boost efficiency. Its drag-and-drop workflow builder enables integration without code, catering to both technical and non-technical users. Being highly customizable and scalable, Tray.io helps companies adapt quickly to changing requirements, ensuring smooth operations and effective data management.
What are the key features of Tray.io?Tray.io is utilized across diverse industries such as e-commerce, where it integrates order management systems to provide seamless customer experiences. In marketing, it connects CRM platforms to enhance lead nurturing. In finance, it streamlines data flow between accounting software, improving financial reporting accuracy.
We monitor all Cloud 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.