You should not attempt to write LTO tapes from HDDs.
You need to write them from NVMe SSDs, to ensure an adequate write throughput. The NVMe SSDs could be on a different computer, if you have an intermediate Ethernet connection that is fast enough, of at least 10 Gb/s where the line rate is really reached (but 25 Gb/s Ethernet may be needed for the latest LTO variants).
If you have enough memory on the computer where the tape drive is attached, you can use a RAM drive to store a file before writing it to the tape, and then it does not matter from where the file comes. This is actually what I do, the server with the tape drive has 128 GB of memory, so there is no problem to transfer there through the network 50 GB archive files into the RAM disk, from where the archive files are written to the tape.