We performed a comparison between Informatica PowerCenter, Jitterbit Harmony , and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."UI-based ability to create data mapping."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The product's initial setup phase is very easy."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"Easy integration with Salesforce"
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It is very easy to build integrations and processes to pull and push data."
"It runs like an appliance and has tremendous throughput."
"Jitterbit provides the ability to quickly map data between files and databases."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The UI is very user-friendly."
"The technical support is very good."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The initial setup was easy."
"The initial setup of this solution is very straightforward."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"The reputation of Informatica is that it is expensive."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The UI is a little outdated."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Support could be better."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"The initial setup can be a little bit difficult."
"Looping through complex data structures can be difficult."
"I would like the ability to offer a dedicated cloud version for security."
"Its API management capabilities need improvement."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I would like to see better integration with Power BI."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"We have issues with SSIS connectors while extracting data from Excel sources."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"There were some issues when we tried to connect it to data storage. It was a connection issue."