We performed a comparison between Informatica Powercenter and SSIS based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Informatica PowerCenter is a more advanced option if you can afford the higher price. However, SSIS scored better in terms of ease of deployment and service and support.
"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."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"UI-based ability to create data mapping."
"What I like the most is that we have to deal with less while writing the queries."
"Has a good visual tool for data mapping."
"The interface is very clean and clear."
"The most valuable features are the metadata repository and the data warehouse application console."
"The ability to scale through partitions helped us to improve the performance."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"Overall, it's a good product."
"The product's deployment phase is easy."
"The UI is very user-friendly."
"The performance is good."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The performance and stability are good."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The solution does not scale."
"The pricing could be improved."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"We had stability issues, mostly with JVM size."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"There is some room for improvement in terms of pricing."
"The creation of the measure in the DAC's model could be improved."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"We have issues with SSIS connectors while extracting data from Excel sources."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We'd like them to develop data exploration more."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"It hangs a lot of the time."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica PowerCenter is rated 8.0, while SSIS is rated 7.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, Databricks, AWS Glue and Oracle Data Integrator (ODI), whereas SSIS is most compared with Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI), AWS Glue and Azure Data Factory. See our Informatica PowerCenter vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
Curious why you would compare these 2 tools and why you wouldn't be looking for a PaaS solution?
SSIS is free verses Informatica is the opposite. But there are no plans to fully embrace SSIS within Azure. They have moved to ADF and Synapse pipelines.
That said there is IR (Integration Runtime) so you can run SSIS in Azure but it's limited in terms of SSIS add-ons. Clearly, the future for Microsoft is Azure and Synapse so don't count on SSIS staying around for many more years.
In fact, the BiXpress add-on has been deprecated by its new owner. And I would NOT recommend using SSIS without BiXpress as its built-in logging and error control is awful.
I'm looking at us migrating from SSIS to ADF over the next few years.
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free components and connect cloud and on-premises data sources. We find it very useful for connecting traditional data sources, big data, and NoSQL.
We like that it can carry out simple and complex transformations. It is easy to use and helps us connect with multiple systems and web services. It makes it really easy for developers to develop production SSIS packages. It helps us to pull data because it is DBA-friendly.
However, the filtering of the tasks is a bit difficult, and the error messages can be confusing and hard to resolve.
That’s why, when evaluating both solutions, we ultimately decided to go with Informatica PowerCenter. This metadata-driven integration tool is easy to use and effective even when creating complex mapping. It is easy to monitor jobs, create workflows, and detect bugs. It is well suited for handling a low volume of records, therefore maintaining a real-time operation at an affordable cost.
Another advantage is that it works with ETL-type data integration, connecting to almost all types of database systems. It has great support and documentation, too. Informatica PowerCenter can address different data quality issues, such as data masking and virtualization. It has supporting tools for big data as well. It is critical to ensure we can feed on multiple data streams and transform them into usable data in the data warehouse.
There are a few downsides, though. There aren’t many scheduling options, and debugging the workflows is kind of hard.
Conclusions:
Overall, SSIS is a very good group of tools. For organizations used to working with MS products, it provides easy integration and connections between databases. Since we work with a small number of records, the Informatica PowerCenter works better for us.