
Informatica Powercenter is an innovative software that works with ETL-type data integration, this powerful tool facilitates data migration and the integration of different databases such as SQL Server and Oracle, all this under one interface intuitive and simple to implement, its support system is very efficient and solves errors that occur in a matter of minutes. Review collected by and hosted on G2.com.
The implementation costs are high and it is probably difficult to acquire for smaller companies, it would be good if the prices are adapted to the needs of the users, besides to when I want to get more functions I have to pay more money which seems to me a negative aspect, I can also say that I dislike it when it slows down, this happens mostly when I try to process a large amount of data. Review collected by and hosted on G2.com.
I really loved the Extracting, transforming and loading data to and from different databases. Large amount of data can be processed without any hassle. The User Interface is quiet easy and simple to use. It also provides variety of transformation options to manipulate the data. It also supports processing of real-time data. Review collected by and hosted on G2.com.
It is hard to handle BLOB and CLOB data types. Also, deployment is bit complex. Memory utilization of this tool could be improved to some extent. Review collected by and hosted on G2.com.
Informatica Powercenter is widely used as an ETL tool in various big and medium size projects. It can connect to various types of sources like Databases, Flat File, CSV, Excel, XML etc. It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, bigdata which can be used to analyze data and correct it. This is also one of the popular tool for Data Migration project. Review collected by and hosted on G2.com.
Maintenance and version upgrade of tool takes lot of effort. Also, this is not available with a Cloud service provider as SAAS service. Review collected by and hosted on G2.com.
The tool is very user friendly. The best thing is when you work on it and try to save a mapping or something you can easily check whether the process is correct up to that step or not and according to that you can proceed further. Review collected by and hosted on G2.com.
The visualization might be improved, I mean the interface of that software. They can work on the visualization part to make it more user friendly. One more aspect I want to include that when I work on it sometimes data might be lost for some time due to synchronization issues which may be resolved. Review collected by and hosted on G2.com.
It has lot of validation built in. It promots me if I missed something while creating mappings. Review collected by and hosted on G2.com.
I do think that few other transformation such as one for java are not that reliable and can not handle lot of data. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
No Looping Constructs are not present in Informatica.
High cost is required in implementing new systems. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
If this method is to be used for unregulated excel outputs, the versatility offered by SAS / Python is not provided. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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 Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
- 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 Review collected by and hosted on G2.com.
- 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 Review collected by and hosted on G2.com.
It has been very reliable. We have had very little downtime in our production environment because the platform is so stable. Review collected by and hosted on G2.com.
We dislike having to install thick client software in order to view running workflows and design them. Review collected by and hosted on G2.com.
A powerful tool which can be used to integrate/access various data sources.
Supports various data sources like Relational Sources, FlatFile, XML etc. Review collected by and hosted on G2.com.
Have to pay very huge money to buy this software.
Need to pay additional amount if i want to get any additional plugins. Review collected by and hosted on G2.com.
Informatica Powercenter provides the real time data integration services
Its highly intuitive and customizable that speeds up the development process
It comes with full suit of data management components including data integration, data quality, data governance etc
Seamless integration with informatica MDM and data masking tools Review collected by and hosted on G2.com.
Its a bit costly compared to other cheaper alternatives Review collected by and hosted on G2.com.
I mostly like working with the informatica designer as it is very easy to get source and targets by connecting to the server. There are variety of transformations available to clean the data and you just have to find the right one. Review collected by and hosted on G2.com.
Sometime when I run the workflow and if there are some errors, especially those associated with date time conversion, informatica does not tell you why actually the error occurred. You have to go to the session log and google the error to find more about how to solve it. Review collected by and hosted on G2.com.
One of major reason for Informatica etl tool success is its capability of enabling Integration. Informatica also leverage the same integration model. Easy training and tool availability has made easy resource availability for software industry, where else other etl tools are way behind in this aspect. Informatica comes with internal scheduler unlike many other etl tools where one need to use third party scheduler. Review collected by and hosted on G2.com.
Transaction rework costs. Cost incurred in implementing new systems.Delays In delivery data to decision maker which has lost many customers due to poor service. It allows to use Persistent cache, which gives you performance boost by saving time in building the lookup while session run but it still takes the same time like a normal lookup for using the lookup data during session runtime. Review collected by and hosted on G2.com.
Excellent feature-functionality Good performance Ability to handle large data sets Sizeable talent pool Expensive licencing Poor integration with external source control, testing and release management tools Limited & clumsy handling of EDI (X12) data sets.
The software features role-based tools that support iterative business collaboration and development. Data integration is governed by metadata and the highly efficient ETL engine of the software. Other important features offered by the software include rapid prototyping, instant data profiling, graphical data flows, impact analysis, automated data validation, and efficient distributed processing. Review collected by and hosted on G2.com.
Management features of Informatica PowerCenter do not include metadata management. Review collected by and hosted on G2.com.
Informatica is a Best ETL tool,User freindly and selef descriptive.
we have different kind of transformation which helps us to Load the data in desired format. Review collected by and hosted on G2.com.
Informatica having so many sub tools like designer,workflow designer and monitor Review collected by and hosted on G2.com.
Tool is very user friendly and you have very flexible features.
each and every component or transformation is so deltailed that you can use it easily and help content is so detailed that eit will explain each and every step.
scheduling the jobs are very easy and you can rely on sceduling jobs.
informatica is a repository bases so each and every transaction is saved. Review collected by and hosted on G2.com.
This run one job many components needs to be created like mapping session and worflow Review collected by and hosted on G2.com.
It is easy to use and probably the best ETL tool I have worked on. It is very convenient to create reusable and non reusable task depending on the user needs. Review collected by and hosted on G2.com.
There are few bugs in the tool which can be fixed. It is slow in sometimes. Review collected by and hosted on G2.com.