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

Informatica PowerCenter For Windows (PAYG)

Informatica | PowerCenter 10.2HF2 PAYG

Windows, Windows Server 2012 R2 2018.08.15 - 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.


    Victor C.

Synonymous with ETL

  • August 11, 2016
  • Review provided by G2

What do you like best?
> Informatica power center is probably the most powerful ETL tool I have ever used
> It is potent enough to be used as a standard enterprise ETL tool
> It supports a rich functions library and a host of different tools to prepare and cleanse the data according to your need
> You can also use informatica power center to create reusable mappings called "mapplets", these mapplets are a real convenient way of using a transformation logic again and again
What do you dislike?
> When you create a mapping in powercenter you also have to use 2 other tools to create the workflow and to run or schedule it
> Informatica can be slow at times
> Unlike other smaller competitors in the market informatica does not integrate well with the native datasets of various analytical tools like tableau, spotfire, qlikview etc
What problems are you solving with the product? What benefits have you realized?
> We use Informatica as an enterprise ETL tool
> It helps us run batch data updates in the form of data migration from SAP to teradata systems
Recommendations to others considering the product:
> Consider using this tool if you process large amounts of data, to be specific if you have setup a data warehouse this might be an ideal tool for you
> Powercenter can solve any data related processing starting from cleansing to transforming the data and loading it to any leading RDBMS system.
> Do not use this tool if you want to process data for quick analysis using a BI tool


    Research

Informatica power center 9.6.1

  • August 04, 2016
  • Review verified by G2

What do you like best?
Debugger option in PowerCenter designer and ease of using IPC and easy to generate SQL statements as you no need to worry in writing huge sequel statements with IPC you can do it easily and effectively.
What do you dislike?
There are still bugs in the tool which are to be fixed like tracing problem while running multiple workflows.
What problems are you solving with the product? What benefits have you realized?
I usually load the flat file data that comes everyday at particular time to database Target table and transposing the given set of data using informatica normalizer transformation. IPC is an easy and convenient tool to extract transform and load the source data into target.


    Oil & Energy

Leader in Data Integration

  • August 01, 2016
  • Review verified by G2

What do you like best?
Informatica offers integration with wide range of databases and enterprise application integration with a interface helping easy to support and sustain application.
What do you dislike?
Need seamless job scheduling with dependency flexibility like control or autosys scheduling
What problems are you solving with the product? What benefits have you realized?
Integrate data from wide range of source for enterprise integration and business decision support system..


    Information Technology and Services

I have 8 Years of experience with Informatica Tool

  • July 21, 2016
  • Review verified by G2

What do you like best?
It has lot of features to adopt the necessity of business . It is very fast and accurate. Metadata repository for the organization's ETL ecosystem.
What do you dislike?
Lack of functionality compared to other tools or things that might be improved:
Lack of a possibility to do loops within informatica workflows.
Parameter files handling. The concept of using a parameter file is ok, however it would be nice to be able to dynamically set parameters during runtime. Editing the parameter file for each run is rather painful. This would be very helpful especially for development/testing phase.
It's not possible to run a single session within a worklet. Sometimes, again especially for testing/development, it's handy to just run sessions one by one. It's ok in workflows but why it's not possible within worklets ?
What problems are you solving with the product? What benefits have you realized?
Business day to day data . Effective reporting .
Recommendations to others considering the product:
It's best and fast ETL tool with Cloud computing in the market.


    Sandeep T.

Informatica - Power to Information!

  • July 13, 2016
  • Review verified by G2

What do you like best?
I have used Informatica for about two years at my previous workplace. It is the best ETL Technology I have used. Some of the features that were very helpful to me
-> Access and ability to read data from multiple sources. Name the type of source and Informatica can read it.
-> The GUI is excellently simple. High on usability if I could say.
-> The expressions are many. I have used other ETL tools and I haven't found as many data manipulation expressions as in Informatica.
-> Ease of creating and using parameters.
-> Informatica PDO makes things so easier and simple to debug for errors or Data manipulations discrepancies.
What do you dislike?
There was no feature that I disliked much.
Sometimes, I would feel to write a simple statement with a aggregation and the filter is all the steps to be done in Informatica necessary. Its a simple SQL Statement.
What problems are you solving with the product? What benefits have you realized?
It was a full fledged project. The project was to measure the success of services. Informatica was primarily used an ETL tool to crunch the data into a database for the relevant metrics.
Some of the befits that we saw -
-> Data residing across various databases and flat files easily synched to a single application layer
-> Easier manipulation of data
-> Faster to learn and implement than SQL
-> Easier and multiple methods of transportation of packages across various environments.
Recommendations to others considering the product:
A definite product to try for the Data Person of the company.


    Nelson E.

A true ETL Tool

  • June 21, 2016
  • Review verified by G2

What do you like best?
Easy to use even for those that are new to a new ETL tool. Ability to integrate to Cloud solutions. Easy to learn and design and troubleshot. Very reliable on a Unix environment.
What do you dislike?
It needs to incorporate more features in the Standard Edition. All Standard edition is lacking was custom built and integrated with the tool
What problems are you solving with the product? What benefits have you realized?
Daily production report and key executive information through Informatica as a data integration tool.
Informatica is the main ETL tool to integrate into the EDW and therefore it is a critical tool


    Non-Profit Organization Management

As good as it gets

  • May 30, 2016
  • Review verified by G2

What do you like best?
I like the fact that Informatica is solely focused on ETL and they set the industry standard that other tools try to reach.
What do you dislike?
Not much to dislike about the product except the way some of the things are arranged and organized. This is a small price to pay for the unbeatable stability and unparalleled performance.
What problems are you solving with the product? What benefits have you realized?
We are trying to solve enterprise ETL functionality and are realizing very consistent performance that we do not see with other products.
Recommendations to others considering the product:
This is as good as it gets. The only option I would recommend is to look at the Cloud version as it offers additional functionality that the on premise version does not. Not to mention the fact that all the tools are headed to the cloud.


    Information Technology and Services

Strong DI product

  • March 07, 2016
  • Review provided by G2

What do you like best?
Great features. Tight Metadata integration. Ease of use
What do you dislike?
Pipeline architecture. No control flow (for example loops)
What problems are you solving with the product? What benefits have you realized?
Use it to load data warehouses for large enterprises
Recommendations to others considering the product:
Research. Google is your friend


    Information Technology and Services

One of the simplest ETL tool available in the market!

  • January 14, 2016
  • Review provided by G2

What do you like best?
1.) Reliability and easy to learn
2.) It can integrate any type of data, data format from any data source
3.) Integrates well with oracle and teradata
What do you dislike?
1.) Custom built tools used to enhance functionality are not readily available
2.) It frequently crashes and the very often the screen gets stuck
What problems are you solving with the product? What benefits have you realized?
Better performance: able to run Multiple huge scale data integration and data warehousing projects can be executed
Recommendations to others considering the product:
Simple interface, worth a trying the 30 day free trial, easy for both user and administrator


    Vijay Purna M.

The best ever ETL tool - Informatica PowerCenter

  • January 13, 2016
  • Review provided by G2

What do you like best?
Can implement anything using Informatica PowerCenter
Easy and Flexible to use.
What do you dislike?
I do not have any to mention.
I like all the features which are included in Informatica PowerCenter.
What problems are you solving with the product? What benefits have you realized?
Solving and processing all providers in Insurance area.