Sign in
Categories
Migration Mapping Assistant Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

Informatica PowerCenter For Red Hat Linux (BYOL)

Informatica | PowerCenter 10.2HF2

Linux/Unix, Red Hat Enterprise Linux 7.6 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

49 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Kent W.

Legacy ETL Tool With Most Powerful Features.

  • November 29, 2019
  • Review provided by G2

What do you like best?
More user-friendly, you may find that you have good capacity in data bases to solve problems when using SQL in Source qualifiers and that good maintenance can be done by using a private access capability to your own creation, that allows you to load, manage and flow data from one source into the aim, which may also become a source for other table information.
What do you dislike?
Further technologies for data transformation can be used, however, other transformations such as SCD, normalization for younger people are difficult to comprehend, python scripts support or networking support or publications should include.
What problems are you solving with the product? What benefits have you realized?
For about 3 years I've been working on this tool and the overall experience was good. Because it offers traditional capabilities and is easier to implement when you get the insight of it, this was a tool or set of tools for all ETL projects before the big data came.
Recommendations to others considering the product:
Informatica PowerCenter has been one of the best data management devices over the years. The statistics it has produced have shown that this tool is the best tool in its use, its loyalty and its support. Since every company manages the humorous information every day, tools like Informatica have an important role to play to handle this data. Informatica PowerCentre is constructed on a structure such that data can be loaded from any source and loaded to target systems as required. This method allows some form of data integration to be accomplished.


    Shubhangi S.

Enterprise Data Integration Platform - Informatica Powercenter

  • November 18, 2019
  • Review provided by G2

What do you like best?
Informatica has tremendous GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring and Debugging.
It offers Paralleh processing and Load balancing.
It follows the same process of ETL (Extract, Transfer Load ).
It consists of in-build concepts of data validation, data cleaning while extracting the data, transferring data by modifying as per the business requirement.
While loading data are assigned with dimensional keys to load on data warehouse or operational database.
What do you dislike?
No Looping Constructs are not present in Informatica.
High cost is required in implementing new systems.
What problems are you solving with the product? What benefits have you realized?
As a part of our work, we need to transform the transactional data and generate reports.
We extract data from its source, transform it as per business requirements and load it into a target data warehouse.
Recommendations to others considering the product:
Informatica Powercenter is an amazing ETL tool. It has the capability to connect & fetch data from different heterogeneous source and processing and transforming of data.


    Meghan S.

It has all the features you would expect in a business tool.

  • November 14, 2019
  • Review provided by G2

What do you like best?
The parallel management and monitoring mechanisms of high volumes of data and number of workflows are very good. The tool has a wide range of transformers and connectors.
What do you dislike?
If this method is to be used for unregulated excel outputs, the versatility offered by SAS / Python is not provided.
What problems are you solving with the product? What benefits have you realized?
ETL resource for company needs that is extremely mature. Has all the features you want in a high-duty data processor. Works with accuracy and reliability. Not as versatile as SAS / Python / R in excellent management
Recommendations to others considering the product:
Use this tool not for small quick analyzes to crunch high volume data.


    Accounting

It is a strong ETL tool, As an Informatica Developer i will recommend this as best to for beginners

  • November 11, 2019
  • Review provided by G2

What do you like best?
Ease of working and easy to learn, package comes in 4 parts, Repository manager, Mapping Designer, Workflow Manager, Workflow Monitor. All are easy to work on. Best part is the leaning guide that you can open simply clicking on help button
What do you dislike?
The only thing that comes into dislike is performance issues, Can't handle huge amount of data. Application got struck while processing large amount of data.
What problems are you solving with the product? What benefits have you realized?
Easily implemented difficult reporting logic using Powercenter.


    Fiorella C.

Informatica PowerCenter: total power for your data.

  • October 24, 2019
  • Review provided by G2

What do you like best?
An authentic program without a doubt, I love its ease of use. In addition to having a capacity to integrate with security systems that provide confidence. Another point in favor is that the types of data and its analysis handle it optimally. In other words, your system is incredible since I can extract data from the emission systems and modify them so that they fit into a destination system and then distribute the data later. In addition to being very fluid and with excellent search filters.
What do you dislike?
One of the most notable failures is that the automation system has errors or functionalities. I still have time in my daily jobs not to have automated processes in some program specifications. In addition the use of memory is very high during its execution, therefore it is necessary to have an optimal equipment to use it.
What problems are you solving with the product? What benefits have you realized?
We are using it for the purpose of generating flat files from different sources or loading data from systems previously given to us. It also serves as support for end users in various commercial departments. At data levels and report conclusions this tool is class A for us.
Recommendations to others considering the product:
It has an incredible database level, this program can be cataloged as a powerful analyzer and report generator. It is ideal for migrating data between sources and with solid characteristics throughout the industry. Informatica Powercenter is in incredible conditions ahead of many of its competitors I dare to say.


    Information Technology and Services

Informatica Power Center the most used ETL to build the enterprise Data Warehouse

  • October 15, 2019
  • Review provided by G2

