Yes...
At POST the system BIOS should recognize the SATA controller card and the card BIOS should recognize the HDD. You want a controller card with a chip that is supported by a module in linux, corresponding to a driver in Windows, to enable the OS to function with that controller chip.
You might consider if you want to have RAID capability, in which case RAID implementation by the chip itself(hardware RAID)is recommended. There is a support list, but the suggestion about using Google on any possible choice is a good one.
https://ata.wiki.kernel.org/index.ph..._driver_status