"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved."
"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."
"It is really easy to set up and the interface is easy to use."
"In StreamSets, everything is in one place."
"The most valuable features are the metadata repository and the data warehouse application console."
"The interface is very clean and clear."
"The most valuable features are the monitoring tools and the reporting manager."
"Good interface, reasonable documentation."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The solution is easy to implement and easy to use. It's basically just drag and drop."
"They are very good at building out new aspects according to customer requirements."
"SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script."
"It's more developer-friendly, and development can be done at a faster phase."
"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."
"The initial setup is very straightforward."
"The most valuable feature of SnapLogic is the basic transformation of data. It handles basic and complex transformation of data very well."
"SnapLogice is a low-code development tool."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"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."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"Support could be better."
"There is some room for improvement in terms of pricing."
"It should be more cloud-centric than on-prem-centric."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"Its scalability can be improved. It is not scalable."
"We'd like there to be more ways for users to get more comfortable and have more experience with the solution to make it easier to use."
"The dashboards regarding scheduled tasks need further improvement."
"There is room for improvement with APM management and how task execution looks."
"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."
"The support is the most important improvement they could make."
"We'd like zero downtime in the future."
"The solution isn't ideal for complex processing or logic. We use another solution for that."
"One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option."
Informatica PowerCenter is ranked 1st in Data Integration Tools with 31 reviews while SnapLogic is ranked 6th in Integration Platform as a Service (iPaaS) with 9 reviews. Informatica PowerCenter is rated 8.0, while SnapLogic is rated 8.2. The top reviewer of Informatica PowerCenter writes "A stable, scalable, and mature solution for complex transformations and data integration". On the other hand, the top reviewer of SnapLogic writes "Easy to set up, easy to use, and is low-code". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, AWS Glue and Informatica PowerExchange, whereas SnapLogic is most compared with AWS Glue, Matillion ETL, Azure Data Factory, SSIS and TIBCO BusinessWorks.
We monitor all Data Integration Tools 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.
