17 ans à aider les entreprises françaises
à choisir le meilleur logiciel
SSIS PowerPack
Description de SSIS PowerPack
SSIS PowerPack est une collection de plus de 70 connecteurs/tâches glisser-déposer hautes performances pour SSIS (c.-à-d. les services d'intégration Microsoft SQL Server), conçue pour augmenter votre productivité à l'aide de composants faciles à utiliser et sans codage pour connecter de nombreuses sources de données cloud et sur site, telles que les services REST API, le cloud Azure, le cloud Amazon AWS, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, les API Google (c.-à-d. Analytics, AdWords), les API SOAP/web, Facebook, Twitter, Zendesk, eBay, etc.
Qui utilise SSIS PowerPack ?
La solution se concentre sur les petites et moyennes entreprises, mais assiste également des clients de plus grande taille.
SSIS PowerPack ne vous convainc pas tout à fait ?
Comparer avec une alternative populaire
SSIS PowerPack
Alternatives à SSIS PowerPack
Avis sur SSIS PowerPack
Alternatives envisagées précédemment :
Zappy is a MUST HAVE!
Avantages :
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.
Inconvénients :
None, it works super well. I guess the UI could be a little easier but honestly there is nothing wrong with this tool.
Réponse de l'équipe de ZappySys
il y a 4 ans
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.
Swiss army knife for ETL.
Commentaires : 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.
Avantages :
- 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.
Inconvénients :
- 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.
Réponse de l'équipe de ZappySys
il y a 2 ans
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 ?
It's been okay overall, the software works well for what it does.
Commentaires : The main benefit I get from the product is dealing with the intricacies of connecting to a REST API that requires OAUTH2 authentication.
Avantages :
It definitely takes care of the intricacies of OAUTH2, and the fact that zappysys provides a callback url to use is very helpful.
Inconvénients :
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.
Réponse de l'équipe de ZappySys
il y a 6 ans
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
Data distribution enabler.
Avantages :
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.
Inconvénients :
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.
Alternatives envisagées précédemment :
Excellent product - has saved untold hours building custom applications
Commentaires : 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.
Avantages :
JSON/API tasks and data flows, Advance Filesystem Tasks, SFTP components
Inconvénients :
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.
Réponse de l'équipe de ZappySys
il y a 4 ans
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.
