SSIS vs webMethods.io comparison

"The setup is straightforward. It's very easy to install."

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"It's a competent product."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"Operationally, I consider the solution to be quite good."

"With webMethods, the creation of servers and the utilization of Trading Networks facilitate B2B integration. It resolves any related issues effectively."

"There's hardware, software and application integration, providing hosting flexibility."

"webMethods Trading Networks is a good solution for interacting with outside of the organization. We can integrate the solutions with multiple outside the organization."

"High throughput and excellent scalability."

"The solution is scalable."

"Currently, we're using this solution for the integration server which helps us to integrate with the mainframe."

"The tool supports gRPC."

"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."

"I would like to see better technical documentation because many times information is missing."

"SSIS is not stable."

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"The solution could improve on integrating with other types of data sources."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"The performance of SSIS could improve when comparing it to Oracle Database."

"Upgrades are complex. They typically take about five months from start to finish. There are many packages that plug into webMethods Integration Server, which is the central point for a vast majority of the transactions at my organization. Anytime we are upgrading that, there are complexities within each component that we must understand. That makes any upgrade very cumbersome and complicated. That has been my experience at this company. Because there are many different business units that we are touching, there are so many different components that we are touching. The amount of READMEs that you have to go through takes some time."

"Some of the things that we use cannot be done in this solution. For these things, we have to either use a Java service or a util service. There is no predefined or existing service that we can use. So, we have to work on the util service and write on top of it. Its price can also be better. It is pretty costly because they charge us for each transmission."

"The on-premises setup can be difficult."

"The market webMethods Integration Server falls under is a very crowded market, so for the product to stand out, Software AG would need to get traction in the open source community by releasing a new version or a base version and open source it, so people can create new custom components and add it to the portfolio."

"It is an expensive solution and not very suitable for smaller businesses."

"Rules engine processes and BPM processes should be improved."

"Version control is not very easy. The packages and the integration server are on Eclipse IDE, but you can't compare the code from the IDE. For example, if you are working on Java code, doing version control and deployment for a quick comparison between the code isn't easy. Some tools or plug-ins are there, such as CrossVista, and you can also play with an SVN server where you have to place your package, and from there, you can check, but you have to do that as a separate exercise. You can't do it from the IDE or webMethods server. You can't just right-click and upload your service."

"The deployment should be simplified."

"SSIS' licensing is a little high, but it gives good value for money."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"This solution is included with the MSSQL server package."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"It would be beneficial if the solution had a less costly cloud offering."

"The solution is available at a lesser price than that of Informatica."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"All of my clients have this product included as part of their Microsoft license."

"Always plan five years ahead and don’t jeopardize the quality of your project by dropping items from the bill of materials."

"Currently, the licensing solution for this product is pretty straightforward. The way that Software AG has moved in their licensing agreements is very understandable. It is very easy for you to see where things land. Like most vendors today, they are transaction based. Therefore, just having a good understanding of how many transactions that you are doing a year would be very wise. Luckily, there are opportunities to work with the vendor to get a good understanding of how many transactions you have and what is the right limit for you to fall under."

"I would like to see better pricing for the license."

"The product is expensive."

"webMethods.io is expensive. We have multiple components, and you need to pay for each of them."

"Pricing has to be negotiated with the local Software AG representative. SAG can always prepare an appropriate pricing model for every client."

"Pricing is the number-one downfall. It's too expensive. They could make more money by dropping the price in half and getting more customers. It's the best product there is, but it's too expensive."

"webMethods Trading Networks is a bit costly compared to others solutions."