Step 5 - cable
For starters : The length of the cable does effect the RSSI (see below why I choose a better then average cable)
Materials used in this step :
1 x N Connector (quality)
1 x ?? m Aircell 7 (or better) length depend on you're requirement
1 x ?? Connector (quality) type depend on you're gateway antenna connector
Make the cable is strait forward but can be tricky for some people. When you haven't done it before, checkout some YouTube video's like this or this, or read some instruction manuals like this. Or ask help (maybe there is a local hamradio operator of group who can help you with it)
Some theory about coax cables (or why I choose the Aircell 7) :
For example, the cable I use is the AirCell 7 which has Typ. attenuation (dB/100m@20°C) of 19.0 dB for a frequency 800 Mhz and 21.52 dB for a frequency of 1000Mhz. (see : http://www.paratronic.fi/dokumentit/DB-Aircell7-UK-SF.pdf ) For 868 Mhz this will be result in a attenuation of aprx. 20 dB for 100m cable length (so the RSSI would affected with -20dB when a cable of 100m would be used). This is off-course non-realistic. But for my outdoor antenne I would use a cable with a length of 6m . That would result in a attenuation of aprx. 1.2 dB. So with that cable the RSSI would decrease with -1.2 when using the same antenna on the same location. against the antenna directly mounted to the gateway. For example when a node is received with a RSSI average of -64 with a direct connected antenna to the gateway, the node will be received with a RSSI average of -65.2 when the antenna is connected by the cable to the gateway (but with antenna on the same position).
Because we want to use a outdoor antenna with a gain of 6dBi. That antenne with cable would increase the RSSI from -64 - 1.2 + 6 = -59.2 Still a nice 6 - 1.2 = 4.8 dB gain over the stock antenna (assuming its cheap and has 0 dB gain). Placing it outside in clear view would remove the indoor attenuation (all materials between the node and the gateway will add attenuation) so the RSSI would be even better.
When using a cheaper but more common used consumer cable like the RG-58 with a attenuation of 70 dB for a length of 100m. A cable with a length of 6m would result in a attenuation of almost 4.2 dB. It sounds like much even with LoRaWAN who has a good signal to noise ratio a RG-58 could work out. But remember cutting 4.2 dB on the cable and gaining 6 dB on the antenne would result in a overall gain of just 1.8 dB.
But remember : Placing the antenne outdoor in a clear view would really expand the range of the gateway. IMHO, invest a little in quality. For example in Aircell 7 cables with quality connectors (or other low loss cable) and it will pay off. The most low-loss cables are most of the time professional stuff and the N type connectors are water proof (with outdoor antennes I always use N type connectors).