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).
767,667 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 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.""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.""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.""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.""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.""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."

More Equalum Pros →

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.""The UI is very user-friendly.""The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle.""The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.""The product's deployment phase is easy.""SSIS integrates well with SQL servers and Microsoft products.""The solution is stable.""The setup was easy. All Microsoft products are easy to set up."

More SSIS Pros →

Cons
"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.""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.""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.""The deployment of their flows needs improvement. It doesn't work with a typical Git branching and CI/CD deployment strategy.""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.""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.""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."

More Equalum Cons →

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price.""At one point, we did have to purchase an add-on.""Improvement as per customer requirements.""We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse.""SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc.""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.""The performance of SSIS could improve when comparing it to Oracle Database.""There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

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.
    767,667 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 18% of the time.
    Fivetran logo
    Compared 18% of the time.
    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.
    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 Firm17%
    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.
    767,667 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, Confluent, EDB Postgres Replication Server 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.