Informatica PowerCenter For Windows (BYOL)
Informatica | PowerCenter 10.2HF2Windows, Windows Server 2012 R2 2018.08.15 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Data integration and Unified View to Data
What do you like best about the product?
1.Data integration
2.Creating Mapping in power center designer
3.Create workflows in workflow manager
4.Monitor the workflow in power center monitor.
Informatica is a toll that provides an environment which allows loading of data into centralized location.
It allows the extraction of data from multiple sources, transform of data according to business requirements and load the data into file and relational target.
2.Creating Mapping in power center designer
3.Create workflows in workflow manager
4.Monitor the workflow in power center monitor.
Informatica is a toll that provides an environment which allows loading of data into centralized location.
It allows the extraction of data from multiple sources, transform of data according to business requirements and load the data into file and relational target.
What do you dislike about the product?
Required more technical and tool knowledge to implement.
As the tool is not open source, required cash for getting licence.
Debugging might be difficult.
The tool has a steep learning curve and it may take some time for users to become proficient in its use.
As the tool is not open source, required cash for getting licence.
Debugging might be difficult.
The tool has a steep learning curve and it may take some time for users to become proficient in its use.
What problems is the product solving and how is that benefiting you?
Informatica can reduce the loading constraints issue from source to Target mapping.
Informatica support the features of lookup creating sequence doing validation before loading to the target system which will ease of handling the checkpoint using the tool.
So need to handle separate in db.
Informatica support the features of lookup creating sequence doing validation before loading to the target system which will ease of handling the checkpoint using the tool.
So need to handle separate in db.
- Leave a Comment |
- Mark review as helpful
Empowering Data Integration
What do you like best about the product?
Scalability,Connectivity,Transformation Capabilities,Workflow Management,Metadata Repository,Performance Optimization
What do you dislike about the product?
Complexity,Cost,Resource Intensive,Steep Learning Curve,Dependency on IT,Vendor Lock-in
What problems is the product solving and how is that benefiting you?
Informatica PowerCenter solves data management challenges by integrating disparate data sources, improving data quality, simplifying integration processes, enabling real-time data integration, ensuring scalability and performance, and facilitating compliance and governance. By addressing these issues, PowerCenter helps organizations streamline data processes, enhance data quality, and derive valuable insights, ultimately leading to better decision-making and improved operational efficiency.
ETL tool with wide range of transformations and ability to connect multiple source systems
What do you like best about the product?
It is a great ETL tool that can ingest data from multiple sources, perform transformations, and then load it to target systems with drag-and-drop options. Different tools are available for monitoring and repository management and workflow designing.
What do you dislike about the product?
Sometimes it stops responding, and the user interface is not that modern. It isn't easy to work using a touchpad for dragging and dropping, and we need a mouse to work efficiently.
What problems is the product solving and how is that benefiting you?
We are using Informatica PowerCenter to ingest the data from different source systems, which include APIs, flat files and Oracle database. Then we apply various transformations to it and then load the data to an Oracle database.
Simple to use and simple to integrate
What do you like best about the product?
It has got a good number of features to make your life easy. You can just drag and drop the components available and create a data pipeline without having to write code manually.
What do you dislike about the product?
It could have been made a lot more simpler and other informatica tools such as DSM would have been an inbuilt feature rather than having a different product itself.
What problems is the product solving and how is that benefiting you?
You could use this tools to store your data which is spread accross to a central databases using this tool. Mapping can be created easily to accomodate the several datatypes to make it a single column of certain dataype etc.
Easy to use product but a little slow.
What do you like best about the product?
The product is simple and easy to use. It has four different interfaces to create and run workflows. Supports data integration and transformation for multiple relation/non-relational sources.
What do you dislike about the product?
Very slow. Pricing seems to be very high. Switching between different interfaces becomes a headache.
What problems is the product solving and how is that benefiting you?
I have used Informatica PowerCenter as an ETL tool. Loaded and transformed data from different sources into an Oracle data warehouse. Also, I've used this to extract the data from flat files and other DBs.
A good but not the best
What do you like best about the product?
Data Quality iw maintained throughout the process of ingestion and integration
What do you dislike about the product?
It doesn't have much scheduling options and the toll is not anle to handle much jobs
What problems is the product solving and how is that benefiting you?
It helps in entire ETL Process with fratures like data integration , ingestion and data delivery
Information about ETL
What do you like best about the product?
Performance is good with informatica etl tool
What do you dislike about the product?
Mdm is bit complex to understand the technology
What problems is the product solving and how is that benefiting you?
Performance issues with other Etl tools
Informatica PowerCenter
What do you like best about the product?
User Interface is the best I like about Informatica PowerCenter., any new user can learn this tool in no time along with that the logs are very informative which helps in debugging any issues. Developers find the tool very easy to use with all the tools in their arsenal to transform data with minimum learning curve.
What do you dislike about the product?
There are times when the performance of informatica powercenter might not be best when compared to the underlined database., but I have observed in such cases the developers push the entire logic to a database for performance optimization.
What problems is the product solving and how is that benefiting you?
My team can transform data with all the inbuilt transformations available in the tool as per business needs to create an optimized data warehouse which helps our reporting team to create reports with ease. We can create world-class data warehouse with minimum effort using informatica powercenter.
Informatica PowerCentre is a good and easy tool for workflows
What do you like best about the product?
It's easy to manage any workflow. For example if a workflow is failed then one can check the logs to the error of a particular workflow session. You can also easily rerun a workflow from the failed session.
What do you dislike about the product?
I don't like how I have to switch back and forth between Informatica manager and monitor to see the the order of the workflow sessions.
What problems is the product solving and how is that benefiting you?
It solves the problem of setting up a workflow that is made up of N number of tasks and can easily set up a pager for a workflow failure. It's also easy to troubleshoot a failed workflow in Informatica.
Great product for data integration and ETL
What do you like best about the product?
The product is simple and easy to use. Supports a variety of sources for data integration. Out-of-the-box integration is provided for multiple sources. Integration could be done using APIs as well.
What do you dislike about the product?
Very slow, some tasks need to be done online only, and local changes are not allowed. Pricing seems to be on the higher side.
What problems is the product solving and how is that benefiting you?
The usage was mainly for creating a data warehouse for the enterprise data coming from various sources, and running queries on generated data.
showing 1 - 10