I have this HBA in my homelab server and was surprised to find it has two SAS controller in it. I can't remember exactly what I had to do to flash it, but I needed to flash both controllers using an EFI prompt so they became one controller. It took an afternoon of research, but I eventually flashed both of them to IT mode and it worked as expected. I'm pretty sure this thread helped me at the time:
Good luck!
The HBA can definitely handle hot swapping, but I'm pretty sure you need a backplane for it to work. If I remember correctly, it needs the capacitors on the backplane's PCB to allow for the power drain. I'm not sure those cables alone will do.