Filter Ratings and Reviews
Filter 56 vetted Task Factory reviews and ratings
Reviews (1-25 of 37)
Companies can't remove reviews or game the system. Here's why.
We have been using Task Factory to better standardize our ETL and to reduce the number of script tasks leveraged. It is primarily used for data flow and control flow tasks, although some connections are used as well. This is used as a standard, centralized tool within IT, along with other 3rd party SSIS tools.
- Email notifications.
- File management.
- User defined settings for external package calls.
- Better software update methodology.
Yes it has. I do not have a quantifiable amount of time savings, but it is considerable where script tasks were the only option previously available. We have been retiring off old script tasks, making maintenance/administration easier as well. This will also provide faster ramp-up for new developers as it is simpler to understand what the package components are doing as you do not have to interrogate the scripts.
Our prima facie need was to increase the speed for loading our data warehouses. We used SSIS, and needed an easy way to convert to bulk updates and deletes. Task Factory offers several tools that reduce our load time by about 60 times. These are Upsert, Bulk Update and Bulk delete. We were already using the SSIS fast load, but had we had Task Factory earlier, it would have saved a huge amount of development. We have used a few of the other tools as well, but unfortunately, our addition of Task Factory was retrofit and not new development.
- Fast, large updates and deletes.
- Simple Upsert logic.
- Very nice integrated help, including video.
- Easy to install, well documented, and easy to use.
- Support was excellent under Pragmatic Works. I cannot attest to Sentry One.
- We had one case of an upgrade that would not work with existing code. They did release a next version very quickly.
Compared with major rewrites to force SQL and SSIS to do bulk updates, Task Factory saved us a few man-years. Our alternative likely would have been much more expensive hardware, if Task Factory were not available.
We are heavy SQL Server Integration Services shop. There are a number of instances where we were faced with hand-coding solutions that would take hours or days to implement, but with Task Factory we were able to do it in seconds. We have a large number of highly visible, customer-facing processes that depend on Task Factory, and it has been very reliable and easy to use.
- Our first use case was integrating with our Partners' Secure FTP Sites. Task Factory did this seamlessly.
- Our second use case involved Excel. We have multiple groups that use Excel to monitor their processes, and using the Excel refresh task made this very quick and simple.
- Our third use case was for SMTP. The basic SMTP did not give us enough control out of the box that we needed. We send out E-mails on behalf of our partners using their SMTP servers, so being able to change those connections effortlessly using this task was a huge time saver.
- Not sure. I have not run into an instance where their transform didn't provide what I needed more easily than other solutions.
Before we purchased Task Factory we had already spent about 2 man-weeks on different solutions that would almost work. Once we installed Task Factory we had the original need changed and implemented into production in under an hour. If we would have had Task Factory from the beginning, we would have saved thousands in development costs.
April 14, 2020
Task Factory is used by the BI and the Integration Department. It helps us to standardize the way we are extracting and transforming data into our data warehouse and also the way we are connecting different applications (CRM and ERP).
- The Slowly Changing Dimension Component saves us a huge amount if time compared to the native SSIS component.
- JSON Transform is really useful to convert record and send it to rest API.
- The advanced derived columns allow us to use really cool functions that are not available in the regular transforms.
- We were disappointed that the Marketto Connector has been retired from the components.
- We had a problem integrating Task Factory with LegiTest (license problem). It took a lot of time for Sentry to find and fix this problem
We replaced multiple native components like SCD, derived column, and lookup. TF allowed us to increase the speed of development and also improve execution time. The Lookup increased our lookup efficiency by 1000% because it avoids the reloading in a loop scenario.
We use Task Factory within our team. We have a need to ensure efficient ETL design to drive our high-performing data-centric application. Task Factory helps us reduce development time spent programming custom SSIS tasks, gives us components and tasks that are optimized to perform well in production, and a broad array of connections to various data platforms.
- One-click Auditing Feature. Simply push a button, and all of your SSIS packages now have detailed auditing built-in, including the ability to watch it in real-time.
- Wide variety of connections. If you need to connect to a common data source, Task factory will have what you need. No need to roll your own anymore.
- The Upsert Component. Task Factory has a simple and FAST way to do an insert or update with new row data. It just works and works well.
- SCD component could be a little more intuitive.
- The help documents could be more detailed and current with what is actually released.
Yes, so much yes. Everything Task Factory does is about increasing productivity. It does this by taking the things you normally would have to create yourself or spend a lot of time setting up your self and just gives you something to work with right out of the box. Need to audit all of your packages? ONE BUTTON CLICK and all of your packages now have detailed auditing. That alone is worth many times the cost of the software.
April 28, 2020
Usage: We are using Task Factory inside the IT department to enhance the capabilities of SSIS (SQL Server Integration services).
Business problem: Your team can keep using SSIS and tackle data problems they could not resolve before (read from different sources without any code and do data upsert in one component).
Business problem: Your team can keep using SSIS and tackle data problems they could not resolve before (read from different sources without any code and do data upsert in one component).
- Read from APIs without code.
- Upset mechanism.
- Can be longer to debug.
- Need one license for dev servers.
One of our biggest projects was done using Task Factory. We had to extract data from an OData partner into our own databases. With Task Factory, we were able to complete these projects without using our Programmer team. We only used SSIS developers. That was huge for us because we were able to keep the programmers in other projects.
April 23, 2020
Task Factory is used to support our SQL Server Integration Services (SSIS) needs. SSIS has many tasks built in but we have found they fall short of our needs and Task Factory fills that gap for us. The components provided are well designed and easy to configure for the package to use and allow parameters to be configured for ease of use across environments.
- The SFTP task is particularly helpful with proxy capabilities and setup with environment variables.
- The RestAPI task is something new that we have found helpful now.
- The latest UpSert task has also been a great addition.
- I thought it needed to improve the UpSert task to include delete capabilities but was informed it is present. Just might be useful to be more apparent to an infrequent user.
I am certain if I had been required to do things I do without Task Factory my work would have been far more complicated. We have had Task Factory since before I arrived, but I do see older packages that existed before this purchase and see easily how much more difficult things had been previously.
April 21, 2020
I use the tools mainly for the slowly changing dimensions as we load our warehouse.
- Slowly changing dimensions.
- Error logging during the process.
- Ease of setup.
- The ability to move records to different tables based on the data.
- None
It has been very helpful in the time savings aera where the slowly changing dimensions are concerned.
November 23, 2019
Task Factory is used in the IT department only. It addresses the need for data connections and transformations that are not included in the base SQL Server Integrations Services system.
- Tasks are more automated than having to create them by hand.
- Support is great either in forum settings or direct contact with support.
- Maybe ensuring that all assemblies are deleted when having to install Task Factory on the server.
Agreed. I would guess that 25% of my time has been saved.
February 27, 2020
Task Factory is being used by the IT BI department. It is part of our daily SSIS processes, for example, reads from XML or JSON sources, extracts from websites, compresses and decompresses zip files, handles data to be inserted or updated on tables, parses address information, sends email on different stages of the process.
Specifically, we can use it to download a zip file and decompress it and later use TF Upsert to update or insert zip code data into tables.
Specifically, we can use it to download a zip file and decompress it and later use TF Upsert to update or insert zip code data into tables.
- Upsert data on dimensions
- Read XML and JSON information from website
- Allow Upsert to just load bulk data
Reading and parsing XML and JSON are easy with Task Factory.
March 25, 2020
Task Factory is being used to integrate to a number of external organisations and data sources so it can be loaded into our organisations data warehouse. It helps make the integrations through SSIS very easy and simple using Task Factory's connectors. The main connector we are using it for is the Salesforce ones which are simple and effective.
- Easy to install.
- Easy to use.
- Great support if stuck.
- New connectors are not released very often.
- Updating the connectors is not an easy task.
- Troubleshooting a problem can be difficult.
Task Factory has saved the organisation a lot of time by extending the native SSIS components without any programming our side. This has led to increased productivity as well as being able to get our Warehouse up and running very quickly. The benefit has outweighed the cost of purchase and I would recommend it.
Our Data Integration team uses Task Factory as a 3rd-party plugin tool to support Microsoft SSIS packages. Task Factory makes our job simple in terms of connecting to "CRM", "SharePoint" or to pull data/files from a web service where we don't need to write a C# code to get this done. Also, it seems very effective when doing encryption and decryption techniques.
- Task Factory does a pretty good job in terms of connecting to any 3rd-party website/Web API/CRM and downloading/uploading files into them without using any program code.
- Task Factory makes it easier to encrypt/decrypt incoming/outgoing files.
- I believe they should improve the "address parser" feature where it simply parses the incoming address but didn't check/verify whether the incoming address is valid (or) checks whether the address has USPS address standard format.
Yes. Task Factory has helped our team to reduce the development time by 40%.
November 01, 2019
Used and implemented by my team , serving company needs . Connecting to REST API.
- Rest API
- FIle properties
- Secure FTP task
- Upsert
- Amazon Connectors
- S3 Connectors
- Red Shift Connectors
- Tableau Connectors
Sure, nothing to gauge here but has saved considerable time.
October 28, 2019
Our Business and Application Reporting team is using this tool. We are using this to take the data from our Salesforce org into a data warehouse. Once the data is there we use it to create Microsoft Power BI reports. Also we use Task Factory to upsert data into Salesforce for any data migration projects. This has solved a numerous amount of issues regarding moving Salesforce data in and out of our data warehouse and other ETL.
- Upsert Salesforce data.
- It is simple to use.
- Very straightforward upgrade process.
- Continually getting new features that are useful.
- More drag and drop interfacing.
- Modernize the UI.
I concur that Task Factory has been designed to extend native SSIS components without programming in order to increase productivity and save time. This has saved our team a ton of time.
It was initially used to upload and download data from Salesforce. It was then used as part of our ETL to load data for Analysis Services models, both MOLAP and Tabular.
- Connect and access data in Salesforce
- Slowly changing dimensions task
- Error codes and descriptions
- I haven't used enough in recent months to suggest improvements.
October 09, 2019
Purchased for Salesforce connectivity from our SQL Server platform. We have since leveraged other features such as Upsert.
It is used in support of our organization-wide data warehouse.
It is used in support of our organization-wide data warehouse.
- Upsert - simplifies coding.
- Facilitates an odbc connection to the Sales Force world without the complication of using APIs.
- Various other utilities to simplify ETL development.
- We have run into compatibility issues or low level problems between SQL server and Task Factory. Working with both SentryOne and Microsoft, they both ended up blaming each other and not offering a fix.
The Salesforce connectors have allowed my existing team to easily write integrations with Salesforce without having to learn or build coding skillsets for the use of APIs.
The Upsert framework avoids developers from having to redundantly code upsert-like functionality.
The Upsert framework avoids developers from having to redundantly code upsert-like functionality.
November 18, 2019
We use it for linking our SQL DB to the Salesforce cloud connection for data integration and a variety of other data processing components.
- Easy to install, use and learn with basic SQL and SSIS knowledge.
- Wider component selection available for different use cases.
- I don't have any issues with the program.
It's saved the development of integration services and data manipulation time by more than 80%. Depending on which use case the system can be automated.
Helps us send data securely to vendors.
- Email templates.
- Secure file transmissions.
- Rest API.
- Can’t think of any.
Yes, SFTP and rest API.
I am testing Task Factory features and functionality to determine if it's a good fit for our organization. It is currently not widely implemented across the business, but there is potential for it if the POC proves viable. I am primarily looking at Task Factory to replace cumbersome, manual API calls and to streamline data flow from 3rd parties into our internal data warehouses.
- Good SSIS integration with other packages and processes.
- Easy to configure 3rd party account logins, credentials, etc.
- Intuitive interfaces.
- The user-experience could be a little more intuitive. Struggled a bit to put all the pieces together the right way in order to get the data processed the way I needed.
The need for programming is definitely diminished while using Task Factory. While the need for programming knowledge and expertise is not completely eliminated, it is certainly reduced such that wider adoption of SSIS components along with Task Factory can be easily achieved. All in all Task Factory will likely save 2-3 man-hours per week simply in its ability to automate tasks that previously required manual updating.
August 19, 2019
We are using Task Factory in our daily ETL processes. These processes are built and maintained by the Business Intelligence department
- The task to call another package in a different solution
- Advanced lookup and other tasks
- Improvement can be achieved when new releases are tested better. We had a few times that our ETL stopped when implementing a new release.
It has and it's hard to say how much time, but we save a few hours daily since it runs fully automatic.
July 19, 2019
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.
Without the use of task factory, a lot of ETL processes should be developed with much more cumbersome architectures, the controls on moving data should be done manually, requiring much more development time but also data processing time. Another example can also be the upload to SFTP areas that through task factory is managed very simply with a specific task. In short, it is really very very comfortable.
July 16, 2019
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.
Yes it has, especially on complex transformations with extensive cleansing required. The trim and null handling functions remove the need for script components.
September 10, 2019
The main reason we purchased Task Factory was to decrease the time to do Upserts into SQL Server and Oracle databases. Without it, developers would manually have to do lookups/inserts/updates in SSIS.
Although this was the main reason for the purchase, there are so many other components we use in SSIS like the termination task, the Sharepoint task, and the email task. Some of these tasks seem like "no brainers" that should be in SSIS by default!
Although this was the main reason for the purchase, there are so many other components we use in SSIS like the termination task, the Sharepoint task, and the email task. Some of these tasks seem like "no brainers" that should be in SSIS by default!
- Upserts to Oracle and SQL Server
- Email
- Secure FTP
- Cleaning up DB objects when Upserts fail
May 14, 2019
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.
So, Task Factory did provide extended SSIS components for Dynamics 365. However, since they were not able to keep up with the pace of Microsoft's updates to Dynamics 365, the productivity and time saving benefits were limited, as we had to find another competing product to replace that functionality. I have no idea whether this is the case for other platforms, but we came away disappointed.
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.
Task Factory has reduced design, development and test time by 75%.
Task Factory Scorecard Summary
Feature Scorecard Summary
What is Task Factory?
According to the vendor, Task Factory offers high-performance components and tasks for SQL Server Integration Services (SSIS) that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks. With more than 70 components, Task Factory helps you connect to nearly any data source, increase productivity, improve the performance of your data-centric applications, and load and manage your data warehouse.
Task Factory components include:
Dimension Merge SCD Transform
Upsert Destination
Fact Table Destination
REST Source/Destination
Salesforce.com Source/Destination
Microsoft Dynamics CRM Source/Destination
Secure FTP Task
File Gateway Task
Data Cleansing Transform
Data Validation Transform
Error Output Description Transform
PGP Encryption Task
Unpack Data Transform
XML Destination
XML Generator Transform
Categories: Database Management, Data Integration
Task Factory Screenshots
Task Factory Videos (7)
Task Factory Integrations
Microsoft SQL Server, Salesforce.com, Microsoft SharePoint, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Twitter, Facebook, Azure Machine Learning, REST
Task Factory Competitors
Microsoft SQL Server Native SSIS Components, Codeplex, Devart
Task Factory Pricing
- Has featureFree Trial Available?Yes
- Has featureFree or Freemium Version Available?Yes
- Has featurePremium Consulting/Integration Services Available?Yes
- Entry-level set up fee?No
| Edition | Pricing Details | Terms |
|---|---|---|
| Task Factory | 1,245 (annual subscription license) | per server |
| Task Factory Azure Data Factory | 1,495 (annual subscription license) | per ADF node |
| Task Factory Modules | $425-$795 (annual subscription license) | per server |
Task Factory Standard and Pro editions are licensed per server instance, with the exception of clustered servers. Each cluster within a cluster group must have a Task Factory license. Task Factory Azure Data Factory edition is licensed per Azure Data Factory node. A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT. Please contact sales@sentryone.com for more information.
For the latest information on pricing, visit https://www.sentryone.com/products/task-factory/features
Task Factory Customer Size Distribution
| Consumers | 0% | |
| Small Businesses (1-50 employees) | 0% | |
| Mid-Size Companies (51-500 employees) | 25% | |
| Enterprises (> 500 employees) | 75% |
Task Factory Support Options
| Free Version | Paid Version | |
|---|---|---|
| Phone | ||
| Live Chat | ||
| Forum/Community | ||
| FAQ/Knowledgebase | ||
| Social Media | ||
| Video Tutorials / Webinar |
Task Factory Technical Details
| Deployment Types: | On-premise |
|---|---|
| Operating Systems: | Windows |
| Mobile Application: | No |
| Supported Languages: | English |