Data Office Lead at a comms service provider with 501-1,000 employees
Real User
Sep 14, 2022
As in most platform selection situations, you should create a capability framework that will satisfy your use case and then use the budget criteria to shortlist the vendors.
Search for a product comparison in Data Integration
I highly recommend Informatica PowerCenter as a data integration tool if you are looking for a solution for a large enterprise. I would say that it is one of the most stable and reliable platforms for data governance. Informatica PowerCenter is ideal for integrating and performing transformations on very large amounts of data in a very short amount of time. This is a very mature and complete product that easily performs complex data transformations. It is very stable and reliable and can easily handle large data sources at any given time.
We have all types of different files coming into our systems and Informatica PowerCenter is able to accept all these different sources, such as spreadsheets and databases, and then perform all types of transformations on their data.
One of the features that we find to be most valuable is the metadata repository because it can easily understand the lineage of first target mapping. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.
We can use Informatica PowerCenter to transfer transitional databases to and from the data warehouse. Using this method, we can easily find our data reports and filter the data, which we use to create AI models. We also use it in order to create data warehouse applications, which can then be used for analytics, helping us generate business value.
Informatica PowerCenter has a very nice user interface. Our staff finds that it is really intuitive and user friendly - it is easy to work with and can be picked up in just a few days.
We are very satisfied with the technical support that Informatica PowerCenter offers. They are available 24/7. The support staff is knowledgeable and responsive. There is also a good online knowledge base.
The basic deployment is straightforward. But for systems with data integration services and other services, the deployment will take more time.
Some of the benefits and advantages of Informatica PowerCenter include:
Performance: Informatica PowerCenter is a very reliable and robust tool for data management and data governance strategy. It can manage and transform huge quantities of data.
Stability: The system is reliable and does not crash or stall.
Customer support: Customer support is available for customers 24/7. It is also very easy to find helpful information online.
Ease-of-use: The system is user-friendly and users are able to quickly learn how to effectively use it in a short amount of time.
The main downside of the product is its price. It is a bit on the expensive side and probably too pricey for mid and small sized companies. Another feature we would like to see integrated with the tool is monitoring. Currently, there is no viable monitoring solution.
Informatica PowerCenter provides us with all the functionality that we need and more. I definitely recommend it. Users that are familiar with ETL tools will find it easy and worthwhile to use Informatica PowerCenter. I rate it a nine out of ten.
Data Integration is a process that connects disparate data sources to streamline data management, enhance accuracy, and enable comprehensive analysis within an organization.This practice is critical for businesses aiming to consolidate data from diverse systems and databases. By doing so, organizations can ensure data consistency and integrity across all departments, supporting informed decision-making and operational efficiency. It also plays a significant role in enabling real-time...
As in most platform selection situations, you should create a capability framework that will satisfy your use case and then use the budget criteria to shortlist the vendors.
I highly recommend Informatica PowerCenter as a data integration tool if you are looking for a solution for a large enterprise. I would say that it is one of the most stable and reliable platforms for data governance. Informatica PowerCenter is ideal for integrating and performing transformations on very large amounts of data in a very short amount of time. This is a very mature and complete product that easily performs complex data transformations. It is very stable and reliable and can easily handle large data sources at any given time.
We have all types of different files coming into our systems and Informatica PowerCenter is able to accept all these different sources, such as spreadsheets and databases, and then perform all types of transformations on their data.
One of the features that we find to be most valuable is the metadata repository because it can easily understand the lineage of first target mapping. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.
We can use Informatica PowerCenter to transfer transitional databases to and from the data warehouse. Using this method, we can easily find our data reports and filter the data, which we use to create AI models. We also use it in order to create data warehouse applications, which can then be used for analytics, helping us generate business value.
Informatica PowerCenter has a very nice user interface. Our staff finds that it is really intuitive and user friendly - it is easy to work with and can be picked up in just a few days.
We are very satisfied with the technical support that Informatica PowerCenter offers. They are available 24/7. The support staff is knowledgeable and responsive. There is also a good online knowledge base.
The basic deployment is straightforward. But for systems with data integration services and other services, the deployment will take more time.
Some of the benefits and advantages of Informatica PowerCenter include:
Performance: Informatica PowerCenter is a very reliable and robust tool for data management and data governance strategy. It can manage and transform huge quantities of data.
Stability: The system is reliable and does not crash or stall.
Customer support: Customer support is available for customers 24/7. It is also very easy to find helpful information online.
Ease-of-use: The system is user-friendly and users are able to quickly learn how to effectively use it in a short amount of time.
The main downside of the product is its price. It is a bit on the expensive side and probably too pricey for mid and small sized companies. Another feature we would like to see integrated with the tool is monitoring. Currently, there is no viable monitoring solution.
Informatica PowerCenter provides us with all the functionality that we need and more. I definitely recommend it. Users that are familiar with ETL tools will find it easy and worthwhile to use Informatica PowerCenter. I rate it a nine out of ten.