Talend Open Studio vs. ZappySys SSIS PowerPack

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Talend Open Studio
Score 9.0 out of 10
N/A
Talend Open Studio is an open source integration software, used to build basic data pipelines or execute simple ETL and data integration tasks, get graphical profiles of data, and manage files from a locally installed, open-source environment.N/A
ZappySys SSIS PowerPack
Score 10.0 out of 10
N/A
SSIS PowerPack is a collection of 70+ drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services), designed to boost productivity using 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
$999
per server / annually
Pricing
Talend Open StudioZappySys SSIS PowerPack
Editions & Modules
No answers on this topic
Standard Edition
$999.00
per server / annually
Professional Edition
$1299.00
per server / annually
Offerings
Pricing Offerings
Talend Open StudioZappySys SSIS PowerPack
Free Trial
NoYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsWe offer Subscription and Perpetual License. Check our Pricing Page for detailed purchase options https://zappysys.com/purchase
More Pricing Information
Community Pulse
Talend Open StudioZappySys SSIS PowerPack
Features
Talend Open StudioZappySys SSIS PowerPack
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Talend Open Studio
7.5
Ratings
11% below category average
ZappySys SSIS PowerPack
-
Ratings
Connect to traditional data sources7.00 Ratings00 Ratings
Connecto to Big Data and NoSQL7.90 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Talend Open Studio
7.0
Ratings
15% below category average
ZappySys SSIS PowerPack
-
Ratings
Simple transformations6.00 Ratings00 Ratings
Complex transformations7.90 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Talend Open Studio
7.5
Ratings
6% below category average
ZappySys SSIS PowerPack
-
Ratings
Data model creation6.90 Ratings00 Ratings
Metadata management7.90 Ratings00 Ratings
Business rules and workflow6.90 Ratings00 Ratings
Collaboration7.00 Ratings00 Ratings
Testing and debugging8.90 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Talend Open Studio
6.5
Ratings
22% below category average
ZappySys SSIS PowerPack
-
Ratings
Integration with data quality tools6.00 Ratings00 Ratings
Integration with MDM tools7.00 Ratings00 Ratings
User Ratings
Talend Open StudioZappySys SSIS PowerPack
Likelihood to Recommend
7.9
(0 ratings)
-
(0 ratings)
Likelihood to Renew
10.0
(0 ratings)
-
(0 ratings)
Usability
3.0
(0 ratings)
-
(0 ratings)
Performance
4.0
(0 ratings)
-
(0 ratings)
Support Rating
4.9
(0 ratings)
-
(0 ratings)
User Testimonials
Talend Open StudioZappySys SSIS PowerPack
Likelihood to Recommend
It is certainly suitable for agile and innovative projects. For developments that require particular steps and with a simple debug. On the other hand, it is not very suitable for producing flows that move large amounts of data and that require a lot of resources and great stability.
Read full review
No answers on this topic
Pros
  • It does provide a lot of predefined functionality out of the box along with providing the facility to use complex java code for developers.
  • Mainly like it for small data utilities. It does provide a lot of control for developers.
  • Pricing is, of course, a major plus :)
Read full review
No answers on this topic
Cons
  • The community is not that up to date and forum is not that great in response. Probably we should make people aware of the tool more on how to use and its implementations.
  • Talend crashes when transforming a lot of data (millions of rows).
  • Proper training documentation is a must for talend which is currently lagging. This will help users to learn more about Talend and use it effectively.
Read full review
No answers on this topic
Likelihood to Renew
There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.
Read full review
No answers on this topic
Usability
Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.
Read full review
No answers on this topic
Performance
Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.
Read full review
No answers on this topic
Support Rating
There is only one support staff on a forum created by Talend, which hides behind a nickname and does not show his name. They only ask base questions like: -Talend version - Are you in a proxy? -Do you have all the libraries installed? -It is a Jar missing? (how could I know?) -Follow this link on our site or "please ask your administrators" They then wash their hands of my issues.
Read full review
No answers on this topic
Alternatives Considered
Informatica has a limited number of components that you can use. This places a heavy limitation on the capabilities of Informatica. On the other hand, Talend allows you to create your own custom components using Java. For businesses that need to perform a wide variety of data operations, it can be quite useful to have the option of creating your own custom components to satisfy business needs.
Read full review
No answers on this topic
Return on Investment
  • Being Open Source, your costs on the IDE side are zero.
  • There are a lot of programmers with knowledge in Eclipse, they will be comfy using TOS. The development process will be faster.
  • Once you develop your Service Bus using TOS, you can connect easily with other Talend products, like DTS, Big Data analysis tools, etc.
Read full review
No answers on this topic
ScreenShots

ZappySys SSIS PowerPack Screenshots

Screenshot of SSIS PowerPack - 70+ Easy to use, High Performance Drag and Drop componentsScreenshot of SSIS REST API Integration - Access data from any Web API or Url. Parse HTML, XML, JSON, CSV data. Support for OAuth 2.0Screenshot of SSIS JSON Integration - Read / write / parse Complex JSON Structure (From File, REST API , database column data)Screenshot of SSIS XML Integration - Read / Write from Complex XML Structure (Read  like a SQL Table from any XML / SOAP API or File. Filter, Pivot, Paginate and De-normalize your data in few clicks)Screenshot of Read / Write Salesforce Data in SSIS using drag and drop user interfaceScreenshot of Read / Write Microsoft Dynamics CRM Data in SSIS using drag and drop user interface (On-Premises and CRM 365 - Online )