Name: SolarWinds Task Factory
Rating: 8.2 (64 reviews)
Author: SolarWinds

Help Desk

Web and Video Conferencing

Customer Support

Changelog

Mind Mapping

Mobile App Development

Development

Business Intelligence (BI)

Collaboration

Corporate Performance Management (CPM)

Desktop Publishing

Enhanced 911 (E911)

Manufacturing Execution

Org Chart

Smart Spaces

VoIP

Enterprise

Accounting

Cryptocurrency Mining

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Course Authoring

Credentialing

HR Compliance

HR Management

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

AI Governance

Cloud Storage

Endpoint Encryption

Fraud Detection

HTML Editors

In-Memory Databases

Incident Response

Integration Platform as a Service (iPaaS)

Network Operating Systems

Network Performance Monitoring

Routers

SIP Trunking

Storage Area Network

System Monitoring

Technology Scouting Software

Traffic Switching

Wireless LAN

Information Technology

A/B Testing

Ad Serving & Retargeting

All-in-One Marketing

Audience Engagement

Content Management

Content Marketing

Customer Reference Management

Data Management

Digital Signage

Email Marketing

Marketing Automation

Online Reputation Management

Social Login

Social Media Management

Social Media Publishing

Survey & Forms Building

Web Analytics

Marketing

Field Service Management

Project Management

Professional Services

Customer Relationship Management (CRM)

Quote to Cash

Sales

Auto Repair

Emergency Notification

HIPAA Compliance

Home Health Care

Insurance Agency Management

Intelligent Document Processing

OSS/BSS (Operations Support/Business Support)

Retail Analytics

Smart Cities

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Pragmatic Workbench (discontinued)

Discontinued Products

SQL Server Integration Services

Microsoft

COZYROC

Cozyroc

Komprise

UiPath Automation Platform

UiPath

CData Sync

CData Software

Azure Data Factory

Informatica MDM & 360 Applications

Informatica

Oracle Data Integrator (ODI)

Oracle

Top Rated 2019

Top Rated 2020

Tech Cares 2021

Tech Cares 2022

Microsoft SQL Server

Salesforce Sales Cloud

Microsoft Dynamics 365

Microsoft SharePoint

Azure Machine Learning

