Yes, this will support SATA and SAS drives. It doesn't really do hardware RAID, though. It uses a FakeRAID controller, which doesn't perform any kind of offload or battery backed caching. It also requires the use a specialized driver to maintain any RAID abstractions.
This essentially equates to all of the drawbacks of software RAID with all of the drawbacks of hardware RAID. I would generally advise to not use it, and use software RAID instead. Software RAID will have better metadata handling, better interfaces, and cross-system portability.
This controller will pass all of your drives directly through to the operating system, which in the case of a software RAID is what you want. This is true of both Windows and Linux, though the software RAID capabilities of Linux would be generally preferable.
So in summary, just teat it as a non-raid controller to avoid issues. OR if you need a hardware RAID controller use a higher end product, such as the H700 series.