Axway AMPLIFY Application Integration vs SSIS comparison

"Axway AMPLIFY Application Integration is very easy to use."

"The product is robust."

"Axway AMPLIFY Application Integration is quite a stable solution."

"The most valuable feature is that API Gateway is extremely flexible for any feature, such as connecting to Active Directory to pull the users and their authentication information. There are three ways to connect to Active Directory, and the reason for this is that the computing environments of our customers are very different. Every feature in API Gateway has got multiple methodologies for accomplishing those tasks, which is important because customers are constantly changing their security models, IT models, networks, etc. API Gateway is very flexible. It is not a one size fits all sort of situation where it is very rigid, and you can only use these pull-down menus, and that's all it ever does. It is much more open than that. It can give you fabulous reports on your users, usage, security issues, and the data sets that are going through there. You'll suddenly have visibility on the movement of data within or between your organization and other organizations. The other thing is that you're connecting API to API, which is machine to machine. The things that were done manually in an Excel spreadsheet before exchanging data through email are now done machine to machine and server to server. It speeds up the velocity of your business."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"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 is easy to set up. The deployment is also very quick."

"Overall, it's a good product."

"The technical support is very good."

"It is easy to set up the solution."

"Axway AMPLIFY Application Integration is an expensive solution."

"The product must improve its visibility and scalability."

"Because it is so flexible, you really need someone who knows Axway Gateway or has been through the training and is certified. Just because you know APIs doesn't mean you're going to walk into that API Gateway and understand what to click on. If you're going to get something done quickly, you need to find an engineer from a company who has some experience with it. It is easy to learn, but if you're doing on-the-job training, it is going to take you longer to get your project accomplished."

"The most important point to improve is the capability to deploy in large enterprises."

"We'd like more integration capabilities."

"We have issues with SSIS connectors while extracting data from Excel sources."

"At one point, we did have to purchase an add-on."

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

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

"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."

"I would like to see more features in terms of the integration with Azure Data Factory."

"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

"Users need to pay an annual licensing fee for the solution."

"The product is not expensive."

"API Gateway is priced on the number of transactions you run through it. API Gateway is free, and you can install as many API Gateways as you like or are necessary for your network. For example, if all of the data is inside your network or firewall, you may just need one API Gateway. If you have external customers trying to come into your organization through your firewall, you're going to need one API Gateway outside the firewall and one inside the firewall. If you have a lot of remote offices, you may want to put API Gateway in some of those offices as well. They only charge you for your usage of it. In other words, the number of transactions going through it. That's a good benefit."

"People have to opt for a perpetual-based licensing model."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"Our license with SSIS is annual."

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

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."