### SSIS Components and Packages
Users consistently highlight SolarWinds Task Factory's ssis components and packages as a valuable asset in streamlining ETL processes within SQL Server Integration Services. The components provided by Task Factory are commended for their efficiency in handling complex tasks and improving overall performance. While some users have encountered minor issues with specific components, the general sentiment leans towards the positive impact of Task Factory's ssis components and packages on ETL development and data integration tasks. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [3](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [4](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [5](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [6](https://www.trustradius.com/reviews/task-factory-2020-04-29-18-17-16), [7](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [8](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [9](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28), [10](https://www.trustradius.com/reviews/task-factory-2019-10-22-12-14-21), [11](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [12](https://www.trustradius.com/reviews/task-factory-2019-11-15-16-10-38), [13](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [14](https://www.trustradius.com/reviews/task-factory-2019-07-18-02-36-43), [15](https://www.trustradius.com/reviews/task-factory-2019-05-31-09-38-26))

### API and Connector Management
Users consistently praise Task Factory's api and connector management capabilities. They highlight the ease of connecting to various external sources like REST APIs, Salesforce, SFTP, and FTP. The out-of-the-box connectors provided by Task Factory are lauded for saving significant coding time and improving the efficiency of ETL processes. While some users mention limitations with certain connectors like Amazon, S3, Red Shift, and Tableau, overall, Task Factory's api and connector management features are seen as valuable assets for streamlining data integration tasks. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [2](https://www.trustradius.com/reviews/task-factory-2019-10-25-11-41-30), [3](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [4](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [5](https://www.trustradius.com/reviews/task-factory-2019-07-30-12-15-46), [6](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [7](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-38-30), [8](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [9](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [10](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51), [11](https://www.trustradius.com/reviews/task-factory-2019-05-28-11-17-03), [12](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [13](https://www.trustradius.com/reviews/task-factory-2019-05-31-09-38-26), [14](https://www.trustradius.com/reviews/task-factory-2019-05-29-10-34-46), [15](https://www.trustradius.com/reviews/task-factory-2019-08-13-11-46-17))

### Integration with Cloud Services and Platforms
Users generally appreciate SolarWinds Task Factory's smooth integration with cloud services and platforms, particularly highlighting its ability to connect to various third-party websites and tools like CRM and web services without the need for extensive coding. However, some users have noted limitations, such as challenges with SharePoint connection features like the lack of a variable option to overwrite existing files. Despite these minor drawbacks, Task Factory's effectiveness in facilitating data exchange with cloud services and platforms remains a notable strength according to user feedback. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-12-18-01-59-16), [3](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [4](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [5](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [6](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [7](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-38-30), [8](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28), [9](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51), [10](https://www.trustradius.com/reviews/task-factory-2019-05-10-07-17-46))

### Data Integration Techniques
Users consistently praise Task Factory's data integration capabilities for streamlining data flow and enhancing ETL processes. The tool's ability to connect to various data sources, automate metadata tasks, and simplify data migrations has garnered positive feedback from reviewers. Additionally, users appreciate Task Factory's efficiency in handling encryption and decryption techniques, making data integration tasks more secure and manageable. The tool's advanced features, such as the REST source connections, have been highlighted as significant contributors to improving return on investment for users moving towards API-based data retrieval. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-12-18-01-59-16), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [3](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [4](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [5](https://www.trustradius.com/reviews/task-factory-2019-11-15-16-10-38), [6](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [7](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [8](https://www.trustradius.com/reviews/task-factory-2019-10-25-09-42-54), [9](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [10](https://www.trustradius.com/reviews/task-factory-2019-08-13-11-46-17), [11](https://www.trustradius.com/reviews/task-factory-2019-07-18-02-36-43), [12](https://www.trustradius.com/reviews/task-factory-2019-06-21-09-14-41), [13](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51), [14](https://www.trustradius.com/reviews/task-factory-2019-05-28-11-17-03))

### ETL Processes and Tools
Reviewers consistently praise SolarWinds Task Factory for its efficient ETL processes and robust tools functionality. Users find that the ETL processes and tools offered by Task Factory significantly enhance data loading, transformation, and management tasks. The tools provided by Task Factory, such as Upsert, Bulk Update, and Bulk Delete, are particularly highlighted for their ability to streamline and accelerate data processing workflows. Additionally, the Dimension Merge SCD Transform is lauded for its efficiency in handling large volumes of data swiftly. Users appreciate the time-saving features and the ease of use that Task Factory's ETL processes and tools bring to their data integration projects. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-12-18-01-59-16), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [3](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [4](https://www.trustradius.com/reviews/task-factory-2020-04-29-18-17-16), [5](https://www.trustradius.com/reviews/task-factory-2020-04-21-11-19-07), [6](https://www.trustradius.com/reviews/task-factory-2020-02-21-08-34-48), [7](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [8](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [9](https://www.trustradius.com/reviews/task-factory-2019-07-30-15-39-03), [10](https://www.trustradius.com/reviews/task-factory-2019-10-22-12-14-21), [11](https://www.trustradius.com/reviews/task-factory-2019-08-19-01-56-08), [12](https://www.trustradius.com/reviews/task-factory-2019-11-22-10-20-57), [13](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [14](https://www.trustradius.com/reviews/task-factory-2019-08-17-11-16-33), [15](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28))

### Data Transformation and Processing
Users consistently praise SolarWinds Task Factory for its robust data transformation and processing capabilities. The tool's ability to handle tasks such as loading large volumes of data quickly, managing slowly changing dimensions effectively, and improving processing speed has garnered positive feedback from users across various departments. While some users have noted minor challenges with certain components like the Snowflake transform and the complexity of the slowly changing dimension transform, overall, Task Factory's data transformation and processing features are highly regarded for their efficiency and effectiveness in streamlining data management tasks. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-19-37-05), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-12-18-01-59-16), [3](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [4](https://www.trustradius.com/reviews/task-factory-2019-07-30-15-39-03), [5](https://www.trustradius.com/reviews/task-factory-2020-02-21-08-34-48), [6](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [7](https://www.trustradius.com/reviews/task-factory-2019-11-15-16-10-38), [8](https://www.trustradius.com/reviews/task-factory-2019-08-13-11-46-17), [9](https://www.trustradius.com/reviews/task-factory-2019-06-21-09-14-41), [10](https://www.trustradius.com/reviews/task-factory-2019-07-18-02-36-43), [11](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28), [12](https://www.trustradius.com/reviews/task-factory-2019-05-28-11-17-03), [13](https://www.trustradius.com/reviews/task-factory-2019-05-31-09-38-26), [14](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51))

### Data Warehousing Solutions
User feedback on Task Factory's data warehousing solutions is generally positive, with many users highlighting the tool's ability to optimize data warehouse processes and streamline data management tasks. Users appreciate the ease of connecting data from various sources and automating metadata tasks in real-time. However, some users have expressed concerns about future support and occasional issues with certain SQL Server versions. Despite these challenges, Task Factory is recognized for its effectiveness in standardizing data extraction and transformation processes, particularly for slowly changing dimensions in data warehouses. Additionally, users find the tool valuable for integrating with external organizations and simplifying data loading into their data warehouses. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-19-37-05), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [3](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [4](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [5](https://www.trustradius.com/reviews/task-factory-2020-04-21-11-19-07), [6](https://www.trustradius.com/reviews/task-factory-2019-11-22-10-20-57), [7](https://www.trustradius.com/reviews/task-factory-2019-10-25-09-42-54), [8](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [9](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [10](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [11](https://www.trustradius.com/reviews/task-factory-2019-11-15-16-10-38), [12](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [13](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [14](https://www.trustradius.com/reviews/task-factory-2019-05-31-09-38-26), [15](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06))

### SQL Server Integration
Reviewers have varying opinions on SolarWinds Task Factory's SQL Server integration capabilities. Some users have praised its ability to easily connect data from multiple sources like SharePoint and Microsoft Excel, saving time and enhancing data warehouse management. However, others have encountered compatibility issues and occasional failures when working with SQL Server and Task Factory. Despite these challenges, Task Factory seems to fill a gap in SSIS tasks and provides well-designed components for data connections and transformations. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [3](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [4](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [5](https://www.trustradius.com/reviews/task-factory-2019-11-22-10-20-57), [6](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [7](https://www.trustradius.com/reviews/task-factory-2019-10-22-12-14-21), [8](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-38-30), [9](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [10](https://www.trustradius.com/reviews/task-factory-2019-05-10-07-17-46), [11](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [12](https://www.trustradius.com/reviews/task-factory-2019-10-25-09-42-54), [13](https://www.trustradius.com/reviews/task-factory-2019-05-28-11-17-03), [14](https://www.trustradius.com/reviews/task-factory-2019-05-29-10-34-46), [15](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28))

### Data Source and Destination Management
Users generally praise SolarWinds Task Factory for its robust data integration capabilities, particularly in managing various data sources and destinations. The feedback highlights the ease of connecting to different sources like Salesforce, REST APIs, and offline platforms, streamlining the ETL process. However, some users have expressed a desire for additional features, such as source and destination components for Snowflake, and improvements in handling custom or secure API connections. Despite some minor limitations, Task Factory is recognized for its efficiency in automating metadata tasks, extracting data from web sources without coding, and supporting ETL functions effectively. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-12-18-01-59-16), [3](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [4](https://www.trustradius.com/reviews/task-factory-2019-10-25-11-41-30), [5](https://www.trustradius.com/reviews/task-factory-2019-05-31-09-38-26), [6](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [7](https://www.trustradius.com/reviews/task-factory-2019-06-21-09-14-41), [8](https://www.trustradius.com/reviews/task-factory-2019-05-29-10-34-46), [9](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51), [10](https://www.trustradius.com/reviews/task-factory-2019-07-30-15-39-03), [11](https://www.trustradius.com/reviews/task-factory-2020-02-21-08-34-48), [12](https://www.trustradius.com/reviews/task-factory-2019-08-17-11-16-33), [13](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [14](https://www.trustradius.com/reviews/task-factory-2019-07-16-20-14-28))

### Code Efficiency and Development Time Reduction
Users generally praise SolarWinds Task Factory for its efficient code handling and time-saving development capabilities. The tool's ability to streamline data warehouse management tasks, automate metadata operations, and connect to various sources without extensive coding has been well-received. Users appreciate the out-of-the-box connectors and tasks that enhance productivity and reduce the need for manual coding. Additionally, Task Factory's features like Upsert, Bulk Update, and Bulk Delete have significantly reduced development time and improved data processing speed. Despite some minor issues with specific components, overall, users find Task Factory to be a valuable asset in optimizing code efficiency and reducing development time. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-19-37-05), [2](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-28-07-05-27), [3](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [4](https://www.trustradius.com/reviews/task-factory-2020-03-20-09-17-13), [5](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [6](https://www.trustradius.com/reviews/task-factory-2020-04-29-18-17-16), [7](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [8](https://www.trustradius.com/reviews/task-factory-2020-04-14-07-52-54), [9](https://www.trustradius.com/reviews/task-factory-2020-02-21-08-34-48), [10](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [11](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [12](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [13](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51), [14](https://www.trustradius.com/reviews/task-factory-2019-07-30-15-39-03), [15](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29))

### Upsert and Bulk Data Operations
Users consistently praise Task Factory for its efficient upsert and bulk data operations capabilities. The ability to perform bulk updates and deletes, along with the simplicity and effectiveness of the Upsert tool, has garnered positive feedback from reviewers. Despite some minor suggestions for improvement, such as enhancing delete capabilities within the Upsert task, overall sentiment remains favorable towards Task Factory's handling of bulk data operations. The tool's impact on speeding up data loading processes and reducing manual development efforts has been particularly highlighted by users across various reviews. (Source Reviews: [1](https://www.trustradius.com/reviews/solarwinds-task-factory-2021-08-26-21-15-20), [2](https://www.trustradius.com/reviews/task-factory-2020-04-29-18-17-16), [3](https://www.trustradius.com/reviews/task-factory-2020-02-21-08-34-48), [4](https://www.trustradius.com/reviews/task-factory-2020-04-22-09-38-45), [5](https://www.trustradius.com/reviews/task-factory-2019-11-22-10-20-57), [6](https://www.trustradius.com/reviews/task-factory-2020-02-19-07-21-06), [7](https://www.trustradius.com/reviews/task-factory-2019-10-25-11-41-30), [8](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-38-30), [9](https://www.trustradius.com/reviews/task-factory-2019-10-08-12-40-19), [10](https://www.trustradius.com/reviews/task-factory-2019-10-25-09-42-54), [11](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [12](https://www.trustradius.com/reviews/task-factory-2019-09-10-11-22-29), [13](https://www.trustradius.com/reviews/task-factory-2019-05-23-10-26-51))

### Custom Development and Scripting
Feedback on Task Factory's custom development and scripting capabilities varies among users. While some users praise Task Factory for its ability to streamline ETL processes and reduce the need for custom scripting, others express concerns about its limitations in handling very secure API connections that require frequent hashing of connection strings. The tool is generally appreciated for its efficiency in eliminating the need for extensive programming of connectors and transformations within SSIS, ultimately saving time and resources for development teams. Users find Task Factory intuitive and easy to implement, with many highlighting its cost-effectiveness compared to other custom development solutions. Despite some mixed opinions, Task Factory appears to be a valuable asset for enhancing ETL workflows through its custom development and scripting functionalities. (Source Reviews: [1](https://www.trustradius.com/reviews/task-factory-2020-03-25-02-43-20), [2](https://www.trustradius.com/reviews/task-factory-2019-11-18-13-00-41), [3](https://www.trustradius.com/reviews/task-factory-2019-08-28-08-45-56), [4](https://www.trustradius.com/reviews/task-factory-2019-07-30-12-15-46), [5](https://www.trustradius.com/reviews/task-factory-2019-05-03-11-00-42))

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.

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.

Task Factory

Task Factory Azure Data Factory

Workbench Client Edition

Workbench Server Edition

Workbench Enterprise Edition (Client + Server)

Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.

Basic

Advanced

Developer: For Individuals

Matillion

SolarWinds Task Factory

Data integration involves combining data residing in different sources and providing users with a unified view of these data.

Data Integration

Likelihood to Recommend

Likelihood to Renew

Usability

Support Rating

Implementation Rating

Data Source Connection

Data Transformations

Data Governance

Connect to traditional data sources

Simple transformations

Complex transformations

Integration with data quality tools

Integration with MDM tools

SolarWinds is a leading provider of powerful and affordable IT management software. Our products give organizations worldwide—regardless of type, size, or complexity—the power to monitor and manage their IT services, infrastructures, and applications; whether on-premises, in the cloud, or via hybrid models. We continuously engage with technology professionals—IT service and operations professionals, DevOps professionals, and managed services providers (MSPs)—to understand the challenges they face in maintaining high-performing and highly available IT infrastructures and applications. The insights we gain from them, in places like our THWACK community, allow us to solve well-understood IT management challenges in the ways technology professionals want them solved. Our focus on the user and commitment to excellence in end-to-end hybrid IT management has established SolarWinds as a worldwide leader in solutions for network and IT service management, application performance, and managed services. Learn more today at <a href="http://www.solarwinds.com" rel="">www.solarwinds.com</a>.

SolarWinds

Ability to connect to multiple data sources

Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

Connecto to Big Data and NoSQL

Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

Data transformations include calculations, search and replace, data normalization and data parsing

Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

Complex data transformations are data normalization, advanced data parsing, etc.

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

Data model creation

Ability to create and maintain data models using a graphical tool to define relationships between data

Metadata management

Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

Business rules and workflow

Ability to define and manage business rules and workflows

Collaboration is enabled by a shared repository of project information and metadata

Testing and debugging

Tool to debug and tune for optimal performance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

Integration with tools for cleansing, parsing and normalizing data according to business rules

Integration with master data management tools to ensure data consistency across the organization

Business Analyst

SolarWinds Task Factory 2021-12-18 01:59:16

Executive Administrator

SolarWinds Task Factory 2021-08-28 07:05:27

Data Developer

Task Factory 2019-11-18 13:00:41

Informatica Cloud Data Marketplace

Sr.  Architect - Data warehousing & BI

Task Factory 2020-04-29 18:17:16

SSIS Data Flow Components

Microsoft Visual Studio Code

DBA / Sr. Data Analyst

Task Factory 2019-05-28 11:17:03

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

SolarWinds Task Factory

Overview

What is SolarWinds Task Factory?