Filter Ratings and Reviews
Filter 44 vetted Task Factory reviews and ratings
Reviews (1-25 of 28)
August 26, 2019
Streamlined data processes
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.
August 19, 2019
Task Factory made things possible
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.
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 16, 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.
May 29, 2019
Love Task Factory!
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.
September 10, 2019
Task Factory saves vast amounts of time
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
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.
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.
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 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.
November 01, 2019
Good tool but needs to catch up to the competition
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
October 28, 2019
Salesforce just got easier due to Task Factory
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.
October 25, 2019
Task Factory Review
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
Helpful supplement to our SQL Server's base offerings
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.
September 10, 2019
Task Factory Makes ETL Development Easier
My department's role is to support business intelligence reporting of ITIL process areas. We are currently using Task Factory to perform ETL processing and data warehouse processing. We utilize the email task to send our reports in pdf format, and we also rely on the data warehouse fact processing task and the dimension processing task as it makes processing much smoother and easier to manage.
- Advanced Email task makes it easier for an end-user to configure.
- Fact Load task makes the data flow much easier to manage than the OOTB lookup function in SSIS.
- Dimension Load task makes it easier to track multiple dimension types when loading into the DB.
- Would really like to see an SSRS generate PDF output with parameter input.
- Load improvement for larger datasets in the Upsert function.
- Consistency with expressions for every task.
August 28, 2019
A Package for your Packages!
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.
November 18, 2019
Task Factory's Integration with Salesforce
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.
October 09, 2019
Less coding for SSIS
Helps us send data securely to vendors.
- Email templates.
- Secure file transmissions.
- Rest API.
- Can’t think of any.
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.
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.
June 21, 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.
Read this authenticated review
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 bought Task Factory primarily for the bulk update and bulk task delete features. At the time we were looking to expand our customer base and all claim data related to it by four fold. By using Task factory within our SSIS, we were able to handle the extra load by only implementing the upsert and bulk updates into our existing integrations. There are a few other tools we also use, but bulk updating alone has more than paid for itself.
- Bulk update, upsert and delete tasks.
- Most tools work better than standard SSIS tools.
- Built-in documentation is a plus.
- I have not tried the generic nugget tools but would like to someday.
- A full upsert with insert, update, and delete would be useful.
- A full merge function that compares and makes all changes, including documenting either counts or by data that had to be corrected to synchronize.
April 19, 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.
- 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.
Task Factory Scorecard Summary
Feature Scorecard Summary
About Task Factory
According to the vendor, Task Factory offers essential, high-performance components and tasks for SQL Server Integration Services (SSIS) that eliminate the need for programming. With over 50 components, Task Factory aims to increase productivity, improve performance and increase ROI.
Task Factory components include:
Dimension Merge SCD Transform
Upsert Destination
Fact Table Destination
Rest Source
Salesforce.com Source/Destination
Microsoft Dynamics CRM Source/Destination
Marketo 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 (6)
Task Factory Downloadables
Task Factory Integrations
Microsoft SQL Server, Salesforce.com, MS SharePoint, Marketo, Hadoop, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Twitter, LinkedIn, Facebook, Azure Machine Learning, SSIS Rest Source
Task Factory Competitors
Microsoft SQL Server Native SSIS Components, Codeplex, Devart
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 |
|---|---|---|
| Standard Edition (30 SSIS tasks & components) | 1,795 | per server |
| Pro Edition (60 SSIS tasks & components) | 2,495 | per server |
| Azure Data Factory | 1,495 | per ADF node (subscription only) |
| Pro Edition Maintenance | $499 | per year |
| Standard Edition Maintenance | $359 | per year |
| Comunity Edition | $0 | free |
Task Factory is priced per Microsoft SQL Server instance. Any Microsoft SQL Server that executes an SSIS package containing Task Factory components requires a licenses. Users can install Task Factory custom components and use within VIsual Studio at no cost.
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 |