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."The product is robust."
"Axway AMPLIFY Application Integration is very easy to use."
"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."
"Overall, it's a good product."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"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."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The setup was easy. All Microsoft products are easy to set up."
"SSIS is easy to use."
"The data reader is the most valuable feature."
"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."
"Axway AMPLIFY Application Integration is an expensive solution."
"The product must improve its visibility and scalability."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"It's a legacy tool, that is nearing the end of its useful life."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"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."
"I would like to see better integration with Power BI."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"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."
More Axway AMPLIFY Application Integration Pricing and Cost Advice →
Axway AMPLIFY Application Integration is ranked 44th in Data Integration with 4 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Axway AMPLIFY Application Integration is rated 8.0, while SSIS is rated 7.6. 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, Import.io and Ignite ETI, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) 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.