TrustRadius
https://media.trustradius.com/product-logos/XS/vW/DDWOUTBAHFEH.JPEGSentryOneTask Factory made things possible2019-08-19T22:16:32.612ZWe 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.,8,We are able to run our ETL without manual intervention, so we spent fewer hours on this.,It has and it's hard to say how much time, but we save a few hours daily since it runs fully automatic.,Microsoft SQL Server,Microsoft SQL Server, Microsoft 365 BusinessPeter BerrensA complete package of additional tasks for SSIS2019-07-19T16:11:01.988ZIn 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.,10,Less resources needed to complete a complex task.
Much time gained during the development of an ETL package.
Easy identification of errors during data import.,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.,,SQL Server Integration Services, Microsoft SQL Server, Microsoft Access, Qlik Sense, QlikView, ASG-Remote Desktop, Redgate SQL Data Compare, Redgate SQL CompareLuca CampanelliBetter quality outcomes with less code cutting2019-07-17T02:40:56.008ZTask 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.,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.,10,It actually simplifies the SSIS packages and means there are less steps within a package.
We have high staff turnover so using TaskFactory gets new employees able to understand and maintain existing packages faster.,Yes it has, especially on complex transformations with extensive cleansing required. The trim and null handling functions remove the need for script components.,Mickeal DavisLove Task Factory!2019-05-29T17:53:47.347ZWe 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.,10,Huge ROI. With the SFTP and Advanced SMTP it saved us weeks in changes and hard coding that we would have had to do and maintain. The cost of the license was recovered the first day we installed Task Factory.,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.,,Microsoft Visual Studio Code, SQL Server Integration ServicesSteven Gockley, MBA, MCSATask 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 WigginsTask Factory Delivers!2019-08-19T21:32:09.470ZUsed 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.,10,ROI was immediate.,Task Factory has reduced design, development and test time by 75%.,CozyrocAl RubelGet 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 CushingWorth a try!2019-07-30T19:25:39.021ZWe 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.,5,That is really hard to calculate and I don't think it is worth my time to do so for this survey :),This is definitely a time saver, but more and more components are being added natively all the time by MS so its value is decreasing. Overall though this has saved us probably 400 hours.,Ryan Lundahl#1 SSIS plug-ins2019-06-02T17:07:30.378ZIt'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,8,It provides many components that help us to integration data from different systems.,Yes, it does provide this benefit. It saved 30%-40% our development time.,Cozyroc,Microsoft SQL Server, Microsoft Power BI, .NETKang ChenGood for any non trivial SSIS project2019-05-28T21:18:41.158ZTask 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.,10,Task factory simplify lots of SSIS projects.,Task Factory components are easy to use and behave fairly similarly with the build in SSIS components. The functionality provided can probably reduce 20-30% of development and testing time for any non trivial SSIS project.,Edward ChowSolve the problem without coding2019-05-29T21:28:03.455ZWe 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.,8,We are able to import different data from an external/cloud service into our own server for data analytic purposes.,With Task Factory, we were able to retrieve Google Analytic data without one line of coding.,Microsoft Power BIVerified UserTask 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 UserSFTP: don't try it without Task Factory2019-04-27T14:37:42.183ZWe 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.,10,We haven't tried to measure ROI in regards to Task Factory, it is a tool we needed to fill a gap in the standard SSIS toolbox.,Task Factory has definitely saved us time but we do not have a measure of how much.,Redgate SQL MonitorVerified UserTask Factory simplifies your workflow2019-08-01T14:05:22.543ZUsed 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.,8,pretty good so far - although it does seem a little expensive.,Agreed. SCD transforms are a good time saver.Verified UserTask Factory is great day to day2019-06-22T01:26:38.874ZWe're using Task Factory in our data warehouse processes. It helps solve various data cleanup and data flow problems.,Easy to use and implementation.
Great components to help easily solve procedural issues in SSIS.,I would like to see source and destination components for Snowflake.,10,Task Factory has had a positive impact on our ROI for ease of use and the problems it helps us solve.,I don't have a quantified number but I know that Task Factory makes my job easier when I'm developing in SSIS.,Redgate SQL Compare, SQL Server Integration Services, SnowflakeVerified UserTask Factory Review2017-03-21T18:29:30.632ZTask 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.,9,Task factory has saved our company thousands of dollars in development time.
If money is no concern then licensing your Task Factory for all SQL Servers in your environment is the way to go. However, you could operate in an environment that has a dedicated SSIS bus that manages all packages on all servers. In that architecture, your single license will be sufficient.
We recently retired a legacy system and moved the data to Salesforce. We now use task factory to support building our data warehouse from a replicated copy of Salesforce data. The tools allow for simple and quick additions to an ever changing Salesforce and warehouse environments.,,Boomi, SQL Sentry, BambooFrank Coulter
Windows
Task Factory
29 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
