SolarWinds Task Factory

SolarWinds Task Factory

4.6 (37)
Write a Review!
Data integration tool with SSIS components

About SolarWinds Task Factory

Task Factory is a data integration tool designed to help businesses utilize SQL Server Integration Services (SSIS) components to improve extract, transform, load (ETL) processes. The Secure FTP Task supports Secure Shell Protocol (SSH), Hypertext Transfer Protocol (HTTP), and SOCKet Secure (SOCKS4) protocols whilst allowing organizations to transmit files across various channels.

Task Factory's SSIS Email Source Adapter filters emails based on sender, subject, date, body or priority and supports Internet Message Access Protocol (IMAP), Post Office Protocol (POP3), and more. Data Validation Transform collects and verifies phone numbers, email addresses, and Social Security numbers (SSN), among other information from various sources. Businesses can also manage and load data warehouses and utilize the Task Factory Azure Data Factory edition to run SSIS packages in the cloud.

Using Task Factory's REST API, businesses can connect and extract data from any cloud application or web service, such as GoToWebinar, Zendesk, SurveyMonkey, Facebook, Salesforce, and more.


Key benefits of SolarWinds Task Factory

Save time on tedious ETL tasks, efficiently develop data-centric apps, and connect to cloud data sources with SolarWinds Task Factory.


Images

SolarWinds Task Factory Software - SolarWinds Task Factory SSIS toolbox
SolarWinds Task Factory Software - SolarWinds Task Factory XML Generator Transform
SolarWinds Task Factory Software - SolarWinds Task Factory FTP Browser
View 4 more
SolarWinds Task Factory video
SolarWinds Task Factory Software - SolarWinds Task Factory SSIS toolbox
SolarWinds Task Factory Software - SolarWinds Task Factory XML Generator Transform
SolarWinds Task Factory Software - SolarWinds Task Factory FTP Browser

Not sure about SolarWinds Task Factory? Compare with a popular alternative

SolarWinds Task Factory

4.6 (37)
VS.

Starting Price

US$1,245.00
year
No pricing found

Pricing Options

Free version
Free trial
Free version
Free trial

Features

15
119

Integrations

3
48

Ease of Use

4.4 (37)
4.0 (26)

Value for Money

4.5 (37)
4.2 (26)

Customer Service

4.6 (37)
4.5 (26)
Green rating bars show the winning product based on the average rating and number of reviews.

Alternatives

Adverity

4.5
#1 Alternative to SolarWinds Task Factory
With 600+ data connectors and destinations, Adverity helps marketing and analyst teams improve performance and trust...

Supermetrics

4.4
#2 Alternative to SolarWinds Task Factory
All your marketing data, wherever you need it. Supermetrics streamlines the delivery of data from 80+ sales and...

Hevo

4.7
#3 Alternative to SolarWinds Task Factory
Hevo is a no-code, bi-directional data pipeline technology designed specifically for advanced ETL, ELT, and Reverse ETL...

Jaspersoft

4.2
#4 Alternative to SolarWinds Task Factory
Jaspersoft helps you deliver the reporting and analytics your customers want, without burdening your development team.

Reviews

Overall rating

4.6 /5
(37)
Value for Money
4.5/5
Features
4.4/5
Ease of Use
4.4/5
Customer Support
4.6/5

Already have SolarWinds Task Factory?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Showing 5 reviews of 37
Jennyfer
Jennyfer
Overall rating
  • Industry: Construction
  • Company size: 1,001–5,000 Employees
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

I frequently use Task Factory in the SSIS package I create for integration between system.

Reviewed on 2017/11/02

I am able to solve problems in a single SSIS package vs using SSIS and Linux scripts.

I am able to solve problems in a single SSIS package vs using SSIS and Linux scripts.

Pros

Task Factory really expands the types of tasks that are available in SSIS. We have used Secure FTP Task, PGP task, and Advanced Email to accomplish complex scenarios that we had to use custom scripts to accomplish before. This is helping us reduce our footprint because we are phasing out a Linux server we have that used to encrypt and move files back and forth between secure FTP sites. We are able to replace everything this Linux server was doing with script with a single SSIS package thanks to the Task Factory tasks. I especially like the "TF Error Output Description" and have used it many times in troubleshoot failures. I don't know what I did before this feature! There are so many more features that Task Factory has that I'm excited to explore. When I have a problem I'm trying to solve in SSIS, my new attitude is "I bet Task Factory can do that!"

