Who Uses This Software?

Focus on small to medium size businesses, but service some significantly larger clients, as well..


Average Ratings

25 Reviews
  • 5 / 5
    Overall
  • 4.5 / 5
    Ease of Use
  • 5 / 5
    Customer Service

Product Details

  • Starting Price
    Not provided by vendor
  • Free Version
    Yes
  • Free Trial
    Yes
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Live Online
  • Support
    Business Hours

Vendor Details

  • ZappySys
  • www.zappysys.com
  • Founded 2015
  • United States

About SSIS PowerPack

SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services), designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay & many more


SSIS PowerPack Features

  • Dashboard
  • ETL - Extract / Transfer / Load
  • Metadata Management
  • Multiple Data Sources
  • Web Services

SSIS PowerPack Reviews Recently Reviewed!


Capterra-loader

Great product - frequent updates - amazing support!

Jul 30, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I feel like you can do anything with data movement when it comes to using the ZappySys SSIS Power Pack. It even does a lot of the native SSIS stuff better. The product gets regular updates and releases and the support team is amazing at helping you out. They go above and beyond to work with you on issues that come up.

Cons: Nothing I can think of. Even when I have found a bug, the ZappySys team works to release a fix in less than a week. Very good to know that they listen to their customers.

Overall: This software helps me quickly ingest data sources that are obscure, out of the ordinary, or that require special accommodation. Saves me from having to write Python and the interaction it provides me with REST APIs is extremely powerful.

Excellent product and excellent customer service.

Feb 28, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Easy to use. Comprehensive set of tasks/components. But, above all, their customer service is exceptional. They go above and beyond to make sure you're happy and their products are doing what you need them to do.

Cons: I have yet to find a single shortcoming in any of the tasks/components included in the purchase. It has exceeded our expectations.

Overall: Save time & money by not having to script common tasks.

One of the rep was very helpfull !!!!!

Jul 05, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Plug and Play we give it some relational table sql and it turns out Jsons for Kinesis streams to Elastic Search. we also drain sql to redshift

Cons: license manager does not work - we run on EC2 on Amazon AWS and the machine ids seem to be screwed up - would like a customer portal with assigned key management

Capterra-loader

Great API Connectors For Json

Jun 15, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Json Source - Super easy to get data from various APIs

Json Parser - Shreds complex Json into relational format

Cons: occasional bugs but support extremely responsive and helpful for troubleshooting issues and recording bugs for future releases

Overall: Automation

Amazing. The best SSIS connectors pack you will find.

Jan 29, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Easy to use. A lot of good connectors that really helps the developers. For people who works with big data, data warehouse, mining, the have the best tools for sure.

Cons: I wish I have someone talking in portuguese there. it would be easier to talk and explain the problems we have sometimes. Despite that, their technical support are really good.

It's been okay overall, the software works well for what it does.

May 25, 2018
3/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
2 / 5
Value for Money
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: It definitely takes care of the intricacies of OAUTH2, and the fact that zappysys provides a callback url to use is very helpful.

Cons: The fact that JSON Integration package includes the JSON Source Connector, but not the REST API/OAUTH connection to go with it is highly disappointing. It feels as if they are doing that just to get customers to spend the extra dollars, that was probably the most disappointing part of my experience. I also notice the custom token prefix setting for the REST API/OAUTH connection doesn't really work.

Overall: The main benefit I get from the product is dealing with the intricacies of connecting to a REST API that requires OAUTH2 authentication.

Vendor Response

by ZappySys on June 01, 2018

Thank you for taking time to write this review. Based on the description looks like you were upset on mainly two issues so we would like to clarify in case there was some confusion.

#1. Regarding price / missing oauth feature in JSON Pack: We always included REST OAuth / HTTP connections part of our JSON Integration Pack so no need to buy the full pack if JSON pack meets your need to call REST API services. See here for details https://zappysys.com/products/ssis-powerpack/ssis-json-integration-pack/

#2. Regarding token prefix setting issue: We looked at your communication with our support staff but there is no mention about this issue. Let us know if you filed a ticket regarding this but we have not acted upon it. Every BUG report / product issue is carefully analyzed by our team so we assure you that your efforts won¿t be wasted.

Please do not hesitate to contact our support team if you have more questions.

Best Regards,
ZappySys Team

Capterra-loader

Great time saving product backed up with decent support

May 17, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Easy to use with drag and drop features. You can achieve many complicated processes without any coding. Support is always available via chat on web page.

Cons: Nothing to note.

Overall: Time saving, solving complex tasks without having to code.

The software and the support are great. I like using the tools.

Jul 02, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: It is very easy to use.

The documentation is really good. They give a lot of examples and screenshots.

The support is always nice and friendly and very helpful.

Cons: I can not find anything that I don't like. Maybe some features are missing which I already told ZappySys which they hopefully will provide.

Makes light work of SSIS, and makes the Standard Features look poor!

Apr 26, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Primarily, its easy to use, the documentation helps and when you get stuck Support are fantastic. The Tasks themselves, are perfect for our use case, and add functionality to our packages that we didn't have before. We extensively use XML and large files, and the SSIS PowerPack makes light work of it. It fills the holes in the SSIS toolbox, which so desperately needed filling..

Cons: I'd say the filtering on the Tasks could be a little easier to understand, but im really scratching the barrel here for "dislikes".. personally its been an good experience...

Overall: Improves our logging, our functionality and reduces the need for over complicated packages.

Vendor Response

by ZappySys on April 30, 2018

Jonathan, Thank you very much for your review. Happy to hear that you are enjoying our product. Feel free to contact us if you have any specific feedback / roadblocks with our product.

A happy Zappysys user

