We performed a comparison between SSIS and Toad Data Point based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The initial setup of this solution is very straightforward."
"It is easy to set up. The deployment is also very quick."
"It has good data integration and good processes."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"It's already very user-friendly and has a good dashboard."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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 setup is straightforward. It's very easy to install."
"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."
"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."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"It would be nice if you could run SSIS on other environments besides Windows."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"I would like to see more features in terms of the integration with Azure Data Factory."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"We'd like them to develop data exploration more."
"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 39th 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 SAS Enterprise Guide, Alteryx, Oracle Data Integrator (ODI), Azure Data Factory and Denodo. See our SSIS vs. Toad Data Point report.
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.