I used SnapLogic for ETL purposes, particularly for automating manual activities, for example, automating validation reports, checking and generating email, etc.
The business problems solved by SnapLogic involved setting manual work or manual validation that my company runs in the backend database which is connected using Snaps, then the validation is put as a query into these Snaps, which SnapLogic validates. The solution will generate the results, then sends a report to your email ID, so activities that used to be manual are now automated.
My company also used SnapLogic for ETL processing, particularly various inputs, CSV files connected with Redshift, including databases and adjacent files inputs. The solution can do file-level processing, take data from one data source, and put it into the other data source, so small ETL projects.
You can also take advantage of the SnapLogic pipelines. When a pipeline is created, you can get the URLs from that pipeline which can be triggered from AWS Lambda or any other triggering service. A vendor will provide a set of files that need to be processed. It's not a huge file as it's like transactional data that a vendor provides every week, so my company creates a pipeline where the team configures data in Lambda, so whenever a client drops that particular file for processing, the URL gets triggered, and the SnapLogic job will also be triggered. The SnapLogic job will pick the file from AWS from three locations or any source, then it does the transformation and loads it into the Redshift database of my company, and then the data will be used for several downstream and reporting purposes.
ETL is the major purpose for SnapLogic in the company where it does the transformation by fishing data from one source and putting it into the other. Automation is another purpose.
Hello,
My name is Badrish, I am working as a Technology Architect in the Integration practice, Cognizant Technology Solutions US Corp.
Currently I am in process of studying different industry leading iPaaS products and making a comparative analysis so that we could recommend a right product stack to our customers
I have been going through SnapLogic public /social blogs and have registered myself for a trial account so that I get more familiar with some handson exercises
Meanwhile I do have following questions on SnapLogic Enterprise Integration Cloud
1) What are the different subscription models SnaplLogic offer? Is the information in the link correct? www.g2crowd.com
2) If the answer in above link is right, can you please elaborate? What defines a Mid Market & Enterprise -a) Scalability factors? b) Access to number of snaps? c) Snap capabilities? d) Number of transactions?
3) I understand Snaplex is the data processing engine of the SnapLogic Elastic Integration Platform. Do customers have flexibility to deploy any number of Snaplexes (Cloud/Ground)? What is the cost factor associated? Does it rely on AWS infrastructure and customers need to any additional cost for AWS?
Curious to hear from you. Thanks in Advance!
Regards,
Badrish