We performed a comparison between Ab Initio Co>Operating System 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."Ab Initio reaches the highest performance and is very flexible in processing huge amounts of data."
"Co>Operating System's most valuable feature is its ability to process bulk data effectively."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"SSIS is easy to use."
"The interface is very user-friendly."
"The performance and stability are good."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"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 debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It's already very user-friendly and has a good dashboard."
"An awesome improvement would be big data solutions, for example, implementing some kind of business intelligence or neural networks for artificial intelligence."
"Co>Operating System would be improved with more integrations for less well-known technologies."
"The security could be improved, as it is more important in our context."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"The performance of this solution is not as good as other tools in the market."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"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 Ab Initio Co>Operating System Pricing and Cost Advice →
Ab Initio Co>Operating System is ranked 29th in Data Integration with 2 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Ab Initio Co>Operating System is rated 9.6, while SSIS is rated 7.6. The top reviewer of Ab Initio Co>Operating System writes "Excellent bulk data processing for large enterprises". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Ab Initio Co>Operating System is most compared with Collibra Catalog, AWS Glue, Azure Data Factory, Talend Data Management Platform and Informatica Cloud Data Integration, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Ab Initio Co>Operating System 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.