Using PA to replace current automation product

Hi all! The company I'm working for currently uses VisualCron to automate a variety of tasks. A lot of it is accessing SQL databases across the network, and sending the data via FTP offsite. I'm a tech apprentice there, and have been tasked with finding a replacement for VisualCron. The company is already in the MS environment, using both Azure Cloud and Office 365. I've already used Power Automate to take care of several tasks, but I wanted to throw my research time into finding out if PA can replace VC, and if it makes sense to use as a solution, or if I should look at another tool.

Looking at the resources available in PA, it seems like it can cover all of the bases, but I'm having trouble putting together the pieces within the MS environment. Thanks for any help!