Axway AMPLIFY Application Integration vs SSIS comparison

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

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

"The product is robust."

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

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"SSIS is easy to use."

"The initial setup of this solution is very straightforward."

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."

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

"SSIS' best feature is SFTP connectivity."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The interface is very user-friendly."

"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 product must improve its visibility and scalability."

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

"Axway AMPLIFY Application Integration is an expensive solution."

"Future releases should improve the data lineage, as it currently is not good."

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

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

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"The solution could improve by having quicker release updates."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

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

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

"SSIS is fairly well-priced - I would rate it at four out of five."

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

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

"SSIS is a cheaper option compared to the cost of other ETL tools."

"Our license with SSIS is annual."

"The solution comes free of cost."