SAS Access vs SSIS vs Zapier comparison

Cancel
You must select at least 2 products to compare!
SAS Logo
398 views|327 comparisons
Microsoft Logo
Read 68 SSIS reviews
19,950 views|16,201 comparisons
Zapier Logo
1,530 views|703 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SAS Access, SSIS, and Zapier based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: March 2024).
765,234 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment.""The most valuable aspect of the solution is the ease of access to the data in those databases.""The most valuable feature is you have native access to the external databases."

More SAS Access Pros →

"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.""The initial setup was easy.""The data reader is the most valuable feature.""The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.""The most valuable feature of SSIS is that it can handle real complex transformations.""It is easy to set up the solution.""The interface is very user-friendly.""It's already very user-friendly and has a good dashboard."

More SSIS Pros →

"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve.""The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses.""Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface.""The most valuable feature of Zapier is it saves me time doing repetitive tasks.""We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature.""With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us.""The solution is a SaaS and does not require a complex setup.""The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."

More Zapier Pros →

Cons
"The solution can provide access to the newer databases that come out sooner.""I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met.""The pricing model needs to be reconsidered and adjusted."

More SAS Access Cons →

"Improving the login procedure would make our reporting easier on monitoring our ETL processes.""There is connectivity with other databases, however, this is the most significant issue that has to be addressed.""We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse.""The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information.""Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases.""It's a legacy tool, that is nearing the end of its useful life.""Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster.""I would like to see more features in terms of the integration with Azure Data Factory."

More SSIS Cons →

"The pricing of the solution is quite expensive.""At the moment, they allow a limited number of apps. I look forward to getting more apps for each package.""I think that this solution should have more apps connected to it.""The user interface for Zapier could be improved. It also takes some time to sync the data between different environments.""It could support various languages along with Python.""With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation.""My biggest concern with Zapier would be their pricing strategy.""There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."

More Zapier Cons →

Pricing and Cost Advice
  • "The pricing model is complex and is based on modular packages as well as the size of the applicable environment."
  • "The solution's pricing and licensing are expensive."
  • More SAS Access Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • More SSIS Pricing and Cost Advice →

  • "There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
  • "Think your Zaps through to make sure you don't use more Zaps than you need."
  • "It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."
  • "The price of Zapier is approximately $75 monthly."
  • "Zapier is a paid service. Its license renews monthly, and Zapier will downgrade your subscription to the free version when your credit card doesn't have funds. That significantly impacts your service because everything halts completely. Zapier doesn't have any hidden costs."
  • "Per task, there is a monthly plan involving 15 euros...Also, in different forms, they just give you the ability to use different features. They charge 18.58 euros for the first standard plan, which includes 750 tasks. So, it is about 25 cents per task."
  • "It's very affordable."
  • "The least expensive plan is $24 a month, and you can go all the way to $800 a month if you're a huge company using many tasks."
  • More Zapier Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    765,234 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Top Answer:The most valuable feature is you have native access to the external databases.
    Top Answer:The solution's pricing and licensing are expensive. It is not the cheapest software. However, SAS systems are solutions… more »
    Top Answer:The solution can provide access to the newer databases that come out sooner.
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… more »
    Top Answer:I have found its most valuable features to be its package management capabilities and the flexibility it offers in… more »
    Top Answer:The pricing of SSIS is generally considered reasonable in comparison to other data integration tools in the market. In… more »
    Top Answer:The product's most valuable feature is automation.
    Top Answer:Zapier's price is high, but it is worth it. You have to pay a premium in order for Zapier to work smoothly. To make your… more »
    Top Answer:One notable concern is the time-out resources assigned to automation when running. It could support various languages… more »
    Ranking
    38th
    out of 94 in Data Integration
    Views
    398
    Comparisons
    327
    Reviews
    1
    Average Words per Review
    316
    Rating
    8.0
    2nd
    out of 94 in Data Integration
    Views
    19,950
    Comparisons
    16,201
    Reviews
    33
    Average Words per Review
    471
    Rating
    7.7
    10th
    Views
    1,530
    Comparisons
    703
    Reviews
    14
    Average Words per Review
    505
    Rating
    8.4
    Comparisons
    Informatica PowerCenter logo
    Compared 21% of the time.
    Talend Open Studio logo
    Compared 11% of the time.
    IBM InfoSphere DataStage logo
    Compared 8% of the time.
    AWS Glue logo
    Compared 7% of the time.
    AWS Glue logo
    Compared 18% of the time.
    Alteryx Designer logo
    Compared 11% of the time.
    Tray.io logo
    Compared 10% of the time.
    MuleSoft Composer logo
    Compared 8% of the time.
    IBM App Connect logo
    Compared 4% of the time.
    Also Known As
    SAS/Access
    SQL Server Integration Services
    Learn More
    Overview
    SAS/ACCESS is an out-of-the-box solution for integrating SAS and third-party databases. You can read, write and update data regardless of the database or platform. Because the data appears native to SAS, there is no need to learn Structured Query Language (SQL) or any other database-specific query languages.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    Zapier is a tool for primarily non-technical users to connect together web apps.

    An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.

    Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.

    Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.

    Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.


    Sample Customers
    Los Angeles County, West Midlands Police, Credit Guarantee Corporation, Canada Post, Allianz Global Corporate & Specialty
    1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
    BuzzFeed, Groupon, Spotify, Columbia University, FOX
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Insurance Company10%
    Computer Software Company10%
    Government7%
    REVIEWERS
    Financial Services Firm23%
    Government8%
    Retailer8%
    Insurance Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    REVIEWERS
    Marketing Services Firm15%
    Recruiting/Hr Firm15%
    Computer Software Company15%
    Leisure / Travel Company8%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider7%
    University6%
    Media Company5%
    Company Size
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business65%
    Midsize Enterprise20%
    Large Enterprise15%
    VISITORS READING REVIEWS
    Small Business32%
    Midsize Enterprise14%
    Large Enterprise54%
    Buyer's Guide
    Data Integration
    March 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: March 2024.
    765,234 professionals have used our research since 2012.