Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Longview Plan
Score 5.0 out of 10
N/A
Longview Plan is a unified data integration solution from insightsoftware, used to consolidate data from ERP, HR, and CRM systems and enhance data quality and traceability with validation algorithms.N/A
SolarWinds Task Factory
Score 8.2 out of 10
N/A
According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory…N/A
Toad Data Point
Score 8.0 out of 10
N/A
Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and workflow automation.
$365
Pricing
Longview PlanSolarWinds Task FactoryToad Data Point
Editions & Modules
No answers on this topic
Task Factory
1,245 (annual subscription license)
per server
Task Factory Azure Data Factory
1,495 (annual subscription license)
per ADF node
Base Edition
$365
Pro Edition
$528
Offerings
Pricing Offerings
Longview PlanSolarWinds Task FactoryToad Data Point
Free Trial
NoYesNo
Free/Freemium Version
NoYesNo
Premium Consulting/Integration Services
NoNoNo
Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Longview PlanSolarWinds Task FactoryToad Data Point
Features
Longview PlanSolarWinds Task FactoryToad Data Point
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Longview Plan
-
Ratings
SolarWinds Task Factory
9.4
40 Ratings
13% above category average
Toad Data Point
-
Ratings
Connect to traditional data sources00 Ratings9.440 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Longview Plan
-
Ratings
SolarWinds Task Factory
9.2
39 Ratings
13% above category average
Toad Data Point
-
Ratings
Simple transformations00 Ratings8.739 Ratings00 Ratings
Complex transformations00 Ratings9.635 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Longview Plan
-
Ratings
SolarWinds Task Factory
9.4
3 Ratings
17% above category average
Toad Data Point
-
Ratings
Integration with data quality tools00 Ratings9.22 Ratings00 Ratings
Integration with MDM tools00 Ratings9.63 Ratings00 Ratings
Best Alternatives
Longview PlanSolarWinds Task FactoryToad Data Point
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 9.2 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternativesView all alternatives
User Ratings
Longview PlanSolarWinds Task FactoryToad Data Point
Likelihood to Recommend
-
(0 ratings)
8.1
(40 ratings)
7.0
(10 ratings)
Likelihood to Renew
-
(0 ratings)
8.2
(3 ratings)
-
(0 ratings)
Usability
-
(0 ratings)
9.1
(1 ratings)
10.0
(2 ratings)
Support Rating
-
(0 ratings)
9.1
(1 ratings)
-
(0 ratings)
Implementation Rating
-
(0 ratings)
8.2
(1 ratings)
-
(0 ratings)
User Testimonials
Longview PlanSolarWinds Task FactoryToad Data Point
Likelihood to Recommend
Insightsoftware, Inc
No answers on this topic
SolarWinds
Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.
Read full review
Quest Software
Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review
Pros
Insightsoftware, Inc
No answers on this topic
SolarWinds
  • The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
  • Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
  • The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
Read full review
Quest Software
  • Export data into excel.
  • Export data into excel using a pivot table functionality.
  • Navigation between windows is intuitive and easy to understand.
  • Good for SQL novices and experts alike.
Read full review
Cons
Insightsoftware, Inc
No answers on this topic
SolarWinds
  • It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
  • Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
  • Occasional random failures observed with the Filter tranform.
Read full review
Quest Software
  • The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now.
  • Would be nice if the 'Automate' feature was a bit easier to use.
  • Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release).
  • Would be nice if there were fewer releases.
Read full review
Likelihood to Renew
Insightsoftware, Inc
No answers on this topic
SolarWinds
Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business
Read full review
Quest Software
No answers on this topic
Usability
Insightsoftware, Inc
No answers on this topic
SolarWinds
Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get
Read full review
Quest Software
I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review
Support Rating
Insightsoftware, Inc
No answers on this topic
SolarWinds
Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues.
Read full review
Quest Software
No answers on this topic
Implementation Rating
Insightsoftware, Inc
No answers on this topic
SolarWinds
Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us.
Read full review
Quest Software
No answers on this topic
Alternatives Considered
Insightsoftware, Inc
No answers on this topic
SolarWinds
ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and simple to use.
Read full review
Quest Software
Although Toad and UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review
Return on Investment
Insightsoftware, Inc
No answers on this topic
SolarWinds
  • We were able to support our developers with Task Factory features and reduce the development time by 40%.
  • Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward.
Read full review
Quest Software
  • It is the least common denominator - not particularly optimized for our environment or workflows.
  • Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
  • Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
  • It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.
Read full review
ScreenShots

SolarWinds Task Factory Screenshots

Screenshot of Salesforce.com SourceScreenshot of Dimension Merge SCD TransformScreenshot of Upsert DestinationScreenshot of REST Source