Jun 06, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I came into API development without any experience. Zappysys got us off the ground for connecting to disparate data sources. The support has been wonderful and I wouldn't have been successful without it.

Cons: Learning Zappysys wasn't the easiest for me as API calls can be pretty complex and SSIS Powerpack took a little while to learn. Lucky for us we had the online instructions, videos and live support when needed.

Overall: I needed this tool in my BI tool bag. Once I have the data I can do anything with it, but sometimes getting it can be a problem. Zappysys peaked my interest in coding and I have decided to learn a whole new language because of it.

Very easy to use component especilly with cloud data

Jun 01, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Well defined support documents. Easy to implement in SSIS package. Also, transfer of data is much faster than SSIS Components.

Cons: I did not find any cons other than limited to few cloud communication. not able to use with XML files

So far it has helped me achieve my goals when integrating data from Zendesk/Google Analytics to DWH.

Mar 28, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Through its components, it simplifies ETL development and helps achieve the results faster. It extends quite a lot the possibilities you would have by using just SSIS, to integrate data from different types of sources, transform and use in different types of destinations.

Cons: It's not always the most easy to use and intuitive. There is also some documentation, but some things I could only find through customer support.

Overall: Easier SSIS development

Awesome Support

May 10, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The support was awesome.

Originally just bought it for the Report SSIS task, Upgraded to full model to replace CozyRoc...

Have recently switched from CozyRoc...

Whose support was terrible and very condescending...

Very Happy so far

Cons: Haven't run into any issues yet...

It would be nice if the software knew what I was thinking and transform it into code;)

Vendor Response

by ZappySys on May 15, 2018

Jay, thank you very much for your time and review. As you already indicated we strive to provide top-notch support and will take every opportunity to hand hold our customers especially when they are stuck. Feel free to contact us again if you need any other help.

Capterra-loader

Great company to work with.Great support team, very responsive

May 24, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Its a great product gives SSIS the capability to integrate with most of the next Generation technologies..very easy to use and great documentation and learning videos

Cons: we don't have the rabbitmq connectivity via this software and also the json generator does not let you choose multiple date formats in a single json.we need to do work around for that

Great technical support!

Jan 24, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Easy to use and tons of features and very helpful and knowledgeable technical staff. For the price, it has all of the features we need and is flexible enough to perform most tasks in SSIS easily.

Cons: The only con that I can say about this software package, is that I wish I had written it myself! It installed and worked right out of the gate!

Needed assist in navigating a WSDL API using ZappySys

Feb 06, 2018
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: This product appears to meet our needs well. Leveraging the latest version functionality, REST API Task.

Cons: API calls are an art to be mastered. Even when using this product there is a unique chemistry to perfect, never as straight forward as you would hope. This is an initial review after only one support discussion, hopefully the next discussion will resolve remaining issues and yield even better review.

Overall: Simplified API negotiation using SSIS, addressing some hurdles I hadn't been able to overcome in the out of the box SSIS options.

Vendor Response

by ZappySys on February 08, 2018

Hi Kevin,

Thank you very much for taking time to review our product. Hope our recent call helped you to get going with your SOAP API integration. Feel free to contact us if anything else needed in future.

Best regards,
ZappySys Support Team

Great support, great SSIS tasks

Feb 23, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Flexible components for SSIS which are easy to use and even if you do need help, the support team can assist quickly and helpful to get the tasks up and running. The software opens up a whole lot of capabilities to get data in and out of our databases.

Very usefull features and a full integration of Azure components in VS!!

Apr 12, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: SSIS Components about Blob storages, secureFTP, JSON/XML Parser and the possibility to consume data easily via REST/API.

Capterra-loader

An Absolute Must for SSIS ETL

Sep 10, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: This product is by far the most versatile of all that we have tested.

Cons: While fairly priced on a cost/value basis, this software is not cheap.

Overall: ZappySys performs better than advertised and expected; and the service and support are outstanding.

Easy to use toolset

Aug 10, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Ease of use, functional, and great support

Cons: So far there hasn't been anything I don't like.

Overall: Have been able to build tracking dashboards for our logistics team via periodic API calls simply using ZappySys.

It was good. The initial use of a bot to welcome you is a bit off-putting. A real person is better.

Apr 17, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 5.0/10 Not
Likely
Extremely
Likely

Pros: It appears to be feature-rich. I will know later as the evaluation continues. This is the first use of the trial version. I was surprised that a person was still on-line. It was several hours after your rated cutoff time.

Cons: The documentation lags the offering. That makes it hard for first time users to really follow what to do.

Very useful product if you use SSIS.

Mar 30, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: If not for these ZappySys SSIS components, I probably would not have chose SSIS for some of my tasks. Lots of useful components...especially if you are moving data in or out of the AWS or Azure.

Cons: Had to open several tickets to fix bugs. The good news is I was able to contact Customer Support and the bug fixes were released within a week.

Great customer service

Sep 18, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: The different components which allow you to connect almost to every source you need.

The customer service is great as well and helps you a lot.

Cons: Some of the components are not very intuitive but as I said, you can always ask for help.

Overall: I already did two projects using ZappySys components and all the time it helped me to gain a lot of time.

Great support

Jun 06, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: It is easy to use and the support is very good. I am still trying out, but very happy with the add ons for SSIS

Cons: Not much to add here as we are still testing the product, I am sure they might be some but the supports has been very good.

Overall: API CALLS

Looking for a solution and downloaded trial today. Customer Service exceptionally quick.

Jun 26, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Pros: I'm new to working with API. Right now, I'm completely impressed by the Customer Service, especially for a new user

Cons: None at this time, I literally have been clicking on buttons and reading blogs and watching youtube videos. I just hope this works!