BMC AMI Data for Db2 and IMS simplifies mainframe data management with automation, performance optimization, and resilient recovery. It accelerates query execution and ensures compliance with regulations like DORA. By integrating with DevOps, it helps organizations maintain continuous availability.
N/A
SolarWinds Task Factory
Score 8.3 out of 10
N/A
According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory…
BMC AMI Cloud Vault provides immutable cloud storage, allowing businesses to create secure, unchangeable copies of critical data for rapid recovery in the event of ransomware. >For organizations looking to move away from expensive Virtual Tape Libraries (VTL) or on-premises storage, BMC AMI Cloud Data is well-suited, as it supports backing up or archiving mainframe data directly to cloud object storage (e.g., AWS).
Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.
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.
It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
Occasional random failures observed with the Filter tranform.
Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business
My overall experience with BMC AMI data has been great so far because after installing this software in our business now we are able to work on long term projects and business expansions. The software has made sure that our team work more on analysis and strategic data management that's why I would like to give it 9 out of 10
Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues.
See all of the software have different attributes and working process they gives the different analytical results so I will not compare them directly to BMC AMI Data but I would say they all are pioneers platform at their own level.
ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and simple to use.
By shifting to AIOps-powered monitoring, customers halved unplanned mainframe outages, resulting in $1.4 million in retained profit over three years=50% Reduction in Unplanned Downtime.
BMC AMI data solutions delivered a 217% ROI, with payback in under six months, enabling teams to deliver 3x more code to production.
BMC AMI Data for Db2 users achieved a 6% reduction in MIPS consumption and realized significant cost savings by retiring outdated, non-automated systems.
The ability to perform database reorganizations with zero downtime ensures critical business applications remain available, protecting revenue streams and customer experience.
We were able to support our developers with Task Factory features and reduce the development time by 40%.
Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward.