SSIS Alternatives and Competitors
Read reviews of SSIS alternatives and competitors
Technology Director at a computer software company with 1,001-5,000 employees
Feb 19, 2021
A stable, scalable, and mature solution for complex transformations and data integration
What is our primary use case?We receive the data files from insurance carriers. We load the data, do some processing, and then make the data available to their internal systems. We apply some business transformations and data validations and share the data in the healthcare domain and EDI B2B exchange. Its version varies based on the customer, but when it comes to the cloud, we have the latest version. We have been using Informatica Intelligent Cloud Services (IICS) for two years. We have used IICS for two purposes. One is for data integration, and the other one is for application integration.
Pros and Cons
- "Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
- "Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
What other advice do I have?It is a very mature product, but now everyone is moving to the cloud. They need to give more attention and focus more on the IICS rather than PowerCenter. PowerCenter on-premises will cater to one or two industries, and they should give more features in IICS. It can cater to only 70% of the features of Informatica PowerCenter. The data integration is currently not as mature in IICS. It doesn't have Mapplets, and we have faced some constraints. We have already logged a service request for this. I would rate Informatica PowerCenter a nine out of ten.
Azure Technical Architect at a computer software company with 10,001+ employees
Real UserTop 5
Dec 31, 2019
Has the ability to copy data to any environment
What is our primary use case?It's an integration platform, we migrate data across hybrid environments. We have data in our cloud environment or on-prem system so we use it for when we want to integrate data across different environments. It was a problem for us to get data from different hybrid environments.
Pros and Cons
- "From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."
- "The user interface could use improvement. It's not a major issue but it's something that can be improved."
What other advice do I have?The advice that I would give to someone considering this solution is to have some background in data warehousing and ETL concepts. Have the background about data warehousing and ETL that extract, transform, and load. If you have the background you need, you will be successful. If not, then my advice would be to learn a little more about it before using Data Factory. I would rate Data Factory as an eight out of ten.
Managing Director at a tech services company with 11-50 employees
Sep 16, 2020
An extract, transform and load solution that is difficult to set up but stable once you do
What is our primary use case?We are using this solution with enterprise customers for ETL (Extract, Transform and Load). The clients are just using it for retail processes.
Pros and Cons
- "Once you have Infosphere up and running properly, it is stable."
- "The setup is extremely difficult."
- "The pricing should be lower."