Informatica is the leading vendor in the data integration space with about 5,000 customers.InformaticaSheer Performance (but not for MacOS!)2018-04-18T15:18:27.479ZInformatica Power Centre is primarily used by the analytics team in our organization to build our ETL workflows. Informatica lies at the heart of all our data pipelining, right from sourcing from the databases all the way through loading to visualization tools and supporting business queries. On a larger picture, it provides a very smooth platform for data movement.,Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.,Setting up Informatica and integrating with your existing services can be a hassle. While the support team is quite helpful, it can still take a considerable amount of time and effort to get Informatica up and running.
Informatica Enterprise Data Integration unavailable for MacOS. This can be a huge problem for a business that primarily uses Apple machines.
Using Informatica PowerCenter for ETL designing can be quite intuitive for basic to moderately complex workflows. However, for achieving advanced tasks, there is not sufficient documentation available.,8,Positive - Made managing data pipelining much easier, cheaper, and faster.
Because Informatica helps automate ETL workflows, it makes the developer's task much easier by reducing the amount of manual work required.
Negative - No support on MacOS means that the business needs to use VMs to work on Informatica. This can be very counter-productive.,Talend Data Integration,Talend Data IntegrationVerified UserLicensing flexibility and skills availability in the market2018-03-06T16:11:21.861ZPredominantly by the IT dept. It addresses enterprise data integration challenges, integrates with enterprise service bus for data movements,Multi platform connectivity, including Hadoop and Cloud providers
Deployment and Licensing flexibility
Pricing
Skills availability in the market,Deployment is flexible, but deployment needs to be more simpler
Difficult ingesting very large datasets, though Informatica's Big Data Edition makes it simple (but that comes at an additional cost),9,It has always been a positive impact,,IBM InfoSphere Information Server, SQL Server Integration Services, SAS Data Integration StudioVerified UserInformatica Review2017-04-12T19:34:10.855ZOur data integration team uses Informatica for extracting, transforming, and loading data into our data warehouse. It allows us to load data from a variety of different sources, reuse transformations, and sync work across a number of employees.,Shared objects allow transformations, sources, and targets to be reused.
Mapplets allow for blocks of transformations to be reused.
Field by field transformations.
Union and join a variety of data sources.,UI is a little ugly - looks like pictures of the tool from 10+ years ago.
Needs undo. Really, it doesn't have undo? Yes. Really.,8,,Microsoft SQL Server, MicroStrategy Analytics, WorkfrontBrandon FitzpatrickMy personal view of Informatica Enterprise Data Integration tools based on my 10+ years of user experiences.2017-03-09T16:53:43.179ZInformatica enterprise data integration tools have been used in my company across different departments for enterprise data warehouses, data marts, data movements etc. It addresses or provides data for different business purposes for my company such as BI reporting and real data dashboards etc.,Informatica Power Center tools are very effective on extracting, transforming and loading bulk data such as hundreds of millions of database rows or raw data flat files, XML files etc., out of or into all kinds of platforms such as databases (Oracle, DB2, SQL server, MySQL, any database that you can name it), OS (UNIX, Linux, Windows), web services, and real time such as IBM MQ.
A single toolset to be used for all kinds of platforms, for bulk data loads, for real-time loads, or web services.,The Informatica web service interface can be improved from a performance point of view and also from a troubleshooting point of view.,10,Informatica tool set investment overall meets my company's business needs since it ensures our daily business data movements and integrations smoothly.
But the maintenance cost and license per CPU model may be a little expensive for small companies.,Luoming HouIntegration with Informatica2014-04-02T17:10:44.604ZInformatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.,Tracking Changes in slowly changing dimensions
Fact &amp; multi-dimensional loading
Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
Modularity,Several partnerships diminishing the value of technologies
Unable to get list of objects from Repository (like sources &amp; targets) that don't have any dependency
Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.,9,Master data management
Data lineage and data archiving
Data discovery and profiling
Increased reporting strategy,,9hai Mani

Informatica Power Centre is primarily used by the analytics team in our organization to build our ETL workflows. Informatica lies at the heart of all our data pipelining, right from sourcing from the databases all the way through loading to visualization tools and supporting business queries. On a larger picture, it provides a very smooth platform for data movement.

Setting up Informatica and integrating with your existing services can be a hassle. While the support team is quite helpful, it can still take a considerable amount of time and effort to get Informatica up and running.

Informatica Enterprise Data Integration unavailable for MacOS. This can be a huge problem for a business that primarily uses Apple machines.

Using Informatica PowerCenter for ETL designing can be quite intuitive for basic to moderately complex workflows. However, for achieving advanced tasks, there is not sufficient documentation available.

One of the main strengths of Informatica Enterprise Data Integration is its performance. If your business requirements include processing of huge volumes of data, then Informatica is strongly recommended over other tools. I would recommend Informatica over Talend.

On the other hand, if your business primarily works on Apple machines, Informatica Enterprise Data Integration is a resounding NO. Running Informatica on a VM or a Remote Desktop completely kills its efficiency.

Our data integration team uses Informatica for extracting, transforming, and loading data into our data warehouse. It allows us to load data from a variety of different sources, reuse transformations, and sync work across a number of employees.

Informatica enterprise data integration tools have been used in my company across different departments for enterprise data warehouses, data marts, data movements etc. It addresses or provides data for different business purposes for my company such as BI reporting and real data dashboards etc.

Informatica Power Center tools are very effective on extracting, transforming and loading bulk data such as hundreds of millions of database rows or raw data flat files, XML files etc., out of or into all kinds of platforms such as databases (Oracle, DB2, SQL server, MySQL, any database that you can name it), OS (UNIX, Linux, Windows), web services, and real time such as IBM MQ.

A single toolset to be used for all kinds of platforms, for bulk data loads, for real-time loads, or web services.

Informatica Enterprise data integration tools are well suited in extracting/loading/transforming large amounts of data as batch loads. It can also be easily integrated with Hadoop on big data applications. But its real-time integration with MQ or Tibco may be a little overlapped with them for the functionalities.

Informatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.

We have found that upgrading from version to version can be a bit clunky and complex.

Watch out for their audit department. They will hunt down development environments that are in use and try to back charge you for their repositories. Ensure your development environments are properly licensed.

Informatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.