We performed a comparison between Axway AMPLIFY Application Integration and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Axway AMPLIFY Application Integration is quite a stable solution."
"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."
"It's a competent product."
"The interface is very user-friendly."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"SSIS integrates well with SQL servers and Microsoft products."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The product's deployment phase is easy."
"The performance and stability are good."
"The most important point to improve is the capability to deploy in large enterprises."
"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."
"Axway AMPLIFY Application Integration is an expensive solution."
"The product must improve its visibility and scalability."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"It hangs a lot of the time."
"Options for scaling could be improved."
"I would like to see more features in terms of the integration with Azure Data Factory."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"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."
"Video training would be a helpful addition."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
More Axway AMPLIFY Application Integration Pricing and Cost Advice →
Axway AMPLIFY Application Integration is ranked 41st in Data Integration with 4 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. Axway AMPLIFY Application Integration is rated 8.0, while SSIS is rated 7.8. The top reviewer of Axway AMPLIFY Application Integration writes "An extremely flexible, stable, and scalable solution that speeds up the velocity of your business and provides good visibility". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Axway AMPLIFY Application Integration is most compared with ETL Solutions Transformation Manager, Azure Data Factory, webMethods Integration Server and Spring Cloud Data Flow, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue. See our Axway AMPLIFY Application Integration vs. SSIS report.
See our list of best 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.