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 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."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"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."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It is easy to set up the product."
"SSIS is easy to use."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"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."
"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."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Video training would be a helpful addition."
"The security could be improved, as it is more important in our context."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"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."
"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."
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.