TrustRadius: an HG Insights company

Talend Open Studio vs. ZappySys SSIS PowerPack

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Talend Open Studio

    Score9 out of 10
    N/ATalend 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.

    $0

    per month

    ZappySys SSIS PowerPack

    Score10 out of 10
    N/ASSIS 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
    Features
    Talend Open StudioZappySys SSIS PowerPack
    Data Source Connection
    Comparison of Data Source Connection features of Talend Open Studio and ZappySys SSIS PowerPack
    Feature
    Talend Open Studio
    7.5
    10 Ratings
    11% below category average
    ZappySys SSIS PowerPack
    -
    Ratings
    Connect to traditional data sources7.010 Ratings00 Ratings
    Connecto to Big Data and NoSQL7.99 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Talend Open Studio and ZappySys SSIS PowerPack
    Feature
    Talend Open Studio
    7.0
    10 Ratings
    15% below category average
    ZappySys SSIS PowerPack
    -
    Ratings
    Simple transformations6.010 Ratings00 Ratings
    Complex transformations7.910 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Talend Open Studio and ZappySys SSIS PowerPack
    Feature
    Talend Open Studio
    7.5
    10 Ratings
    6% below category average
    ZappySys SSIS PowerPack
    -
    Ratings
    Data model creation6.99 Ratings00 Ratings
    Metadata management7.99 Ratings00 Ratings
    Business rules and workflow6.98 Ratings00 Ratings
    Collaboration7.07 Ratings00 Ratings
    Testing and debugging8.910 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Talend Open Studio and ZappySys SSIS PowerPack
    Feature
    Talend Open Studio
    6.5
    7 Ratings
    22% below category average
    ZappySys SSIS PowerPack
    -
    Ratings
    Integration with data quality tools6.06 Ratings00 Ratings
    Integration with MDM tools7.07 Ratings00 Ratings
    Best Alternatives
    Talend Open StudioZappySys SSIS PowerPack
    Small Businesses
    Skyvia
    Score9.9 out of 10
    Skyvia
    Score9.9 out of 10
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score8 out of 10
    IBM InfoSphere Information Server
    Score8 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.2 out of 10
    SolarWinds Task Factory
    Score8.2 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Talend Open StudioZappySys SSIS PowerPack
    Likelihood to Recommend
    7.9
    (11 ratings)
    -
    (0 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    3.0
    (1 ratings)
    -
    (0 ratings)
    Performance
    4.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    4.9
    (3 ratings)
    -
    (0 ratings)
    User Testimonials
    Talend Open StudioZappySys SSIS PowerPack
    Likelihood to Recommend
    Qlik
    For quick daily integrations Talend is a very good tool and it makes development time so short and easy. Citizen developers who are not great programmers can pick up and start using Talend Open Studio within weeks. It's well suited for all kinds of data migration between various systems. It is less appropriate for smaller synchronous services where you need to trace the complete transaction and how data moved between them. It's also less appropriate for small data movements where other tools can be easier to use and manage.
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Pros
    Qlik
    • Your developers will be able to design SOA services graphically, and it is very easy to document and implement the code.
    • Talend Open Studio is based on Eclipse IDE, so your developers will be very comfy using it
    • Open is Key in Talend Open Studio = Open Source
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Cons
    Qlik
    • 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.
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Likelihood to Renew
    Qlik
    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.
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Usability
    Qlik
    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
    ZappySys
    No answers on this topic
    Performance
    Qlik
    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
    ZappySys
    No answers on this topic
    Support Rating
    Qlik
    Talend Open Studio is free and we are not using the enterprise version which comes with licence and support. So, mostly depend on the open source community for any issues that we face. The document is good and we didn't have to use any support so far. We did evaluate the enterprise version and so far sticking to the free version.
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Alternatives Considered
    Qlik
    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.
    Incentivized
    Read full review
    ZappySys
    No answers on this topic
    Return on Investment
    Qlik
    • I delivered projects the client did not believe were possible, and I provided intermediate value by providing visibility to hidden data problems in their systems they could not detect before.
    • I was able to work 3 projects at a time, pausing gracefully in one while switching to the other, with minimal effort.
    Incentivized
    Read full review
    ZappySys
    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 )