What do you like best?
Informatica power center the world's leader in ETL for more than 2 decades now ,provides world class functionalities for extracting the data from various sources and transforming the data using various transformation techniques and load the data to any of the target systems.
Informatica supports various source systems connections including all the leading data base systems, application systems, text files, cloud services etc.
It provides various different kinds of transformation techniques which helps transform the data in anyway the business expects.It has various transformations like source qualifier, lookup transformation, joiner transformation, normalizer, SQL transformation, TCL transformation,sorter transformations etc.
Additionally to these inbuilt transformation informatica also supports java transformation where user can write customized java code which helps to achieve the most difficult functionality.
Informatica also provides various connectors such as SAP connectors to connect to SAP applications/databases, Sales force connectors for connecting to Salesforce connectors and it provides the easy integeration with all the industry leading analytic tools which makes the implementation very easy.
What do you dislike?
The tools bit complicated at starting as it contains 3 different four different components,
1. Informatica Workflow Manager
2.Informatica Monitor
3.Informatica Designer
4.Informatica Repository Manager.
Understanding the functionality of each of these above mentioned components is very difficult initially
Informatica requires good level of SQL skills to write various queries to fetch the data from any source systems. This is required in order to fetch data with exact filter so that the unwanted data can be filtered out.
Additionally it also requires good amount of knowledge on shell scripting as there will very high chances that the files should Sent via FTP or SFTP to other servers if the target system is file. This implementation requires knowing the shell scripting.
What problems are you solving with the product? What benefits have you realized?
1. Extract Data from various sources such as SAS DETs, SAP Systems, Oracle DBs, Green plumb Data lakes, Flat files, Salesforce systems, Microsoft SQL DB's and implement various transformations and transform the raw data into business useable data and load the data into various Data marts.
2.Create various Informatica jobs based business requirements, schedule the jobs based the requirement.
3. Refresh the reports daily after the jobs are completed.
4. Check the data quality and data quantity each day before loading the data into various data marts.
5. Fix the various data issues working with the client team and business stake holders.
6. SFTP the file generated each day to different servers for further processing.
6. Do the performance tuning of the jobs if they take much time while running.
7. Use third party tools to schedule the jobs when we need to run the jobs on irrelevant timings.
Recommendations to others considering the product:
As over the years Informatica is one of the best Data Integration tool. The statistics it has generated has proven that this tools in terms of usage,loyalty, support is one of the best tool.Since Every company produces humongous data everyday and to handle this data in anyway the business want to see, Tools like Informatica plays an important role.
Informatica is built on such an architecture that it can load data from any source and transform it the way it is required and load it to the target systems.
So using this tool one can achieve any sort of data integration.


    Information Technology and Services

Does Informatica Powercenter have Future ?

  • August 08, 2019
  • Review provided by G2

What do you like best?
Easy of learning and understanding for new person
What do you dislike?
Adaptability to cloud and big data is slow
What problems are you solving with the product? What benefits have you realized?
Data Migration, Data Integration


    Automotive

Good ETL Tool

  • July 01, 2019
  • Review verified by G2

What do you like best?
It has been very reliable. We have had very little downtime in our production environment because the platform is so stable.
What do you dislike?
We dislike having to install thick client software in order to view running workflows and design them.
What problems are you solving with the product? What benefits have you realized?
We are able to transfer data between our Oracle and Microsoft databases easily.


    Information Technology and Services

Once you start using it ,you will come to know that it is the simple and powerful ETL tool

  • April 27, 2019
  • Review provided by G2

What do you like best?
Ease of use and connectivity with different databases .It has reduced a lot of legacy coding which we need to write manually. It is very easy and simple to use to the end user.
What do you dislike?
The only thing user will face difficulty is the intial set up. It is not as easy as using it after installation. One professional is necessary to start with the set up of this product.
What problems are you solving with the product? What benefits have you realized?
We used to use this tool for data integration. It has everything that what we were looking for earlier.The scalability and stability of this product is very impressive.
Recommendations to others considering the product:
It depends on the size of the organization and the size of data they are trying to do integrate. For a company which is affordable of this product I can say go for it.Totally,I can give 10 out of 10 rating for this product.


    Environmental Services

Best ETL tool

  • March 24, 2019
  • Review provided by G2

What do you like best?
- It is one of the most powerful and user friendly ETL(Extraction, Transformation and Loading) tool.
- Very easy to use - drag and drop
- integration with other applications is easy.
- Good tool to manage legacy data and to make compatible with modern applications.
- Good team of community members and support analysts make it very helpful to debug any issues
What do you dislike?

- the licensing is very expensive But it is manageable, it's value for money.
- Every time we need to pay extra amount if we want any extra plugin for other applications to be activated. Sometimes it appears very slow in data processing
What problems are you solving with the product? What benefits have you realized?
- to accomplish the ETL process from different sources
- availability of plugins (integrators, service providers, etc.) to connect to different applications
- to make deployments seemless
Recommendations to others considering the product:
- i highly recommend this ETL tool over other tools but only if you could afford for it
- they have plugins to integrate with most of the applications out there