TrustRadius
https://media.trustradius.com/product-logos/XS/vW/DDWOUTBAHFEH.JPEGSentryOneTask Factory works great, as long as you can wait a long time between upgrades2019-05-14T20:40:36.027ZWe 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.,7,Initial impact was positive. Task Factory was not very expensive, and it worked.
Once Microsoft upgraded Dynamics 365 from version 8 to 9, Task Factory did not support the new version for several months after our upgrade, and we had delayed our production upgrade for at least four months. This forced us to buy another competing product that did support version 9.
Licensing did not allow us to install the product on developer workstations for test/dev without buying another product license, but this is not a particular weakness of Task Factory. In other words, other products we have used had the same limitation. Still, it forces us to modify SSIS packages directly on the server as opposed to our laptops.,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.,,VMware ESXi, Microsoft SQL Server, Microsoft Office 365, Microsoft Power BI, Microsoft Teams, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Microsoft Dynamics GP, Redgate SQL Compare, Spotlight, Microsoft Visual Studio Code, UltiProKarl WigginsGet Task Factory before you write a bunch of SSIS code using the RBAR method.2019-04-20T16:18:52.479ZWe 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.,10,Reduces the need to double our computing environment.
Makes development much easier.,Using Task Factory cuts our programming work in half.,,JIRA Software, Cloudera Enterprise Data Hub, Talend Data IntegrationBob AmyThumbs Up for Task Factory!2019-04-20T04:19:07.058ZTask 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.,9,The product allows us to develop SSIS packages more quickly than standard SSIS.
Pragmatic Works (now SentryOne) offers training on SSIS, SSAS and other topics that have been very beneficial to our staff members and allowed us to train staff without sending them to classes, as the training is offered in an online format.
Pragmatic Works (SentryOne) has a great support team that provides help when you need it, and offers Mentoring Hours to allow you to get help from consultants when you hit issues on which you need assistance.,Yes, it has definitely provided this time-saving benefit. It is hard to quantify this in an amount of time saved, since we did not develop SSIS packages without, using Task Factory but I would estimate it has saved us at least 30% over trying to develop these same packages without Task Factory.,,Visual Studio IDE, SQL Server Integration Services, Microsoft SQL ServerSteve MayerStop banging your head against the wall and get the tools to blow through it! Get Task Factory!2019-04-06T19:05:47.621ZWe 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.,10,We've been able to consolidate our data into one place and automate things to allow our users to spend their time wisely instead of on manual processes.,We saved a lot of time by storing our maintained lists in Sharepoint now that Task Factory allows such easy access to the data. We're just starting to scratch the surface of some of the other tools to allow us to be more productive and efficient.,ZappySys,Visual Studio IDE, Slack, Microsoft TeamsMatt CushingTask Factory fills in the blanks with an excellent ROI and low total cost of ownership.2019-05-08T13:37:44.544ZWe use Task Factory to fill in the missing pieces in the SSIS toolbox.,By filling in the blanks where SSIS doesn't do everything it needs to do, Task Factory makes SSIS a truly useful ETL tool.
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.,10,Task Factory eliminates most of the need to write custom scripts to do the things SSIS should have done but doesn't do or doesn't do well.
By saving developer time, Task Factory makes those precious development hours available to more important things.
In my opinion, Task Factory pays for itself at least ten times over in the first year of use, all costs considered.,As mentioned other places in my review of Task Factory, by filling in the blanks where SSIS on its own falls short, the need for custom script development, strange workarounds, and other costly mistakes can be avoided. Time saved is not only money saved but the time that is available for other work. Time is the one thing you cannot get back--once it's gone, it's gone--and Task Factory has saved us a lot of time.,ZappySys,Visual Studio IDE, SQL Server Integration Services, Windows ServerVerified User
Windows
Task Factory
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
