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."Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"SSIS integrates well with SQL servers and Microsoft products."
"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."
"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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It's saved time using visualization descriptions."
"It is a highly robust software solution."
"We'd like more integration capabilities."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The security could be improved, as it is more important in our context."
"It's a legacy tool, that is nearing the end of its useful life."
"At one point, we did have to purchase an add-on."
"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 needs more integration tools, so you can connect to different sources."
"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."
"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.
