Wir helfen Unternehmen in Deutschland
seit 15 Jahren bei der Softwareauswahl

Über SSIS PowerPack

Ein robustes Sortiment an über 70 Aufgaben und Komponenten, die den Integrationsprozess in den gängigsten Formaten rationalisieren.

Erfahre mehr über SSIS PowerPack

Vorteile:

Been using ZappySys for about a year to save development time/cost on a ETL project with a short implementation time, our SSIS packages implemented with ZappySys components have been trouble-free.

Nachteile:

I'd say the filtering on the Tasks could be a little easier to understand, but im really scratching the barrel here for "dislikes.

Bewertungen zu SSIS PowerPack

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,6
Kundenservice
4,9
Funktionen
4,8
Preis-Leistungs-Verhältnis
4,7

Weiterempfehlungsquote

9,3/10

SSIS PowerPack hat eine Gesamtbewertung von 4,8 von 5 Sternen basierend auf 87 Nutzerbewertungen auf Capterra.

Hast du SSIS PowerPack bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (87)

Kent
Kent
General Manager in USA
Verifizierter Nutzer auf LinkedIn
Krankenhausversorgung & Gesundheitswesen, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Zappy is a MUST HAVE!

5,0 vor 4 Jahren

Vorteile:

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.

Nachteile:

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

Antwort von ZappySys

vor 4 Jahren

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Staatsverwaltung, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Swiss army knife for ETL.

4,0 vor 2 Jahren

Kommentare: Part of my career has been built on this tool because I was able to finish projects substantially faster with it than done any other way.

Vorteile:

- API source and target adapters stand out the most because we can now take our data in and out of cloud services where there hasn't been a vendor making a special ODBC driver to interact with their service.- Effortless point and click configuration for 80%+ of the product.

Nachteile:

- Some features are still rough. The Excel source adapter needs further enhancement to loop through worksheets and functions absent that is present in the CSV adapter.

Antwort von ZappySys

vor 2 Jahren

Thank you so much for taking the time to review our product. We are happy to hear that you considered ZappySys and not other competitor products due to the flexibility / ease of use offered in our products. We love to get more feedback on Excel Connection feature you mentioned. Would you mind sharing what can be improved there? Excel Connection supports wildcard to read from many files if that's what you mean (e.g. c:\files\data_*.xlsx ?

David
Senior Business Analyst in USA
Medizinische Geräte, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Data distribution enabler.

5,0 vor 2 Monaten Neu

Vorteile:

ZappySys has enabled all of the tasks we have envisioned. My personal SSIS experience was old and minimal. ZappySys was able to assist in implementation of their tools plus train/assist with SSIS training/development.

Nachteile:

I had some problems with the initial implementation, but that was due to my overall inexperience with SSIS and Visual Studio. ZappySys was able to assist with my roll-out.

Ben
Database Administrator/SQL Analyst in USA
Verwendete die Software für: Nicht angeboten
Herkunft der Bewertung

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

3,0 vor 6 Jahren

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

Vorteile:

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

Nachteile:

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.

Antwort von ZappySys

vor 6 Jahren

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

Alexander
System Analyst in Ukraine
Gesundheit, Wellness & Fitness, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Great simplification of integration development process

5,0 letzten Monat Neu

Kommentare: Great choice for ETL development, solo developer will fully repay price of SSIS Power Pack in a matter of months with own time saved.

Vorteile:

Support, they are really into helping to solve your problem. not just to fix own bugs. A lot of guidelines and pretty good documentation on all provided features.

Nachteile:

A bit tricky process of upgrading to higher level of subscription.

Antwort von ZappySys

vor 2 Wochen

Thank you very much for your review. We are happy to hear that you got a good ROI from the SSIS PowerPack purchase.

Mark
Data Architect in USA
Maschinenbau oder Wirtschaftsingenieurwesen, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Excellent product - has saved untold hours building custom applications

5,0 vor 4 Jahren

Kommentare: Data integrations and warehousing. Ability to pull data via DBA-friendly tool such as SSIS rather than .NET developer creating a new service to pull data every time we turn around.

Vorteile:

JSON/API tasks and data flows, Advance Filesystem Tasks, SFTP components

