We performed a comparison between SSIS and Toad Data Point based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"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 saved time using visualization descriptions."
"The technical support is very good."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The scalability of SSIS is good."
"It has good data integration and good processes."
"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 Connectivity and Connection Manager supports a broad number of connection types, and it is trivial for end-users to set up their own connections to sources."
"The most valuable features of Toad Data are you could write a parameterized query and it wouldn't error out, it would give you the parameters that you could input. The auto-formatting feature is useful because it was great for keeping your queries neat and understandable. The auto comment, and uncomment toggles that you could do were convenient."
"It hangs a lot of the time."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"It would be nice if you could run SSIS on other environments besides Windows."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The creation of the measure in the DAC's model could be improved."
"At one point, we did have to purchase an add-on."
"Toad Data could improve by having additional features, such as query prediction. This could help someone who's not the strongest programmer. If the software could help them write queries correctly it would be very helpful, especially for small development teams or teams that lack the input skills necessary to write and program efficiently."
"On the scheduling server, some scheduled reports just sit there and never execute for the first time. After manually executing the first time, they run with no issues."
SSIS is ranked 2nd in Data Integration with 69 reviews while Toad Data Point is ranked 38th in Data Integration with 2 reviews. SSIS is rated 7.6, while Toad Data Point 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 Toad Data Point writes "Easy to learn, good connectivity to multiple data sources, and helpful supprt". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Toad Data Point is most compared with Alteryx, SAS Enterprise Guide, Oracle Data Integrator (ODI), Azure Data Factory and Denodo.
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.