A tool useful for data integration and data migration from databases
What is our primary use case?
SnapLogic and Pentaho are tools I use collaboratively for data integration. I have good experience with Pentaho and SnapLogic for data migration from one database to another database.
The main use cases of the tool are for data integration and migration from databases.
In most of the use cases, my company uses SnapLogic for the migration of flat files to S3 and other databases. If my company gets flat files, like CSV, PostgreSQL, and XML files, from our clients, what we do is based on some of the business logic and the implementation they send to us. For my company to apply some business logic and implement it on top of the flat files, we will transfer the file using transform logic, after which we will migrate the data into the database, like Oracle or PostgreSQL.
What is most valuable?
There are features like CSV Parser, XML Parser, File Writer Snap, and File Reader that we use in our company with the separate functionalities provided by SnapLogic, which helps us to apply transform logic and migrate data.
What needs improvement?
My company has a licensed version of SnapLogic, so we have to pay for the product when we use it in our organization. Pentaho and Talend are ETL tools that allow my company to migrate the data within a fraction of a second using open-source products, not the paid version. In SnapLogic, my company uses the product's paid version, so we have to pay for license charges.
When compared with other tools, SnapLogic needs to be given a trial version or made available as an open-source product for simple migrations, which can be helpful for many users. In Talend and Pentaho, users can migrate data by just installing the software. I just installed the UI. SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use. Just giving the email address and creating a password is enough to configure SnapLogic. Tools like Talend and Pentaho need their users to indulge in manual installation since both tools fall under the on-premises software category. That is what is actually called on-premises software. It would be great if SnapLogic office separated software to manage small migrations.
For how long have I used the solution?
I have two years of experience in ETL tools, including SnapLogic. My company has a direct partnership with SnapLogic Intelligent Integration Platform. My company has maintained an individual partnership with SnapLogic, specifically for Cloudplex, so we can connect with cloud services like AWS and Azure. My company has a separate partnership for SnapLogic Cloudplex so that we can connect with Snowflake and cloud services like AWS or Azure.
What do I think about the stability of the solution?
It is a stable solution. There are no glitches in the product. It is an easy tool to use. Users don't need to have separate knowledge to learn about the product.
With SnapLogic, users can find any errors and glitches. Once users find out the issues in the product, then they can solve the problems within the tool, which is a straightforward process.
What do I think about the scalability of the solution?
It is a scalable solution.
Around seven to eight employees in our company use the solution.
How was the initial setup?
For the installation part, if you have separate software within SnapLogic and you are able to download the tool from the cloud, it will be best.
One person can manage the product's deployment phase.
The solution can be deployed in five to ten minutes.
What about the implementation team?
The product's deployment phase was taken care of by the in-house team.
What's my experience with pricing, setup cost, and licensing?
SnapLogic's price is high compared to the other tools available in the market.
What other advice do I have?
My company can suggest Talend or Pentaho for the banking domain since both are open-source tools. But in SnapLogic, there is a security process, and we also have a different authentication process. For banking domain and health insurance, my company suggests SnapLogic. My company usually makes suggestions to others based on the requirements.
I recommend the product to security teams.
I rate the overall tool a nine out of ten.
Easy to integrate anything web application or database or api
What do you like best about the product?
Simple User interface to create snaplogic integration, easy to monitor each step.
What do you dislike about the product?
Logs are not not visible in dashboard for each step except number of input and output document.
Sometimes jobs keep on running and consumes Java memory even though it is terminated
What problems is the product solving and how is that benefiting you?
Trying to convert XML to edi standard. Published snaplogic pipeline as webservice.
Useful for moving data between different environments and easy to setup
What is our primary use case?
It's useful to move data from one environment to another one, for example, from one database to another one. I can also change data types, delete some dates, update data, and clean data, for example. So it's really useful for us.
What is most valuable?
It's easy to use, capable, and offers good performance. It's a good decision to use this product in any company.
What needs improvement?
I would like to see more performance-related dashboards, ones that display the cost of a pipeline, for instance. Also, it would be helpful to have management dashboards for overseeing pipelines and connections.
For how long have I used the solution?
I used SnapLogic for two to three months. I used the latest version.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
There are around two to three people in my IT team using this solution.
How are customer service and support?
The customer service and support are good.
Which solution did I use previously and why did I switch?
I used Microsoft's tool. SnapLogic is more user-friendly than Microsoft. It's easier to understand what you can do in the app.
What about the implementation team?
It is on a web interface, so I didn't need to download anything. I used the web interface. I saw this web interface, and it only linked to my environment.
What's my experience with pricing, setup cost, and licensing?
I used the free trial. You need to pay for a license to use SnapLogic. The pricing is based on the number of integrations you need and the volume of data you're processing.
What other advice do I have?
Overall, I would rate the solution a nine out of ten. I would recommend SnapLogic to others, but there are a few things to keep in mind. First, SnapLogic is not suitable for big data processing. Second, the pricing can be expensive, but it's generally in line with other iPaaS platforms.
Provides ease of use, but it needs more AI capabilities
What is our primary use case?
We use SnapLogic to connect APIs for effectively transferring and integrating data across multiple systems.
What is most valuable?
The product is easy to use and has many connectivity options.
What needs improvement?
They should expand in terms of features for SaaS-based market requirements in different sectors similar to Dell Bumi, AbLogic, Azure, Google, Oracle, etc. There could be more AI capabilities included in the product.
What do I think about the stability of the solution?
I haven't come across any downtime issues.
What do I think about the scalability of the solution?
The product is scalable as per customers' infrastructure requirements.
How was the initial setup?
The user interface is friendly for initial setup. It is a low-code and very intuitive platform.
What's my experience with pricing, setup cost, and licensing?
The license model is based on consumption. They charge for the number of connectors.
What other advice do I have?
I rate SnapLogic a six out of ten. If you have a cloud-based business requirement, you should go for it. But, if your business requires multiple integration tooling, look for other options.
An efficient tool for building data pipelines
What do you like best about the product?
We used the platform to build pipelines that would transfer our client's data onto our company servers and we faced minimal issues for most of the accounts that had the IIP in their ecosystem.
What do you dislike about the product?
For few of our accounts had different types of data, which required different types of pipeline architecture and in such cases we had multiple issues during the design and implementation of those pipelines.
What problems is the product solving and how is that benefiting you?
We receive huge amount of data on a daily basis from our clients and with IIP we can automate the data transfer process and would build pipelines that would takecare of the transfer between the entities.
the snaps in snap logic provides detailed information as compared to the other Ipaas tools.
What do you like best about the product?
It provides efficient way to understand the data using snaps, you can see the output preview of the data and you can download it in JSON, table ETC formats.
What do you dislike about the product?
The nodes maintainence can be improved and it takes a bit time to switch between Designer, Manager and Dashboard tabs.
What problems is the product solving and how is that benefiting you?
SnapLogic mainly solves so many issues,we can connect systems for example Salesforce, SAP, Snowflake, Databases, Amazon. everything, we can send files to anywhere and we have script snap as well, which helps us to write a script in SnapLogic.
Plug-and-play, works for both small and complex use cases, and has a responsive technical support
What is our primary use case?
My major use case for SnapLogic is for ETL. It's for data migration purposes. For example, I've used it to move data from SAP systems, across SAP systems, or across Salesforce systems. I've also used SnapLogic to integrate data from Workday or from some downstream enterprise specific applications to Workday.
How has it helped my organization?
Snaplogic has improved the data integration part of data engineering multifolds and now we have achieved a good rhythm in data integration consumption and security of the same.
What is most valuable?
What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic.
What needs improvement?
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.
What I'd like to see in the next release of SnapLogic is better debugging of errors. Another feature I'd like to see in the solution is a more in-depth data preview because currently, it just shows you what happened to the data, rather than giving you a preview of how the data gets transformed.
For how long have I used the solution?
I've been using SnapLogic for four to five years, and I've used it within the last twelve months.
What do I think about the stability of the solution?
SnapLogic is a pretty stable solution. Stability-wise, access, or any minimum downtime, the solution is pretty good. No complaints on stability.
What do I think about the scalability of the solution?
SnapLogic is a scalable solution, and all the new changes they are bringing in are making SnapLogic a plug-and-play solution. It's good for very small use cases, or even for complex or big data management use cases. The solution is pretty scalable.
How are customer service and support?
I've used the technical support for SnapLogic, and on a scale of one to five, with one being bad and five being excellent, I'd rate the support four out of five. I'm happy with the response time. The technical support team solved my issues.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
My company decided to use SnapLogic because of its scalability, minimal setup, and cost effectiveness.
How was the initial setup?
The initial setup for SnapLogic was pretty easy. There were self-explanatory documents available, so setting the solution up was pretty easy. The deployment took less than half a day.
What's my experience with pricing, setup cost, and licensing?
I'm not aware of the licensing cost for SnapLogic. My boss takes care of it.
What other advice do I have?
I'm using the latest version of SnapLogic, but I don't remember the version number.
In my organization, across the board, I'm not sure how many people use SnapLogic, but at my location, there are thirty to forty users of the solution. In terms of roles, all users are developers.
My advice to first time users of SnapLogic or to anyone looking into implementing it is that if there is a requirement to move data across systems or to integrate data across different systems, I'd definitely recommend SnapLogic, because it's a tool that's pretty easy to use. Much of it is only drag and drop and it is a low code tool. I'll very much recommend SnapLogic to others.
My rating for SnapLogic is eight out of ten. There are still issues for a user like me in terms of debugging in SnapLogic. It gives very limited options for debugging, and that's a major area to work on, so I didn't give it a perfect score.
My company is a customer of SnapLogic.
Most intuitive
What do you like best about the product?
The intuitiveness of the platform is the feature I liked the most. Additionally, there are built-in connectors for a wide variety of commonly used SaaS products, databses, enterprise messaging amd streaming solutions.
What do you dislike about the product?
When it comes to complex transformation requirements, there is a reasonably steep learning curve.
What problems is the product solving and how is that benefiting you?
Snaplogic enables users to address integration requirements whether they are cloud-to-cloud, cloud-to-on-prem or on-prem-to-on-prem. The flexibility to run workloads both in the cloud (managed by Snaplogic) and within on-prem datacenter(managed by customer), but still managed from a single portal offers great advantage.
SnapLogic Integration: A great cloud based integration platform with good scope for improvement!
What do you like best about the product?
1. Ease of Use
2. Visually appealing
3. Lightweight
4. Anyone with a minimal amount of coding background and analytical ability can perform complex integrations with SnapLogic
5. API development is made very simple!
Exposing APIs is made very simple with adequate data security
6. Very easy to connect with multiple ERP systems and cloud platforms
7. Availability of multiple snap packs
8. Ease of use with XML, Json formatters
9. Ease of use with on premise and cloud servers
10. Scheduling, monitoring made easy
What do you dislike about the product?
1. Unpredictable errors
2. Validation with intermittent errors due to inbuilt cache
3. Connectivity between snaps has errors that work suddenly and don't at times
4. Debugging has slight difficulties
5. Ability to run Python scripts
6. No partitioning, but parallel processing is great
7. Working with Postgres snaps shows difficulties. Unable to load data into Partitioned tables
What problems is the product solving and how is that benefiting you?
1. Ease of use in connecting to multiple cloud platforms
2. API based integration made easy
3. Real-time integration with fewer data enabling connectivity between multiple cloud-platforms
4. Analytic/ Reporting emails made much easier
5. Easy to integrate data into Salesforce
6. Parsing different types of data - json, xml, excel, csv, text, etc is made very easy
Incredible versatile integration solution in the cloud
What do you like best about the product?
I like that snap logic offers a wide variety of functions that allows you to integrate data from almost any source, call it flat file, databases, apis, and several other applications
What do you dislike about the product?
I wish they have a little more integration or functionality to run Python Scripts natively. They support that, but you need a sort of knowledge of a third-party library called Jython(Java implementation for python)
What problems is the product solving and how is that benefiting you?
We are integrating data from different sources across the organization. We're currently growing, and the amount of data that we're getting it's growing in the same way; having Snaplogic as an integration tool allows us to move faster and analyze the data promptly.