Nachteile:

Occasional problems when using new components for the first time - usually resolved with a new release of the software. Support is very communicative and helpful though.

Antwort von ZappySys

vor 4 Jahren

Thank you very much for taking time to share your experience with our product. We are happy to hear that our JSON / API / SFTP and other tasks saving you time and cost. We have plans to add SharePoint Source / Destination in future (No ETA yet) but for now you can use our Generic JSON Source with OData Settings as described in our blog post here. https://zappysys.com/blog/sharepoint-365-rest-api-ssis-read-list-write-create/ Feel free to contact our support if you have more questions.

Cody
Cody
Sr Data Engineer in USA
Verifizierter Nutzer auf LinkedIn
Finanzdienstleistungen, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Functionality at a cost

3,0 vor 4 Jahren

Vorteile:

SSIS PowerPach has tons of features and connectors

Nachteile:

Price was ultimately my least favorite part of SSIS PowerPack

Antwort von ZappySys

vor 4 Jahren

Thank you very much for taking time to write this review. We understand you have price concern. Please contact our sales team and someone will be happy to address your concern.

Scott S.
Scott S.
Sr. Data Analyst in USA
Verifizierter Nutzer auf LinkedIn
Bildungsmanagement, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great product - frequent updates - amazing support!

5,0 vor 6 Jahren

Kommentare: 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.

Vorteile:

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.

Nachteile:

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.

Kenny
Data Analyst Engineer in USA
Krankenhausversorgung & Gesundheitswesen, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Technical Support

5,0 vor 11 Monaten

Kommentare: The SSIS Powerpack has made my Data Movement and ETL Processing extremely flexible. Working with support was also very easy contact and the support personnel (I'm sorry as I can't remember his name) was very helpful and explained what I needed to do to solve my issue in a very timely manner.

Vorteile:

The ease of use of the tasks that are included ie. File System, API Tasks

Nachteile:

Nothing that comes to mind as the tasks that I've used so far have been successful

Antwort von ZappySys

vor 8 Monaten

Thank you very much for taking the time to rate our product. Glad to know that you like Advanced File System Task and REST API-related Tasks / Components.

Stephen
Stephen
Associate Data Analyst in USA
Verifizierter Nutzer auf LinkedIn
Bildungsmanagement, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great API Connectors For Json

5,0 vor 6 Jahren

Kommentare: Automation

Vorteile:

Json Source - Super easy to get data from various APIs Json Parser - Shreds complex Json into relational format

Nachteile:

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

Greg
Sr BI Analyst in USA
Rundfunk, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Excellent product and excellent customer service.

5,0 vor 6 Jahren

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

Vorteile:

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.

Nachteile:

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

Bob
IT Senior Manager in USA
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

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

5,0 vor 6 Jahren

Vorteile:

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

Nachteile:

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

Ignacio
Business Intelligence Manager in USA
Krankenhausversorgung & Gesundheitswesen, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great Product Best Service

5,0 vor 3 Jahren

Kommentare: Great

Vorteile:

Amazing service offered by [SENSITIVE CONTENT]

Nachteile:

Challenging to implement in Azure data factory

Antwort von ZappySys

vor 3 Jahren

Thank you very much for taking time to write this review. Regarding ADF feedback, we are planning to make process simpler so you dont have to write custom powershell script.

Patrick
Data Services Lead in Irland
Umweltdienstleistungen, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Powerful and Convinient Product

5,0 vor 2 Jahren

Kommentare: Helped us to integrate internal data with external vendors seemlessly.

Vorteile:

REST API Software - Very useful in aiding with integrations.

Nachteile:

The general GUIs could be improved upon.

Svetlo
Senior BI Consultant in Kanada
Regierungsbeziehungen, 501–1.000 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

The Best SSIS package for parsing complex REST API JSON responses

5,0 vor 4 Jahren

Kommentare: 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.

Vorteile:

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

Nachteile:

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

Shiraaz
Developer in Südafrika
Versicherung, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Excellent Product

5,0 vor 2 Jahren

Kommentare: Workflow Bulk Api Calls

Vorteile:

A host of third party connectors which are well documented

Nachteile:

Would like to have command line tooling integrated to the power pack

