TrustRadius Insights
Upsert Component: Highly praised for its simplicity and ease of use, the Upsert component in Task Factory has been mentioned by several …
Overview
What is SolarWinds Task Factory?
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…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Complex transformations (35)9.696%
- Connect to traditional data sources (40)9.494%
- Simple transformations (39)8.787%
Pricing
Task Factory
1,245 (annual subscription license)
On Premise
per server
Task Factory Azure Data Factory
1,495 (annual subscription license)
On Premise
per ADF node
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://www.sentryone.com/products/task…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Features
Return to navigation
Product Details
- About
- Integrations
- Tech Details
- Downloadables
What is SolarWinds Task Factory?
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 on an Azure-SSIS Integration Runtime (IR) with Task Factory Azure Data Factory edition.
SolarWinds Task Factory Features
Data Source Connection Features
- Supported: Connect to traditional data sources
Data Transformations Features
- Supported: Simple transformations
- Supported: Complex transformations
Data Governance Features
- Supported: Integration with data quality tools
- Supported: Integration with MDM tools
SolarWinds Task Factory Screenshots
SolarWinds Task Factory Integrations
- Microsoft SQL Server
- Salesforce Sales Cloud
- Microsoft Dynamics 365
- Microsoft SharePoint
- Azure Machine Learning
- REST
SolarWinds Task Factory Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
SolarWinds Task Factory Downloadables
Comparisons
Compare with
Reviews and Ratings
(64)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Pros
- Cons
Upsert Component: Highly praised for its simplicity and ease of use, the Upsert component in Task Factory has been mentioned by several users as a valuable feature. Users appreciate that with just a few clicks, they can perform merge operations without the complexities of writing code.
Extended Functionality: Many users find Task Factory to be highly beneficial due to its ability to extend the functionality of native SSIS components. This aspect allows them to work with a wider range of data sources and perform tasks that would otherwise be challenging with only native components.
Seamless Integration: The seamless integration capabilities of Task Factory have been highlighted by users. They mention specific use cases such as integrating with partners' Secure FTP sites, working with Excel, and sending out emails using partners' SMTP servers. Users appreciate how Task Factory simplifies these tasks and saves them significant time.
Challenging execution against non-licensed servers: Some users have found it challenging to execute packages against servers that do not have proper licenses, which has required them to search for alternative solutions or workarounds.
Lack of detailed logging for errors: Users have expressed a strong desire for more comprehensive and detailed logging capabilities when components encounter errors. This would enable better troubleshooting and analysis of issues during package execution.
Lack of notifications for software updates: Several users have mentioned that they were not notified or alerted when new versions of the software became available. This lack of notification caused them to miss out on important updates and improvements to the product.
Attribute Ratings
Reviews
(26-40 of 40)Companies can't remove reviews or game the system. Here's why
August 19, 2019
Task Factory Delivers!
Used for data ETL and interfacing between databases and packages.
- Data validation
- Data cleaning
- Quickly building interfaces between databases, non-database sources, and packages.
- Would like to see more detailed documentation and examples.
August 01, 2019
Task Factory simplifies your workflow
Used by the BI department. Simplifies some file & SQL related transformations.
- File related tasks.
- PGP tasks.
- Web related tasks.
- Create a snowflake transform - source & destination.
- simplify SCD transform - too many options.
July 30, 2019
Worth a try!
We use Task Factory on the BI team to help with data connectors in SSIS and with tracking our nightly jobs. This solves writing custom code to handle certain data connectors.
- Job management
- Data Connectors
- Easy to Use
- It is hard to justify keeping a license when your platforms are adding the same functionality that Task Factory provides. This must keep ahead of software providers to justify the use.
July 19, 2019
A complete package of additional tasks for SSIS
In our department, we use continuously and for several years Task Factory for the development of ETL through Micorosft Integration Services. I can assure you that it is absolutely an excellent product, without it the development of complex packages would certainly be longer, both in terms of time and in terms of effort in developing a lean and fast process.
- Great time gain in terms of development.
- Seamless integration with Integration Services.
- It has an excellent component for developing SCD tasks.
- It is an excellent program but it is obviously paid.
- The license must be renewed regularly if the product is to be updated.
- If you change visual studio version you need to update to the latest versions.
July 17, 2019
Better quality outcomes with less code cutting
Task Factory is used within our Business Systems team for the development of SSIS packages for ETLs into our data warehouse and other applications.
It speeds up development time by adding very useful transforms that are easier to use than the standard Microsoft transforms as well. It makes debugging and development faster.
It speeds up development time by adding very useful transforms that are easier to use than the standard Microsoft transforms as well. It makes debugging and development faster.
- Expression editor is by far better than that in standard SSRS.
- The SharePoint destination and source is much easier to use than standard SSRS.
- The slowly changing dimension transform is very easy to use and adds a level of capability that gives a better outcome.
- More worked examples in the help.
June 22, 2019
Task Factory is great day to day
We're using Task Factory in our data warehouse processes. It helps solve various data cleanup and data flow problems.
June 02, 2019
#1 SSIS plug-ins
It's used as the ETL tool for our data warehouse, which has impact on many departments and applications.
- Slow changing dimension component helps the Data Warehouse ETL process
- Salesforce source/destination component helps the integration
- SFTP component is very useful
- Slow changing dimension component has some bug on the hash key comparison
May 29, 2019
Solve the problem without coding
We mainly use Task Factory to connect to third-party data source via REST. We were looking for a third-party connector of SSIS for Google Analytics in 2018. After evaluating a couple of vendors, we purchased Task Factory. It is mainly used by the Business Reporting Analytics team for ETL purposes.
- Retrieve data from various REST sources
- Data cleansing
- Data importing
- Offer more options in UI for different configurations of REST sources
- More details in documents
- It appears that REST connectors do not work well with Okta in place.
May 28, 2019
Good for any non trivial SSIS project
Task Factory is used by IT and Research. It is used in the ETL process in the data warehouse, and also many aux SSIS projects that involve moving data from one source to another. It is also used in various migration and data restructuring projects.
- It provides some less common connectors such as SFTP.
- The PGP component is very easy to use as it support a cross platform encryption standard.
- The Upsert Destination is vastly superior than the build in ADO or OLE destination.
- The PGP task involves some hardcode parameter.
- The Surrogate key component does not fetch a new key automatically based on the current maximum key.
We purchased Task Factory for one purpose - to connect to our production and development Dynamics 365 CRM environments via SSIS to internal SQL Servers for SSRS reporting.
- Relatively easy to set up and use on a SQL Server.
- Works like other connections in SSIS packages.
- When Microsoft upgraded our Dynamics 365 install from version 8 to 9, we delayed the upgrade for several months. Once we moved our dev platform to version 9, Task Factory stopped working. After we pushed every delay we reasonably could in prod, Task Factory had still not been updated to work with version 9 of Dynamics 365. In the interim we tried another product that had already been updated in lockstep with Microsoft. The Task Factory folks seemed to indicate that they knew about the problems when we called, and sent us a hotfix eventually after two or three months. However, the delay convinced us to go to another product.
- Weird or incorrect metadata in Dynamics 365 caused problems with the SSIS job whenever field changes were made in Dynamics 365. While this might not be the fault of Task Factory per se, our replacement product doesn't have this issue.
We use Task Factory to fill in the missing pieces in the SSIS toolbox.
- Task Factory is intuitive and very easy to roll out.
- Versus the cost of paying for other tools or expensive custom development work, Task Factory is a deal.
- No complaints whatsoever about Task Factory. It does everything we expect it to do and performs well.
April 27, 2019
SFTP: don't try it without Task Factory
We now use Task Factory primarily for Secure FTP, however, we originally purchased it for the ability to read and extract data from emails. We have a number of interfaces in various departments that require exchanging data with third parties via SFTP and Task Factory handles this need excellently.
- SFTP
- Better documentation/help. Task Factory is powerful but I have had to search the web for examples of how to configure things.
April 20, 2019
Thumbs Up for Task Factory!
Task Factory was selected for two primary reasons. First and foremost, because of the extensive library of functions it makes available in SSIS to ease the SSIS programmer's job of importing and cleansing data. Second, because of the logging and notification features that it makes available which allow us to easily track the record counts of data we imported and easily notify us if there are issues with the execution of an SSIS process. Task Factory is used by our IT department, but we import data from 15-20 State agencies, so it indirectly affects many of our processes.
- Better data cleansing and validation functions than are available in basic SSIS.
- Better database insert and update functions than in SSIS.
- Ease of use of functions provided.
- Re-introduce the prior feature to allow a user to copy or move SSIS variables from one package or scope to another.
- Provide a better upgrade path from one version of the product to another higher version. Our upgrade from 2008 to 2016 was quite complex and it seemed as though we might have been the first such upgrade Pragmatic Works had encountered.
April 06, 2019
Stop banging your head against the wall and get the tools to blow through it! Get Task Factory!
We use several components in our daily process to import data into our data warehouse. It allowed us to easily import Sharepoint data and grab emailed Excel attachments to process. It made it easier to accept and parse JSON data.
- The ability to use the email source to play with individual messages in a mailbox is key. We get a lot of attachments that we download based on attachment extension and subject content to place them in network directories for further processing.
- The ability to pull from Sharepoint lists that easily was a game changer. We can allow our users to maintain content that we can then consume and push to our data warehouse.
- The REST source was easy to implement and utilize to pull data from vendor APIs.
- The documentation could use some polishing, though I have seen significant improvement now that SentryOne took over.
- Prebuilt templates or examples available for use to jumpstart development efforts.
March 21, 2017
Task Factory Review
Task Factory is implemented by our database development and BI teams for use in supporting ETL requests from all departments within the organization. Task Factory has streamlined the process of loading data from many disparate data sources including flat files, Excel, XML, other database and cloud platforms. What could take many hours to write in SQL or to derive in native Microsoft SSIS components now takes as little as a few minutes to implement with Task Factory.
- 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.
- Limited to only running on a licensed server or in BIDS. We have development servers that require licensing as well, but I've had to get creative to be able to execute packages against non-licensed servers.
- Wish the logging was more detailed when components error.
- Not alerted when a new version is available.