PowerCenter is a tool for both data integration and for data visualization. Some users have complained it is pricey, however, for the many features this one product offers, I would argue that the pricing is very fair. By using this tool, my company integrates data from various other systems. We have used it for data transformation as well, and it does a good job of that as well. While it has many alternatives, I believe this is one of the best products if you are a tech company. This is due to the fact that while the product is fairly easy to use by beginners too, it is built to fit the needs of more experienced computer specialists.
We use PowerCenter for data integration, building data marts, and data warehouses. I work at a medium-sized company, and we try to utilize all data functions this product has because they are really useful. We have used the tool for the dissemination of data, as well as for ingestion into COTs apps. This tool is great support for decision-making as it offers you a good look into your data and what needs to be fixed or done on time. I believe it works well for all the features it offers. They provide good support also, so you can really count on it.
My company uses PowerCenter with Amazon Web Services, so I am not sure about other clouds supported, but this one is very well done. You can use all the functionalities of the solution within the AWS service. As this is one of the most popular cloud services on the market, I believe it is a very good choice on PowerCenter's side to be able to work with it. I believe the two integrate very efficiently and on top of AWS's good features, you receive top security. This, especially when related to big data, is crucial, so I support the work of those two products together.
Informatica PowerCenter offers cloud support for Amazon Web Services and for Microsoft Azure. These two cloud services are probably the most popular ones on the market, so it is natural for a big product like PowerCenter to be able to work with them. In terms of efficiency, I have worked with the tool and both services in separate companies. I do not have any complaints and think both do a good job, as each service comes with its own specifics to consider. Take into account that many competitors of PowerCenter do not work with both AWS and Azure, so if you are looking for variety, this is definitely the way to go.
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.
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.
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.