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."With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"SSIS integrates well with SQL servers and Microsoft products."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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 technical support is very good."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"It is easy to set up the product."
"It is a highly robust software solution."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"We'd like them to develop data exploration more."
"At one point, we did have to purchase an add-on."
"The performance of this solution is not as good as other tools in the market."
"The solution could improve by having quicker release updates."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"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.