Informatica PowerCenter Reviews & Product Details

Informatica PowerCenter is a widely recognized data integration tool, known for its robustness and scalability in managing ETL (Extract, Transform, Load) processes. Supports a broad range of data sources, including relational databases, flat files, cloud services, and big data platforms. Supports complex transformations with an intuitive, drag-and-drop interface. User friendly and easy to use. Review collected by and hosted on G2.com.

Non-technical users or newcomers to ETL processes may struggle to use the tool effectively without extensive training.his can be a barrier for small to medium-sized businesses with limited budgets. Users may need to supplement PowerCenter with additional tools for modern data engineering needs. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Scalability,Connectivity,Transformation Capabilities,Workflow Management,Metadata Repository,Performance Optimization Review collected by and hosted on G2.com.

Complexity,Cost,Resource Intensive,Steep Learning Curve,Dependency on IT,Vendor Lock-in Review collected by and hosted on G2.com.

Informatica powercenter has been a classic , it has been in the industry for around 30 years and still is very relavant to the point , provide every possible connector and provides best mapping tools. Review collected by and hosted on G2.com.

the UI looks very old and sometimes it is very difficult to handle big big mappings as it needs lot of experience Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Very slow. Pricing seems to be very high. Switching between different interfaces becomes a headache. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Data Quality iw maintained throughout the process of ingestion and integration Review collected by and hosted on G2.com.

It doesn't have much scheduling options and the toll is not anle to handle much jobs Review collected by and hosted on G2.com.

It is quite easy to use once you get a hang of it and has a bunch of features. although initially it is indeed a bit overwhelming with a lot of things and one can take months to get aware of most of the features(not all). Have the option of selecting different types of sources and targets and can integrate with other applications as well. Integration of different databases all under one roof is very nice. Review collected by and hosted on G2.com.

**Several times the error logs, when the session fails are not very intuitive and one has to dig deep in order to figure out where the problem is. There should maybe some kind of better documentation to help resolve issues.

**Also, it's a bit pricey, I think, especially from the smaller firms' POV. So, if it wishes to in-future provide for the smaller firms as well, maybe a different kind of less expensive model would be great.

**Also, sometimes the designer gets stuck, whenever I try to open some repository that might be having several sub-folders, it takes several minutes to just open one repository.

**And sometimes it gets stuck on the designer in a particular mapping and becomes unresponsive and one has no option but to completely close it and open it again in Citrix, and maybe at times, lose the changes done to a particular mapping as well.

** The UI might need to be modernized a bit, since it seems pretty old Review collected by and hosted on G2.com.