It IS that simple, with bifurcation of the x8 or x16 slot of course (Xeon E does x8x4x4). An x4 slot would require a PCIe switch.
As for the Jonsbo N1, I would not add a hot HBA in there for just one extra port. Get a Gigabyte MJ11-EC1 and a SFF-8654-4i to 4*SATA breakout cable—under 100 € total, and the cable is much thinner than its SFF-8087 equivalent.