Equalum vs SSIS comparison

Cancel
You must select at least 2 products to compare!
Equalum Logo
1,280 views|490 comparisons
100% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,568 views|15,878 comparisons
79% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Equalum and SSIS 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: April 2024).
768,924 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
"Equalum has resulted in system performance improvements in our organization. Now, I am ingressing data off of multiple S3 sources, doing data processing, and formatting a schema. This would usually take me a couple of days, but now it takes me hours.""I found two features in Equalum that I consider the most valuable. One is that Equalum is a no-code tool. You can do your activities on its graphical interface, which doesn't require complex knowledge of extracting, changing, or loading data. Another feature of Equalum that I like the most is that it monitors the data transfers and tells you if there's any issue so that you can quickly check and correct it. Equalum also tells you where the problem lies, for example, if it's a hardware or communication issue.""Equalum provides a single platform for core architectural use cases, including CDC replication, streaming ETL, and batch ETL. That is important to our clients because there is no other single-focus product that covers these areas in that much detail, and with this many features on the platform. The fact that they are single-minded and focused on CDC and ETL makes this such a rich solution. Other solutions cover these things a little bit in their multi-function products, but they don't go as deep.""It's got it all, from end-to-end. It's the glue. There are a lot of other products out there, good products, but there's always a little bit of something missing from the other products. Equalum did its research well and understood the requirements of large enterprise and governments in terms of one tool to rule them all, from a data migration integration perspective.""All our architectural use cases are on a single platform, not multiple platforms. You don't have to dump into different modules because it is the same module everywhere.""The main impact for Oracle LogMiner is the performance. Performance is drastically reduced if you use the solution’s Oracle Binary Log Parser. So, if we have 60 million records, initially it used to take a minute. Now, it takes a second to do synchronization from the source and target tables.""Equalum is real-time. If you are moving from an overnight process to a real-time process, there is always a difference in what reports and analytics show compared to what our operational system shows. Some of our organizations, especially finance, don't want those differences to be shown. Therefore, going to a real-time environment makes the data in one place match the data in another place. Data accuracy is almost instantaneous with this tool.""It's a really powerful platform in terms of the combination of technologies they've developed and integrated together, out-of-the-box. The combination of Kafka and Spark is, we believe, quite unique, combined with CDC capabilities. And then, of course, there are the performance aspects. As an overall package, it's a very powerful data integration, migration, and replication tool."

More Equalum Pros →

"SSIS' best feature is SFTP connectivity.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.""The product's deployment phase is easy.""I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.""The most important features are it works well and provides self-service BI.""It is easy to set up the product.""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."

More SSIS Pros →

Cons
"The deployment of their flows needs improvement. It doesn't work with a typical Git branching and CI/CD deployment strategy.""I should be able to see only my project versus somebody else's garbage. That is something that would be good in future. Right now, the security is by tenants, but I would like to have it by project, e.g., this project has this source and flows in these streams, and I have access to this on this site.""There is not enough proven integration with other vendors. That is what needs to be worked on. Equalum hasn't tested anything between vendors, which worries our clients. We need more proven vendor integration. It is an expensive product and it needs to support a multi-vendor approach.""If you need to use the basic features of Equalum, for example, you don't even need data integration, then many competitors in the market can give you basic features. For instance, if you need batch ETL, you can pick among solutions in the market that have been around longer than Equalum. What needs improvement in Equalum is replication, as it could be faster. Equalum also needs better integration with specific databases such as Oracle and Microsoft SQL Server.""Their UI could use some work. Also, they could make it just a little faster to get around their user interface. It could be a bit more intuitive with things like keyboard shortcuts.""Right now, they have a good notification system, but it is in bulk. For example, if I have five projects running and I put a notification, the notification comes back to me for all five projects. I would like the notification to come back only for one project.""They need to expand their capabilities in some of the targets, as well as source connectors, and native connectors for a number of large data sources and databases. That's a huge challenge for every company in this area, not just Equalum."

More Equalum Cons →

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data.""SSIS is stable, but extensive ETL data processing can have some performance issues.""Tuning using this solution requires extensive expertise to improve performance.""We have issues with SSIS connectors while extracting data from Excel sources.""The solution should work on the GPU, graphical processing unit. There should also be piping integration available.""I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use.""In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade.""I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

More SSIS Cons →

Pricing and Cost Advice
  • "They have a very simple approach to licensing. They don't get tied up with different types of connectivity to different databases. If you need more connectors or if you need more CPU, you just add on. It's component-based pricing."
  • "Equalum was reasonably priced. It is not like those million dollar tools, such as Informatica."
  • "Equalum is rather expensive compared to its competitors. So, you have to make up that cost in time savings, and we usually do that. If we are saving money, it is because we are reducing our development time."
  • "As soon as you have more than six users, Equalum is lower in cost [than Talend] and if the group gets bigger, it's quite a big delta. If more users want to use it, you don't end up with an increase in licensing costs, so that makes it very easy. And if you need more licenses or more sources, it's a very simple upgrade methodology."
  • "Equalum licensing costs vary, but I won't be able to give information on its fees."
  • More Equalum 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 →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,924 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:You'd want to use the Equalium Oracle Binary Log Parser because it's just better than the LogMiner. Sure, LogMiner is made by Oracle and probably the team knows some insight to make it efficient that… more »
    Top Answer:I'm using Equalum's data replication software for Oracle because that's the one database it's designed for. While it may sound limiting, when you find out how many solutions it can provide for you if… more »
    Top Answer:No, it's not free but you can benefit from a free trial, though. There's an option to try their platform for a limited amount of time, so that may be useful to help you decide if you want to continue… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer:The product's deployment phase is easy.
    Top Answer:If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive.
    Ranking
    30th
    out of 100 in Data Integration
    Views
    1,280
    Comparisons
    490
    Reviews
    1
    Average Words per Review
    628
    Rating
    9.0
    2nd
    out of 100 in Data Integration
    Views
    19,568
    Comparisons
    15,878
    Reviews
    35
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Azure Data Factory logo
    Compared 46% of the time.
    Confluent logo
    Compared 17% of the time.
    Fivetran logo
    Compared 17% of the time.
    Informatica PowerCenter logo
    Compared 22% 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 6% of the time.
    Also Known As
    SQL Server Integration Services
    Learn More
    Equalum
    Video Not Available
    Overview

    Equalum is a fully-managed, end-to-end data integration and real-time data streaming platform, powered by industry-leading change data capture (CDC) tech and modern data transformation capabilities (streaming ETL and ELT). Equalum's enterprise-grade platform features intuitive UI allowing you to build robust, real-time data pipelines in minutes.

    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.

    Sample Customers
    SIEMENS, GSK, Wal-Mart, T Systems
    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
    Top Industries
    VISITORS READING REVIEWS
    Manufacturing Company17%
    Computer Software Company17%
    Financial Services Firm8%
    Pharma/Biotech Company7%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise14%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise17%
    Large Enterprise63%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    768,924 professionals have used our research since 2012.

    Equalum is ranked 30th in Data Integration with 7 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Equalum is rated 9.2, while SSIS is rated 7.6. The top reviewer of Equalum writes "Frees staff to focus on data workflow and on what can be done with data, and away from the details of the technology". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Equalum is most compared with Azure Data Factory, EDB Postgres Replication Server, Confluent and Fivetran, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.

    See our list of best Data Integration vendors and best Cloud Data Integration vendors.

    We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.