Matt
VP, Analytics in USA
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Critical Software

5,0 vor 5 Jahren

Kommentare: 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.

Vorteile:

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.

Nachteile:

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

Peggy
Bi Specialist in Deutschland
Essen & Trinken, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Kostenlose Testversion
Herkunft der Bewertung

Great support team!

5,0 vor 2 Jahren

Kommentare: Very easy to be installed and used!

Vorteile:

It's very easy to install the solution. We had some problems with the firewall, but this where solved by our infrastructure team. Other problem, e.g. with collation, the support team from ZappySys helped pretty fast and competent to find the solution.

Nachteile:

Until now, I haven't found any cons. But I'm still testing other features.

Antwort von ZappySys

letztes Jahr

Thank you very much for your kind words, glad to hear that our support helped you to resolve the issue. We really appreciate your time and feedback.

Shree Prakash
BI Developer in Australien
Computer-Software, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Satisfying Results

4,0 vor 6 Jahren

Vorteile:

There are lot of useful features available in this PowerPack.

Nachteile:

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

Yanis
Data engineer in Niederlande
Umweltdienstleistungen, 201–500 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Amazing

5,0 vor 3 Jahren

Vorteile:

This is great software if you using SSIS for your ETL loads. It offers a lot of functionalities that don't come out of the box from VS

Nachteile:

Sometimes the windows do not go full screen property causing me not being able to click all the fields in the powerpack

Antwort von ZappySys

vor 3 Jahren

Yanis, thank you very much for your kind words. We appreciate your time and feedback. We have passed your comments about full screen to DEV team.

Scott
DBA, programmer in USA
Bau, 51–200 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Helpful software and support

5,0 vor 5 Jahren

Vorteile:

It seems to do everything I need it to do, which is to extract database tables from a JSON cloud API source and load SQL server tables. I have not had to write any script tasks. Support sticks with you until you get your questions answered.

Nachteile:

Some of the online training resources need to be updated to reflect the current version GUI.

Jason
Jason
BI/ERP Manager in USA
Verifizierter Nutzer auf LinkedIn
Luxusgüter & Schmuck, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Another amazing experience

5,0 vor 6 Jahren

Kommentare: 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.

Vorteile:

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

Nachteile:

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

Sivaraman
Solutions Consultant in Indien
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Great support

4,0 vor 4 Jahren

Kommentare: Using API calls and Google analytics have become easy with zappysys.

Vorteile:

Most of the configuration set-up in the SSIS components we use are translated to simple english. For instance, you don't need to understand auth2.0 to set up Google Analytics authentication tokens through zappysys connection manager.

Nachteile:

Documentation does not cover every nook and corner. Issues become difficult to find in google too.

Antwort von ZappySys

vor 4 Jahren

Thank you very much for taking time to write this review. We are glad to hear that your API integration made easy with our tools. Your feedback about documentation is noted and passed on to our Dev team. Feel free to contact our support if you have any other feedback.

Hafid
Ceo in Belgien
Computer-Software, 2–10 Mitarbeiter
Verwendete die Software für: Kostenlose Testversion
Herkunft der Bewertung

Best support seen in working in IT for almost 20 years

5,0 vor 4 Jahren

Kommentare: ++++

Vorteile:

Technical knowledge required to install and configure - afterward worry-free use for our clients!

Nachteile:

Nothing at all, happy a colleague informed me about this solution.

Juan Carlos
Data Engineer in Costa Rica
Computer- & Netzwerksicherheit, 10.000+ Mitarbeiter
Verwendete die Software für: Kostenlose Testversion
Herkunft der Bewertung

Great support

5,0 vor 4 Jahren

Kommentare: Their products and Support are great.

Vorteile:

100% of the time, when I have an issue, their support group is always willing to help and being able to solve the problem.

Nachteile:

Their first lvl customer support, ask to many redundant questions

Antwort von ZappySys

vor 4 Jahren

Hi Juan, first of all we really appreciate your time and efforts to share your trial experience regarding our product / support. We are happy to hear that our online support was helpful to you. We are always striving to improve our support so never hesitate to contact us back if you have any feedback. Your comment regarding first level support is fully noted and we will improve upon it.