What is our primary use case?
We use Control-M for managed file transfer in the enterprise manager automating database workflows. We're using Oracle Business Intelligence with a generic database like Microsoft SQL Server. Next year, we plan to use Control-M for AWS Natural and upgrade Control-M to Helix Control-M. We need managed file transfers between our servers in Key West and Orlando. Vast amounts of data are routinely transferred between servers for backup and snapshots.
We will deploy it on AWS and Azure next year. We will also integrate Control-M with other solutions like Salesforce and COS, which is challenging because COS is a complicated legacy IBM OS. Some of our customers require Control-M to do managed file transfer and also COS conversions between IBM jobs. Anything that involves COS or OS/400 is complicated but doable.
How has it helped my organization?
With Managed File Transfer, we gain speed and reliability because a managed transfer continuously checks the CRC of the data packages. That's a God send for those data transfers. Though we are migrating to the cloud, we still use some physical servers for sensitive data from our customers protected with NDAs.
We use Control-M for the maintenance of our Oracle and SQL Server databases. It automates maintenance in packages, including standard procedures on the databases themselves, snapshots, checking integrity, verifying the RDBMS of the databases, etc. It ensures that they aren't clogged, that they run smoothly, and that there aren't any jobs stuck, eating up the performance of the server or any of the CPU cores.
In the past, we had some troubles, and we needed a database admin to keep an eye on it almost 24/7 using the OES. It's essential to ensure everything inside the OES runs smoothly, and there are no stuck jobs or queries eating up table spaces. An admin is still required, but most jobs are now automated. It has had a significant impact on staffing. In the past, we had a couple of DBAs exclusively assigned to Oracle that we were able to reassign to other jobs.
We reassigned them to other tests and outsourced one to work with our customers. Once we delegated DBA tasks to Control-M for our Oracle databases, we could reassign that DBA as a resource to our client in Puerto Rico. He became a source of income for the company. Also, with time saved by automating all the critical internal business processes, we could dedicate more time and resources to other projects that require human attention. We could devote more resources to projects that advance the company's strategic vision instead of monitoring an Oracle RDBMS 24/7.
If I had to rate how critical Control-M is to our business, I would say it is an eight out of ten. I won't give it a nine because we still rely on older applications, such as Oracle databases, but an orchestrator will always get at least an eight on our book. For speed of process execution, I would say it is a nine out of ten. Previously, it was a four, and now it's a nine.
What is most valuable?
Control-M is intuitive, and BMC has tutorials for every application to help you with the basics. Once you know what you're doing, everything falls into place. The graphical interface is drag and drop. There are plenty of objects to drag and drop inside. You need to study them, but once you know how it works, it's just dragging and dropping like you are playing with a Lego set.
You drag two actions to the workspace and connect them to establish a relationship, schedules, and subtasks inside each one of them. It seems complex initially, but it becomes intuitive the longer you use it.
You can almost reach out intuitively into every nook and cranny of the entire UI. It's user-friendly for the initiate, but you could be lost if you've never used an orchestrator or an enterprise-grade software like Control-M. However, Control-M has built-in tutorials that help you with the first steps. The tutorial isn't comprehensive, but at least you will learn the first steps, so you can advance and learn more.
What needs improvement?
The performance could be better. Control-M Enterprise Manager tends to slow the system down even on a server with a six-core processor and 32 gigabytes of RAM. The console is Java-based, so maybe OpenJDK 16 or 17 would be a performance improvement.
For how long have I used the solution?
I've been using Control-M for five years.
What do I think about the scalability of the solution?
The scalability is quite good. The framework lets you start with Control-M Enterprise Manager and add other products as you see fit. We added MFT, then Control-M for databases, and Oracle Business Intelligence. One of our customers added Control-M, including the agent for IBMI and another for Azure.
How are customer service and support?
I rate BMC support a solid nine out of ten. I say nine because I never give a ten to anyone.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
Before Control-M, we had a traditional solution using an FTP server. Even with a T1 line that provided almost gigabyte speed, we still had artifacts during the transfer that corrupted the data. It caused serious problems when transferring 30 gigabytes of a necessary backup overnight that failed on gigabyte 28 because it was corrupted. Still, the mirror server rejected the mage because of corruption when we tried to restore it.
We had to rely on traditional monitoring tools like SolarWinds and IBM solutions, which are pretty expensive. These tools only monitor, so they're typically not reactive or able to orchestrate the steps of a workflow. They don't follow up on each step inside the workflow, notify you when a step completes, or send alerts when something gets stuck and requires action.
How was the initial setup?
I'm the senior services manager, and overseeing the deployment of Control-M is part of my job. I did not install it, but I supervised the team. It was straightforward because we all got our BMC certification before the deployment. Our team included me and two technicians. We also had a DBA around to integrate the database.
What about the implementation team?
We did everything ourselves with some occasional help from BMC support. We emailed them a couple of times to check something, but so far, everything has gone smoothly.
What was our ROI?
We recovered our initial investment in six months and were ready to commit more, so we could recover more. We saw an ROI with Control-M in the first two years because we could take a DBA off monitoring databases and loan them out to another company while saving time by speeding up these processes.
Control-M gives us a lot of flexibility to automate our time-sensitive and data-critical processes. This is essential for enterprises, but Control-M isn't for everyone. Small and medium-sized businesses can use Control-M, but its power can only be leveraged by large enterprises because of the complexity of their business processes and the sheer size of data they handle. I think enterprise companies are the only ones that see an effective ROI from purchasing a tool like BMC Control-M for automating their business processes.
Small companies that purchase Control-M often cancel the contract after six months because it's too expensive, and they can get the job done using traditional methods. That's okay. It's about the business processes' complexity, depth, and maturity.
What's my experience with pricing, setup cost, and licensing?
The price is right because of the licensing schema, which is based on nodes and processes. You purchase what you use, no more and no less, and you can grow with time.
Which other solutions did I evaluate?
There are few options like Control-M in the market, and the closest competitors are far more expensive.
What other advice do I have?
I rate Control-M a nine out of ten. Control-M is flexible. You can use it in Azure, and they have a generic option for the cloud. You can deploy it in your own private cloud or on other cloud solutions like Kubernetes. You can use Control-M for big data applications like IBM InfoSphere. There's a Control-M solution for almost any situation.
There is so much to learn on the backend of the business processes. Typically when you see a business process, you only see a workflow, like a flow chart, arrows, boxes, etc. However, there's a whole new world under the hood. It's crucial to dig deeper and learn how to improve the processes. It's like you become the mechanic of your own car. The more you understand the engine, the more you can tweak it to get more speed, gas mileage, performance, strength, horsepower, etc. Control-M almost compels you to learn about that.
It's user-friendly, but you need some training. We have a certification from BMC. You need some prior training specifically in Control-M Enterprise Manager to know what you're doing because it's delicate. There are so many ways to customize job creation, automation, monitoring, etc. that you need at least a crash course on creating a job, monitoring, setting up alarms, and building workflows.
It should take you no more than a week to get the hang of it, and there's BMC University, where you can get free training to use Control-M. Once you know the basics, Control-M practically handles itself. It's intuitive once you figure it out.
Which deployment model are you using for this solution?
On-premises