SSIS PowerPack

4.8 (98)
Write a Review!
Web-based solution for handling data integration processes

Overall rating

4.8 /5
(98)
Value for Money
4.7/5
Features
4.8/5
Ease of Use
4.6/5
Customer Support
4.9/5

98%
recommended this app
Sort by

98 Reviews

Kent
Kent
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 51–200 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Zappy is a MUST HAVE!

Reviewed on 2020/09/05

Pros

We are able to connect to any rest API so easily with Zappy. I honestly can't imagine how much more work it would take to do what we are doing without it.

Cons

None, it works super well. I guess the UI could be a little easier but honestly there is nothing wrong with this tool.

Alternatives Considered

Boomi

Switched From

Boomi

Response from ZappySys

Thank you very much Kent for taking time to share your experience. Its always inspiring
when we hear how much time / cost saved by switching to ZappySys.

Raoul
Raoul
Overall rating
  • Industry: Utilities
  • Company size: 201–500 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Very usefull functionality & great support

Reviewed on 2022/07/18

Love it

Love it

Pros

Love the functions & friendly swift support

Cons

Powerful functions often do need enough insight in how to set it up, as does working with this software :-)

jofes
Overall rating
  • Industry: Telecommunications
  • Company size: 11–50 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 5.0 /10

Opinion

Reviewed on 2022/07/07

Pros

seems to works fine every hours called..

Cons

Nothing special. May be it will be great to have a version for all kind of drivers.

Michael
Michael
Overall rating
  • Industry: Apparel & Fashion
  • Company size: 501–1,000 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Great time saving product backed up with decent support

Reviewed on 2018/05/17

Time saving, solving complex tasks without having to code.

Time saving, solving complex tasks without having to code.

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.

Naga Sudheer
Naga Sudheer
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 1,001–5,000 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

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

Reviewed on 2018/05/24

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

Thong
Thong
Overall rating
  • Industry: Medical Devices
  • Company size: 1,001–5,000 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Great Product Especially for API's

Reviewed on 2020/07/22

Pros

We utilize this product to develop and automate complex API packages at a very inexpensive cost. Customer support is excellent.

Cons

There is a small learning curve which is inherit in every new software.

Response from ZappySys

Thank you very much for taking time to write this review. We are glad to hear how our tools provide excellent ROI / ease of use. We are committed to make it even better with each iteration.

Jason
Jason
Overall rating
  • Industry: Luxury Goods & Jewelry
  • Company size: 51–200 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Another amazing experience

Reviewed on 2018/12/26

With the amazing support and online guides we have been successful in connecting to several APIs...

With the amazing support and online guides we have been successful in connecting to several APIs over the past couple months. It's been an awesome learning experience and I can't wait to see what we get into next in the new year.

Pros

The support. Rep is always amazing and gets me going in the right direction.

Cons

There is a steep learning curve for all APIs. Not your fault.

Steve
Steve
Overall rating
  • Industry: Construction
  • Company size: 10,000+ Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

An Absolute Must for SSIS ETL

Reviewed on 2018/09/10

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

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

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.

Syed AbdulRehman
Syed AbdulRehman
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 51–200 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Roburst Product

Reviewed on 2018/09/24

Great tool. Takes away the headache of developing many functionalities manually using SSIS. Great...

Great tool. Takes away the headache of developing many functionalities manually using SSIS. Great support team.

Pros

range of capabilities that supplement SSIS.

Cons

Relatively new to the tool but will post soon as soon as I figure out.

Erick
Erick
Overall rating
  • Industry: Insurance
  • Company size: 10,000+ Employees
  • Used Monthly for Free Trial
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

The tech support is very good

Reviewed on 2022/07/05

Pros

It saves you a lot of time when you have to post data into an API destination

Cons

Nothing specific, the product works fine

Verified Reviewer
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

SSIS Powerpack Professional Edition boost SSIS development

Reviewed on 2023/05/17

Pros

It's a robust and complete solution do add functionalities to SSIS Integration Services packages development,.

Cons

i have no cons at the moment .............

Response from ZappySys

Thank you for the time to review our product. We are happy to hear that our product is working well for you. Feel free to reach our team if you have any questions during your project.

Ken
Overall rating
  • Industry: Utilities
  • Company size: 51–200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Save development time with this add-on

Reviewed on 2021/06/18

Every organization I went to, I have recommended purchasing this add-on because the steps it...

Every organization I went to, I have recommended purchasing this add-on because the steps it performs avoids a lot of programming and setup. I've consistently delivered and no one can put a dollar amount on the development time saved. It can theoretically pay for itself in a week for a senior resource to work on packages.

Pros

We use the JSON file and API connectivity the most. Everything is configuration where there is no coding at all.

Cons

Some rough parts in the Excel component that can be further enhanced so it behaves like the CSV component in terms of looping through files. Need one for Access files as well.

Response from ZappySys

Thank you very much for recommending ZappySys. We are glad to hear that how our products helped to achieve great ROI on many projects. Regarding your comment on Excel Component improvements / Looping - Can you please send us some clues - Just mention in your Support Ticket so we have correct information logged. We do have option to specify Wildcard (*.xlsx) on Excel connection incase you didnt try it? Let us know your need so we can help you.

Ulises
Overall rating
  • Industry: Financial Services
  • Company size: 51–200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Effective, performant, flexible integration tool with excellent support and on-line resources

Reviewed on 2022/07/22

A bit of a learning curve, but once you are through that, it is a major time saver.

A bit of a learning curve, but once you are through that, it is a major time saver.

Pros

Comprehensive, flexible tool to meet most integration needs. Great complement to SSIS. Support team is quick to address issues when they come up.

Cons

None worth mentioning. Some might find it a little challenging to use. You will be well-served to have Fiddler and Postman handy.

Warren
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201–500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

SSIS Powerpack

Reviewed on 2021/06/16

Pros

The powerpack is extremely well rounded and functional. It is easy to implement and our use of the extended features has increased steadily over time. The SSIS Powerpack is a key element to our successful intergration into SAP, CRM Dynamics, Office and several 3rd party vendors

Cons

Managing mappings of the JSON source can be time consuming for large sources however overall implementation of products and functionality is quick and easy.

Response from ZappySys

Glad to hear that our product is helping you to solve important integration challenges. Regarding managing mapping on JSON Source we have feature called Import / Export Mappings. You can bulk edit Mappings in any XML editor or notepad and then load file. Contact our support if you need help with that feature.

Verified Reviewer
Overall rating
  • Industry: Executive Office
  • Company size: 51–200 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

User Friendly

Reviewed on 2018/11/07

SSIS PowerPack allows us to automate all of our data and focus on analytics, not extracting data....

SSIS PowerPack allows us to automate all of our data and focus on analytics, not extracting data. We are able to better serve our clients when we can focus on their strategic plan and not be continually focused on collecting data from many disparate data sources.

Pros

The SSIS Powerpack is incredibly easy to use for noncoders and opens up limitless possibilities for your data. Before using the SSIS Powerpack our social media data was collected manually, which took hours and hours; this product allowed us to automate the data extracts from Facebook, Google Analytics, and YouTube.

The documentation is written so that anyone slightly familiar with Visual Studio may easily follow, and the customer service is fantastic, they actually want to help you understand and use their product.

Cons

There haven't been any issues with the software that I haven't been able to review documentation and quickly fix.

Patrick
Overall rating
  • Industry: Environmental Services
  • Company size: 1,001–5,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Powerful and Convinient Product

Reviewed on 2022/05/20

Helped us to integrate internal data with external vendors seemlessly.

Helped us to integrate internal data with external vendors seemlessly.

Pros

REST API Software - Very useful in aiding with integrations.

Cons

The general GUIs could be improved upon.

Verified Reviewer
Overall rating
  • Industry: Hospitality
  • Company size: 51–200 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Brilliant product and great customer support.

Reviewed on 2019/06/26

Pros

Easy to use. Originally purchased to use the SF component only but quickly found a use for most others component too.
Customer support is excellent.

Cons

Can't fault it!!!!!!!!!!!!!!!!!!!!!!!!!!

Response from ZappySys

Thank you very much for taking time to write review. Also, happy to hear that our products and customer support is meeting your expectations.

Verified Reviewer
Overall rating
  • Industry: Luxury Goods & Jewelry
  • Company size: 51–200 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

A happy Zappysys user

Reviewed on 2018/06/06

I needed this tool in my BI tool bag. Once I have the data I can do anything with it, but...

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.

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.

Malcolm
Overall rating
  • Industry: Wholesale
  • Company size: 51–200 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Excellent Support

Reviewed on 2020/06/11

easier to configure tasks than built in ssis tasks

easier to configure tasks than built in ssis tasks

Pros

Very easy to configure the Zs tasks and they are more intuitive than the Built-in SSIS tasks

Cons

Would like to module focused on Magento V1 without having to know the exact links if that is even possible to pull export profiles.

Response from ZappySys

Thank you for your review. We will definitely review your need to make Magento API access more simpler.

Svetlo
Overall rating
  • Industry: Government Relations
  • Company size: 501–1,000 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

The Best SSIS package for parsing complex REST API JSON responses

Reviewed on 2020/03/02

For the needs of a Canadian Crown corporation, we have completed extensive research on leading...

For the needs of a Canadian Crown corporation, we have completed extensive research on leading vendors of SSIS components. One of our challenges was the task of importing data from a remote server in the Oracle cloud. Our data provider exposes the data in a couple of different JSON formats based on a customized REST API interface. Some of the JSON schemas were quite complex, including hierarchical data structures. After evaluating and testing similar products from different vendors, we have found the ZappySys package of components was the best package to address all our needs. We are impressed by the encapsulated intelligence in their components. In addition, ZappySys has the best tech support.

Pros

- Many useful features
- Very intuitive UI
- Easy to customize
- Very well documented
- Great tech support

Cons

No cons.
For the purposes of our project, we have found that this the best SSIS package of components on the market

Bob
Overall rating
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support

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

Reviewed on 2018/07/05

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

Christian
Overall rating
  • Industry: Computer Software
  • Company size: 1,001–5,000 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Incredibly helpful support

Reviewed on 2019/10/21

Pros

Easy and flexible to use. On three occasions I've required troubleshooting from ZappySys and all three times I've had exceptional help from their support team.

Cons

No cons, PowerPack is an incredibly useful tool for SSIS integrations.

Matt
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201–500 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Critical Software

Reviewed on 2019/08/05

We are using Zappysys to replace a number of data connectors we were using for Google Analytics,...

We are using Zappysys to replace a number of data connectors we were using for Google Analytics, Bing, web scraping tools and other outside data source API connections. Zappysys is critical to the success of our data and analytic needs.

Pros

Zappysys has made extracting data from our API sources fast and easy. No coding is involved and any support we have need was available with quick turnarounds. The seamless integration with SQL was critical for us and Zappysys has made that simple. It just works.

Cons

Every so often it will freeze up and need to be restarted but this is very rare.

hussain
Overall rating
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Very easy to use component especilly with cloud data

Reviewed on 2018/06/01

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

Shree Prakash
Overall rating
  • Industry: Computer Software
  • Company size: 501–1,000 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Satisfying Results

Reviewed on 2018/10/17

Pros

There are lot of useful features available in this PowerPack.

Cons

People may need a training session to know all the features.