We performed a comparison between SSIS and Teradata QueryGrid based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The solution is easy to use and developer friendly."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"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."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The setup was easy. All Microsoft products are easy to set up."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It is easy to set up. The deployment is also very quick."
"It is a highly robust software solution."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The primary challenge with Teradata lies in its cost structure, encompassing subscription fees, software licenses, and hardware expenses."
SSIS is ranked 2nd in Data Integration with 69 reviews while Teradata QueryGrid is ranked 31st in Data Integration with 1 review. SSIS is rated 7.6, while Teradata QueryGrid is rated 9.0. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Teradata QueryGrid writes "Unified and efficient query processing that seamlessly integrates and analyzes data from heterogeneous sources". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Teradata QueryGrid is most compared with Teradata Data Mover, Denodo and IBM InfoSphere DataStage.
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.