Cons

Sometimes I have trouble finding which feature will accomplish what I need. For example, I needed to have a unique number generated for each row in a flow but use the last number as the new starting number. After some investigation I found that I can easily accomplish that with the "Surrogate Key Transform" it just took me a while to figure out that was the task I needed.

Verified Reviewer
Overall rating
  • Industry: Management Consulting
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Amazing tool!

Reviewed on 2018/02/16

Pros

Easy installation and integration to your project, user friendly controls, lots of features to connect to on-premise and cloud services. Free license for development. The customer support is very helpful and responsive.

Cons

While there is nothing much that's missing on this tool, I would also like to see something related to posting/downloading files from Cloud Storage services like GoogleDrive or Dropbox.

Floris Jan
Overall rating
  • Industry: Information Technology & Services
  • Company size: 11–50 Employees
  • Used Monthly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

With Task Factory we implemented the integration with Salesforce and other systems quick and...

Reviewed on 2017/08/10

Pros

The software is easy to use and has a lot of features. When creating SSIS flows, sometimes I am surprised to learn about a feature I didn't use before.

Cons

Sometimes the software 'thinks' a little bit too much. Changes in upstream columns trigger the automatic column matching process. Sometimes this breaks existing functionality.

Mathew
Mathew
Overall rating
  • Industry: Pharmaceuticals
  • Company size: 501–1,000 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Awesome

Reviewed on 2017/11/16

Massive speed improvement over built in Microsoft SSIS components.

Massive speed improvement over built in Microsoft SSIS components.

Pros

I've always been on the fence on third party SSIS components, due to them not being built in Microsoft products, but the Upsert Destination is amazing, and the Advanced Cache Lookup components are crazy fast. I pump at least a trillion rows a day through them.

Cons

SCD was hard to understand, and support takes a little while to get back to you, so I ended up figuring it out on my own.

Jason
Overall rating
  • Industry: Information Technology & Services
  • Company size: 51–200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

As a heavy user of SSIS I have found Task Factory to be an essential add-on.

Reviewed on 2017/08/31

Enables me to implement a work load that would of taken much longer or required more developers.

Enables me to implement a work load that would of taken much longer or required more developers.

Pros

Massively reduces development time.
Reduces complexity of package design thus making packages easier to maintain.
Replaces many script tasks jobs for which you would have to write substantial code.
My favourite components are the Update/Upsert Tasks as they remove the need for writing a lot of SQL plumbing code.

Cons

None

Response from SolarWinds

Thank you for the feedback, Jason. We really appreciate it.

On the item you mention on Visual Studio upgrades, please note that the Visual Studio SSIS toolbox doesn't read it's information from the GAC, it uses folders under [YourSQLServerInstallFolder]\[version]\DTS. The Task Factory installer installs into this folder if it exists, but if you upgrade the version of SSIS installed, you need to reinstall TF afterward to ensure it puts the components in the newly created SSIS folders.

Showing 5 reviews of 37 Read all reviews

SolarWinds Task Factory FAQs

Below are some frequently asked questions for SolarWinds Task Factory.

SolarWinds Task Factory offers the following pricing plans:

  • Starting from: US$1,245.00/year
  • Pricing model: Subscription
  • Free Trial: Available

$1,245.00 per license, per server plus $359/year required maintenance fee

SolarWinds Task Factory has the following typical customers:

Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000

SolarWinds Task Factory supports the following languages:

Chinese, English, French, German, Japanese, Korean, Portuguese, Spanish

SolarWinds Task Factory supports the following devices:

SolarWinds Task Factory integrates with the following applications:

Salesforce.org Nonprofit Cloud, SurveyMonkey, Zendesk Suite

SolarWinds Task Factory offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep), Chat

Related categories

See all software categories found for SolarWinds Task Factory.