What is our primary use case?
We use Tidal extensively to run our health and welfare claims processing throughout the day. That's the reason we got Tidal back in 2011. We receive 15,000 to 20,000 claims a day and we use Tidal to process the whole thing, all the way through to creating checks at the end of the day.
Since 2011, we've expanded it to other applications and other processes: mostly reports, and files that come in electronically from other companies that feed other applications. And in a roundabout way, what we use Tidal for is to execute the applications to load whatever needs to be done on those applications.
The transfer function we used to do with Tidal has been switched over to another software product called Cleo. And that is run by our network team. That way they can control all the information that comes in and out of our building. They can put secure FTP on it, encrypt and decrypt the information, and set password protections. Cleo has its own scheduler, like Tidal, but they don't use it. They let Tidal execute the Cleo commands to bring the data in and Tidal will execute any application programs after that.
Overall we run 1,100 to 1,200 steps every day, depending on day of the week. I call them "steps," but they're actually multiple steps. Before you get to the actual processing of a program there might be a move, a copy, or a delete when we're clearing out folders, using DOS commands. We then move data around to certain directories so that either the TriZetto software that we use can find that data or any internal programs that we use in VBS, .NET, Oracle, or MS SQL stored procedures can find that data.
We're also starting to use this new MDM application which captures addresses from various databases, verifies they are correct, and pulls them together into one database. After all of our nightly processing, we have Tidal kick off the main MDM master so that all those addresses are in sync.
Tidal sits on its own database and then it talks, through agents, to the other applications.
How has it helped my organization?
People who are on the Client Manager were complaining about response issues. It's never been proven that a batch job is causing the issue, but they do find that so many things are hitting the database at the same time that they shut down the batch job that's running at the time. We've now been able to move our schedules around so that it can just run at night when everybody's off the system.
Also, after a while using Tidal it started to reduce weekend hours by not have to watch it constantly on the weekend. The only time we're really busy on a weekend, now, is when there is a major upgrade going on, as we usually do it on a Saturday or Sunday. But other than that, it's very quiet on the weekend. It has reduced overtime by 80 to 90 percent.
As of right now, the only time we really have overtime is planned overtime. Once a month, our network team applies the Microsoft security patching, so we have to pick a day, once a month to hold everything in the schedule. They then apply their security patches to all the Windows Servers. They bring the applications back up and we have to do a quick, sample test to make sure Tidal is okay. We then run a few jobs to make sure other things are okay and the business users have to check their applications and their data. At that point we turn the schedule back on for the weekend. It sounds like a lot but it only takes about an hour. Where we used to have two or three hours of overtime a week, now it's down to one hour a month.
In addition, our number of jobs has been growing steadily. We do about 1,100 to 1,200 jobs a day. We could go further but we have never really tested how many jobs we could do.
What is most valuable?
One of the most useful features is being able to set up a schedule and create dependencies. The calendar can kick off processes at certain times, based on dependencies that you specify, like time, or whether another process has finished. Dependencies are the most useful thing.
You can also verify that a step is finished. And some of our departments are really interested when something has started. You can send out an email saying this step has launched or this step finished normally and, obviously, we always have it notifying us when something goes wrong.
It's also very useful to do repeating steps. If you need to do something multiple times throughout the day, it's very easy to just copy that group of steps or jobs and continually process the same thing each time. And you can always have one dependent on the other.
Tidal is also helpful because, once you set a schedule, you can keep an eye on it. You can kind of have "bookmarks" where it can tell you when this step is done and that step is finished, and you know that the schedule is moving forward and nothing has been stopped yet.
What needs improvement?
We've had some quirky stuff happen on an occasional basis where a job does not take off. For example, a job we expected to be finished by 3:00 a.m. is sitting there and not executing when we come in in the morning. We have to go all the way back to the dependencies and then we can see that one of the dependencies has become unscheduled, for some reason. No changes were made to the schedule but this prerequisite job has, all of a sudden, become unscheduled. I have brought this up with Tidal's support but they have never had an answer for it. It would be helpful to be notified ahead of time when something is going to stop the schedule, even if we don't necessarily know what's causing it.
But the main area for improvement is reporting. A lot of our managers would like to have metrics shown in graphs for the products they keep track of. The reporting part of Tidal isn't very useful. When you use the report function, you can't bring that data into an Excel spreadsheet. I understand in the new release they have something called Explorer which is a new reporting feature. I think they acquired a product to handle reporting functions, but we haven't gotten it yet.
For how long have I used the solution?
We've been using Tidal since 2011.
What do I think about the stability of the solution?
Tidal has been pretty stable. We've had these little quirks, but they are mostly just minor bugs that crop up every once in a while. For instance, you might have to click on something twice or click off of something, like a tab, and then click back on it and it will bring up the screen. But other than that, it's been pretty stable.
What do I think about the scalability of the solution?
The scalability is pretty good. We've used Tidal only for our main application which is our health and welfare system. We do a lot of reports and off of that, but we don't use it in any other areas.
We've never scaled it extensively across too many different platforms. The only thing we have right now is a SQL Server platform and an Oracle Database that we go against. We're only in one location.
I don't see us expanding our use of it for now. We're pretty stable.
How are customer service and technical support?
I haven't really dealt with Tidal support too much. The only time I really dealt with tech support is when we were doing an upgrade to a new release, to find out what release we need to have the agents in and was it compatible with other releases of SQL Server. The Tidal database, itself, is on a SQL Server release — I think it's at 2012 right now — and it can go up to 2016, but other applications are at different SQL Server levels. We had to check with them to see if it was all compatible.
They were very good in responding.
Which solution did I use previously and why did I switch?
We had two mainframes running all of our applications. We were using CA products. Our health application was ClaimFacts, from TriZetto, but they were dropping support for the mainframe product and everybody had to switch to Facets. We were running both products at the same time while we were transitioning to Facets. We had to run ClaimFacts, the mainframe version, for about a year or so because, if somebody has a claim they have a year to report that claim and another six months to make adjustments on their claim. So our old mainframe product had to be kept until all that faded away.
Then everything went into PC, server-oriented applications. We got Tidal because the company, TriZetto, used Tidal to run their stuff. So we brought it in and we started setting up our whole batch schedule.
How was the initial setup?
I wasn't privy to the technical part of the initial setup, but I think it was pretty straightforward. We just needed to know where to place the agents so that they could connect, and we had to do a file share so that if you're doing a DOS command and a Tidal job, it will have shareability to whatever servers they're going to. Once those were all set up it was pretty stable.
Our deployment took about a month. But we were using the product for the first time. So we were setting up jobs for the first time. Some things were kept out of Tidal until they were ready to be moved in. They were run by developers or the application people, manually. It took about six to eight months to get everything on Tidal. There are so many icons and buttons and things that they had to press on to run something on a desktop and we had to convert that all into executable commands for Tidal in the schedule.
That approach was planned. The initial plan was to get the batch processing of claims in first. That was pretty smooth. There were hiccups every now and then but it was not that bad. While that was going on, all the in-house stuff was done in the periphery on a person's desktop. Those things were set up afterward.
The learning curve is at least one to two weeks, if you teach a person, full-time, how to run the schedule and how to set everything up. It depends on what knowledge they need to have to run a schedule. If it was just a matter of running jobs, it would take less than a week. But if they're constantly being asked questions on what this or that job does, it will take a person longer to get a feel for what all the applications do.
I came from a programming background when I started running these jobs and setting up the schedule, so I had a fairly extensive knowledge of what all the applications do. But you take a person who is just out of the computer room and all he knows is how to do a Computer Associates schedule, he knows the timelines and the flow of everything, but he doesn't know exactly what the applications do. They would need at least a few days to find out what are the major applications or major steps in a daily job schedule are. If some of those steps are very critical to run, they would need to be pointed out so they know which are critical and which ones can be held or bypassed. It takes time to get used to the processing.
What about the implementation team?
We used a Cisco consultant for installation. There were four people involved in the installation. We had the consultant working with our network people, and we had a technical support person who made sure all the libraries were in place to set up for Tidal. And there was me and another person getting all the schedules together.
The only time we've used a third-party is when we were doing a major upgrade of Tidal from 3.1 to 5.2, back in 2015.
The third-party we used was Synertech. Our experience wasn't too good with the consultant they gave us. He was very gruff and it wasn't a pleasant experience. We didn't ask him to come back. But the actual conversion to the new release went well. We used the consultant to show us the technical part of upgrading to 5.2. We also wanted to use him to train one of our new people in Tidal functions, but it never got that far.
What's my experience with pricing, setup cost, and licensing?
I'm not in the financial end, so I don't know what our licensing costs are.
I know that Tidal integrates with a product called JAWS Workload Analytics, which will analyze your schedule, give you graphics and reports, tell you where your logjams are, and analyze all the data going in and out. We asked what the price is on that and it was about $200,000.
Which other solutions did I evaluate?
There was one option back then, but by the time they wanted to come in for a demo, we had already decided to use Tidal.
What other advice do I have?
The biggest advice I can give is to test Tidal first. Run the whole schedule, whatever you're putting in. Run everything you can and test Tidal before you bring it over to production.
The trickiest thing to do is to change a schedule during the day. Once you associate a job with the calendar, and then somebody comes by and says, "Hey, I want to put these six steps in, and we need to run that today," if you try to change that schedule during the day, you don't realize that, because you put it on the calendar, it's on a schedule. You could be making changes and kicking off things inadvertently. You can't change something during the day without like stopping the scheduler or putting it on pause. We might have done that once in all these years — pause the whole scheduler or pause job launching and then make a change and then turn it back on.
You may think that you can change something during the day and let it go, but then you realize, "Oh, this thing took off." And you realize that because you put that job on the schedule, it picked up the scheduling requirements it inherited from another group of jobs and it will take off on you. That's probably the trickiest part of the learning curve.
When we brought Tidal in there were six people who were taught how to use it but five of them have retired. I'm the last one. About three years ago I had to train another person who came from the mainframe computer room after he took the job as a Tidal scheduler. I got him up to speed. The two of us run the schedule during the day. There are no other users. There are a few application programmers or developers who just want to have Tidal available so they can see what's going on, and we give them inquiry access. But nobody else has any authority to change anything or to set up anything.
Overall, it does what it's supposed to do.
I always get into arguments with the management staff here. They always claim something happened in Tidal and I say that Tidal doesn't process anything. It's a scheduler and it just launches jobs on the servers. If there's a system hung up somewhere, it's not Tidal. Stop. It is the actual program. Whatever processing has been launched by Tidal is the issue, not Tidal itself. I finally convinced them of that. Just because Tidal launched something doesn't mean it has touched anything or changed any data. It just goes to a server and launches a process. A person with the right authority can do the same thing from their desktop.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.